SAP Knowledge Base Article - Public

3415391 - Data for Totals are displaying incorrectly for lower hierarchy levels in the story in SAP Analyitcs Cloud (SAC)

Symptom

  • Data for Totals are displaying incorrectly for lower hierarchy levels in the story in SAC.
  • Totals are calculating only the higher hierarchy level and not the lower level.
  • Reproducible both in Classic and Optimized Design Experience (ODE) story mode.
  • Reproducible both with table and chart.

Environment

SAP Analytics Cloud (Enterprise) 2023.21.8

Reproducing the Issue

    1. Login to SAC.
    2. Create a story and insert a table or chart.
    3. In the Builder panel, select as a dimension a hierarchy dimension and a measure.
    4. In the widget drill down e.g. to the lowest hierarchy level.
    5. Select Show Totals for the hierarchy dimension in the Builder panel.
    6. Compare the values for the totals and the selected hierarchy level e.g. to the lowest hierarchy level => values will be different. Totals are calculating the upper hierarchy level and not the selected lower level.

    Cause

    This issue is currently under investigation by development.

    Resolution

    This issue is currently under investigation by development.

    See Also

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

    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, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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 epm, business intelligence , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

    Product

    SAP Analytics Cloud 1.0