SAP Knowledge Base Article - Public

2948542 - [How-to] Display dimension by flat format instead of hierarchical display in story in SAP Analytics Cloud ?

Symptom

  • [How-to] Display dimension by flat format instead of hierarchical display in story in SAP Analytics Cloud ?  

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Create a Story.
  2. Add a Cross-tab in Story, select sample model "BestRunJuice_SampleModel".
  3. Add [Date] to Rows, [Account] to Columns. 
  4. Check the display of table, [Date] is displayed by hierarchical format.
    Initial display.png

Resolution

  1. Right Click on the dimension. Choose Select Hierarchy.
    Right click on date.png
  2. Select Flat Presentation.
    Flat presentation.png

See Also

Expanding Hierarchies in a Chart - SAC Help guide (2020.8)

Keywords

hierarchy, drill, drill down, drill through, level, 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, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , How To

Product

SAP Analytics Cloud 1.0