SAP Knowledge Base Article - Public

3238114 - Calculation input control for Items that have hierarchies are not allowing flat presentation in SAP Analytics Cloud.

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

Resolution

1.This is known limitation kindly vote for below improvement request.

 Improvement Request Details - Customer Influence (sap.com)

2.You can use below workaround for now.

As a workaround,

a. Edit the calculation input control

b. change the value of "Show Hierarchy" from flat to different value. 

c. select all individual values excluding the Parent Hierarchies. 

d. This might allow to display the values as Flat presentation without any error in Restricted measure.

Keywords

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

Product

SAP Analytics Cloud all versions