SAP Knowledge Base Article - Public

3350829 - Cannot select "Flat Presentation" option when selecting values or Input control for dimension during creating restrict measure in SAP Analytics Cloud (SAC)

Symptom

  • Cannot select "Flat Presentation" option when selecting values or Input control for dimension during creating restrict measure

Environment

  • SAP Analytics Cloud (Enterprise) 2023

Reproducing the Issue

  1. Create a story based on any model with hierarchy object.
  2. Add a table with the hierarchy dimension in the story.
  3. Add filter for a hierarchy dimension, note In Show Hierarchy field, Flat Presentation can be selected.
  4. Try to create a restrict measure, add Values or Input Controls for the hierarchy dimension, note only "Hierarchy" can be selected, no, "Flat Presentation" option can be selected.

Cause

  • This is by design.
  • For calculations, the member selection will not show the Flat Presentation, its applicable to all types of calculations and cross calculations.

Resolution

  • Use "Hierarchy" for calculations.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP 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,Error, Issue,  BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, stopped, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0