SAP Knowledge Base Article - Public

2719687 - EPM lookup error : message not found - Error when creating a story table in SAP Analytics Cloud

Symptom

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.

Environment

  • SAP Analytics Cloud 2018.19.3

Reproducing the Issue

Create a table in a grid or canvas page of a story.

Cause

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).

Note:

  1. For fact data stored in a private version, a look up to the corresponding master data occurs.
  2. 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.
  3. 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.

Resolution

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.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

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

Product

SAP Analytics Cloud 1.0