The following behavior occurs in SAP Analytics Cloud (SAC) when creating a table in a grid or canvas page of a story:
- Errors Server Error EPM lookup error : message not found
This error may also appear:
A constraint of the dimension, which can't be aggregated, is violated: : These dimensions must not be aggregated, but are not in drill or filtered by a single member: [Version]. See 2457846 - A constraint of the dimension, which can't be aggregated, is violated error in SAP Analytics Cloud.
- SAP Analytics Cloud 2018.19.3
Reproducing the Issue
Create a table in a grid or canvas page of a story.
This error is caused by deleted or edited/updated master data for (fact) data stored in private versions or a public version in edit mode. (i.e. not yet published).
- For fact data stored in a private version, a look up to the corresponding master data occurs.
- If a private version was created and master data was deleted (or edited/updated), the fact data in the private version still refers to the deleted (or edited/updated) master data.
- Fact data in public versions are cleansed when master data changes (i.e. edit/update/delete) occur and fact data in private versions are not.
This error should disappear when filtering for one version, reverting or publishing changes to a public version in edit mode, or publishing changes to a private version.
- 2457846 - A constraint of the dimension, which can't be aggregated, is violated error in SAP Analytics Cloud
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
Your feedback is important to help us improve our knowledge base.
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem