SAP Knowledge Base Article - Public

3290506 - Measures without hierarchy not available after creating calculation.


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


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.


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


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


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


SAP Analytics Cloud all versions