SAP Knowledge Base Article - Public

3290506 - Measures without hierarchy not available after creating calculation.

Symptom

After a calculation has been made to the model other measures become not available.

Environment

SAP Analytics Cloud version: 2022.21.9

Reproducing the Issue

  1. Log into tenant
  2. Create a model based on test data with no calculations
  3. Create a story with the newly created model.
  4. Create a chart with account as column.
  5. Set account filters as the 2 members to be used in the calculation. Observe that the members are visible in the table. 
  6. Navigate back to the model and create a calculation using the 2 members.
  7. Navigate to story and observe that after calculation the measures are not displaying.
  8. Set account filters and observe that the 2 members are still in selected members but aren't displaying.
  9. Select the calculation and observe it appear in the chart.
  10. Navigate back to account filters and observe that the 3 measures are in the selected members tab but only the calculation displays.

Cause

Created calculation contains <root> in hierarchy where as the other measures don't.

Resolution

Workaround: Add <root> to hierarchy of measures that are not available. 

Issue is known to the development team and will be fixed in 2023.04.

See Also

Keywords

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions