SAP Knowledge Base Article - Public

3238114 - Calculation input control for Items that have hierarchies are not allowing flat presentation

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 

Reproducing the Issue

  1. Login to sac.
  2. Go to stories section and create a new story.
  3. Add a widget (table or chart) and go to designer panel.
  4. 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.
  5. The calculation screen will be displayed ,choose restricted measure type, select a measure and  a dimension.
  6. Choose "new calculation input control" in the "values or input controls" section.
  7. A calculation input control screen will be displayed, click on the values input section.
  8. 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.
  9. 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 issue is currently under investigation by development

Resolution

This issue is currently under investigation by development

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions