Symptom
When creating a calculation input control from a restricted measure calculation, the below error is shown:
- "The hierarchy type used in this calculation input control does not match the hierarchy type used in the chart."
Environment
SAP Analytics Cloud All versions
Reproducing the Issue
- Login to sac.
- Go to stories section and create a new story.
- Add a widget (table or chart) and go to designer panel.
- Go to measures and create a new calculation in case of a chart or add a calculation selecting the three dots of "Measures" in case of a table.
- The calculation screen will be displayed, choose restricted measure type, select a measure and a dimension.
- Choose "new calculation input control" in the "values or input controls" section.
- A calculation input control screen will be displayed, click on the values input section.
- You will be prompted to select the values, choose the flat presentation hierarchy type and select all members then validate the calculation input control creation.
- An error is immediately displayed "The hierarchy type used in this calculation input control does not match the hierarchy type used in the chart. "
Cause
This is currently a product limitation.
Resolution
- This is known limitation. Kindly vote for the improvement request below.
Improvement Request Details - Customer Influence (sap.com)
- You can use the workaround below for now.
As a workaround,
- Edit the calculation input control.
- Change the value of "Show Hierarchy" from flat to different value.
- Select all individual values excluding the Parent Hierarchies.
- This might allow to display the values as Flat presentation without any error in Restricted measure.
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 a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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 Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAC, enhancement, calculation, restricted measure, flat presentation, hierarchies, , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud all versions