Symptom
- Below error message would appear when saving or creating the seamless planning public account dimension in SAC system:
Failed to execute select "VALUE" as "HIERARCHY"
from "TENANT_XXXX"."sap.fpa.services.modeling::SplitToTable"('parentId')
where "VALUE" not in (
select "HIERARCHY" from "XXXXXX"
where "NODEID" = ?
). Component = DbHelper. Reason = invalid schema name: XXXXX: line 2 col 23 (at pos 52) - This issue seems to only occur on the seamless planning Account dimension. This issue would not occur on seamless planning Generic dimension.
- This issue would not occur on Local Public Dimensions as well
Environment
Reproducing the Issue
- Log onto SAC
- Navigate to Modeler-> Public Dimension Tables
- Click on "Dimension Tables" to create a new public dimension table
- On the following "Data Storage Location" panel, select the Data Storage Location as SAP Datasphere space
- On the following "Create Dimension Table" panel, select the type as Account and enter a name for this Account dimension
- Add a member into this dimension table and save this change
=> Observe below error message would appear:
Failed to execute select "VALUE" as "HIERARCHY"
from "XXXX"."sap.fpa.services.modeling::SplitToTable"('parentId')
where "VALUE" not in (
select "HIERARCHY" from "XXXXX"
where "NODEID" = ?
). Component = DbHelper. Reason = invalid schema name: XXXXX: line 2 col 23 (at pos 52)
Cause
This issue is under investigation by development.
Resolution
This issue is under investigation by development.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAP Analytics Cloud, SAC troubleshooting, SAC connection error, SAC data import issue, SAC model setup, SAC live connection, SAC acquisition connection, SAC tenant configuration, SAC authentication error, SAC integration issue, SAC dashboard creation, SAC performance optimization, SAC error handling, SAC system outage, SAC data modeling, SAC user access issue, SAC connectivity troubleshooting, table, dimension, datasphere, seamless , KBA , LOD-ANA-ML , SAC Modelling , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public