Symptom
The following error message occurs in SAP Analytics Cloud (SAC) when you try to create a model with the BPC datasource:
- The dimension couldn't be loaded.
- In the developers tool (F12) -> Console tab, you see the following error:
- message: "Object DIMENSION:t.3.xxxxxxx:<dimension name> was not found or you do not have permissions to read it."
messageId: "OBJECT_NOT_FOUND"
status: 404
message: "Object DIMENSION:t.3.xxxxxxx:<dimension name> was not found or you do not have permissions to read it."
stack: ""
status: 500
- message: "Object DIMENSION:t.3.xxxxxxx:<dimension name> was not found or you do not have permissions to read it."
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Log in to the SAC tenant
- Go to Modeler > From a Data Source > SAP BPC for SAP BW/4HANA or other BPC data sources
- Select the Connection
- Create a new query
- Select the BPC environment and model
- Select the fields and do the mapping and set the filters if needed
- Click 'Finish' and see the error message
Cause
It is caused by the attribute "DESCRIPTION" of the BPC dimension corresponding to the SAC dimension recorded in the F12 console error.
"DESCRIPTION" is a reserved key of dimension.
Resolution
If it is possible to update the BPC dimension, we would suggest you try:
delete "DESCRIPTION" or replace it with another name. e.g. "DESC" (BPC doesn't support modify attribute name, you may need to delete "DESCRIPTION" first and then add a new attribute).
Keywords
Object DIMENSION:t.3.xxxxxxx:<dimension name> was not found or you do not have permissions to read it, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem