Symptom
- When creating a dimension input control in SAP Analytics Cloud story based on Live BW model, the hierarchy option is not available for one hierarchical dimension for which Activate Hierarchy Display is not enabled in query
- The hierarchy option is available when putting same dimension into Builder panel
Environment
- SAP Analytics Cloud (Enterprise)
- SAP BW/BW4HANA
Reproducing the Issue
- Log on to SAC tenant.
- Create one Live BW connection.
- Create one model based on the Live BW connection to one query containing:
- One hierarchical characteristic [A] with Activate Hierarchy Display enabled
- Another hierarchical characteristic [B] with Activate Hierarchy Display disabled.
- Create a story with chart/table based on the Live BW model.
- Add both [A] and [B] into Dimensions in Builder panel.
=> Confirm that the hierarchy option is available for both dimensions.
=> By clicking Set Hierarchy button, one default hierarchy is selected for [A] while Flat presentation is selected by default for [B]. - Create one new Dimension Input Control.
=> Under Available Dimensions in pop-up dialog, hierarchy option is available for [A] but not available for [B].
Cause
This issue is caused by a limitation in the product.
Resolution
- There is already an improvement request submitted where you can also vote up: Select hierarchy not available when using a dimension input control
- Workaround: Enable Activate Hierarchy Display for the dimension/characteristic in BW query.
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?
- 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
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
AP 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, Dimension, input control, filter, selection, hierarchy, default, activate, active, option, appear, display, show, shown, available, unavailable , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem