SAP Knowledge Base Article - Public

3002640 - When directly using Properties as dimension, only the data in leaves of the hierarchy is shown in SAP Analytics Cloud (SAC)

Symptom

  • When directly using Properties as dimension, only the data in leaves of the hierarchy is shown in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud (Enterprise) 2020.23

Reproducing the Issue

  1. Create a model with a hierarchy dimension.
  2. In this hierarchy dimension, create custom properties.
  3. Import data to this model.
  4. Based on this model, create a story.
  5. Add a table, and add this hierarchy dimension into this table.
  6. For this hierarchy dimension, click Properties -> Set visible properties, select some properties to show.
  7. Add the properties dimension directly into the table.
  8. Compare and find, when use Properties object as dimension directly, it only show data for the leaves level.

Cause

  • Repetitive Member Names are not enabled under Table properties.

Resolution

  • Right click on the dimension, and go to Table actions -> Show/Hide -> Repetitive Member Names.
  • More information about different Table Menu Options can be found here: Table Menu Options on Story Pages

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

Product

SAP Analytics Cloud 1.0