SAP Knowledge Base Article - Public

3138316 - After submitting prompt values, the hierarchy gets removed and it is displaying as flat list in SAP Analytics Cloud (SAC)


  • The hierarchy gets removed and displays as a flat list in a table after the prompt values are submitted.
  • In optimized view mode hierarchy display remains even after submitting prompt values.


  • SAP Analytics Cloud 

Reproducing the Issue

  1. Create a table with hierarchy display.
  2. Submit prompt values.
  3. Observe hierarchy is removed and it displays as flat list.


  • This is a by design behavior.
  • Hierarchy variable submit on a story applies to all widgets in the story.


  • To prevent a specific table to be updated after a story variable submit, use the option 'Set Table Variables' (local variables).
  • Click on  in the table header, and then select the option 'Set Table Variables'.

See Also

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


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, sap analyst cloud, connected, failure, stopped, sap analyst cloud,, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-TAB , Table , Problem


SAP Analytics Cloud all versions