3616822 - When removing a dimension with Hierarchy set as "Show only leaves in widget" in Table, the data keeps unchanged.

• The hierarchy filter seems still applied although the dimension itself has been removed.
• The structure hierarchy is used.
• Show only leaves in widget is enabled.
• Data Source is Datasphere Live Model.

SAP Analytics Cloud 2025.1.14.

1. Select Table in Edit mode and remove the dimension from Rows.
2. Observe that data result does not change even if the dimension is removed. The indirect hierarchy of the removed dimension still influences the result of the table.
3. Add the dimension again to Rows.
4. Change its hierarchy to Flat Presentation manually.
5. Observe that now the data got changed. 

The issue is due to the "Show only leaves in widget" filter on the dimension hierarchy which stays in the table definition after the dimension was removed from the table.

The development team is working on the fix. Before the fix deployment, please use the below workaround instead:

1. Edit the story.
2. In the impacted table, add again the issued dimension.
3. Select this dimension header and click "Select Hierarchy".
4. Unselect the "Show only leaves in widget" option and click Set.
5. Remove the dimension from the table. The issue should be solved.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

sap analytics cloud, filter issue, hierarchy filter, table dimension, data selection, show only leaves in widget, intransparent data selection, data visualization, story filter, SAC, Datasphere, live model, query, live connection, space, analytic , KBA , LOD-ANA-TAB , Table , Problem