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
-
Create a model with a hierarchy dimension.
- In this hierarchy dimension, create custom properties.
- Import data to this model.
- Based on this model, create a story.
- Add a table, and add this hierarchy dimension into this table.
- For this hierarchy dimension, click Properties -> Set visible properties, select some properties to show.
- Add the properties dimension directly into the table.
- 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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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