SAP Knowledge Base Article - Public

3698193 - Calculation input control for Items that have hierarchies are not allowing flat presentation in SAP Analytics Cloud (SAC)

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

  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 is currently a product limitation.

Resolution

  • You can use the workaround below for now.

    As a workaround,

    1. Edit the calculation input control.
    2. Change the value of "Show Hierarchy" from flat to different value. 
    3. Select all individual values excluding the Parent Hierarchies. 
    4. This might allow to display the values as Flat presentation without any error in Restricted measure.

See Also

Keywords

SAC, enhancement, calculation, restricted measure, flat presentation, hierarchies,  , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0