3402196 - The widget no longer displays data when changing the hierarchy of the Time dimension from "Year, Half-Year, Quarter" to "Year, Quarter" in SAP Analytics Cloud

• The widget no longer displays data when changing the hierarchy of the Time dimension from "Year, Half-Year, Quarter" to "Year, Quarter" in SAP Analytics Cloud.
• In the model, the Time dimension is a System-Managed dimension and the default hierarchy is set to "Year, Half-Year, Quarter".
• Even when changing the default hierarchy of the Time dimension to "Year, Quarter", the widget continues to display no data.

SAP Analytics Cloud (Enterprise) 2023.21.6 

1. Log on to SAP analytics Cloud tenant
2. Create a model with measures and a System-Managed Time dimension 
3. Set the default hierarchy for this dimension to "Year, Half-Year, Quarter"
4. Create a story using this newly created model
5. Add a chart and/or a table to this story
6. Add a measure and the time dimension to this widget
7. Set the hierarchy of the time dimension to "Year, Half-Year, Quarter"
8. Save the story
9. Change the hierarchy of the time dimension to "Year, Quarter"
10. Note the massage: No data is available for the chart/table to render on the widget
11. Go back to the model and change the default hierarchy of the Time dimension to "Year, Quarter"
12. Edit any calculated measure that uses the Time dimension and make few changes to it
13. Save the model
14. Go back to the story and refresh it
15. Note that the widget displays data when the hierarchy is set to "Year, Quarter".

This issue is a known limitation of Time Hierarchy when working with Accounts.

Please refer to the SAP Help Page: Dynamic Time Navigation Functions.
Note:

• If you use the dynamic time navigation functions, the time dimension needs to be part of the drill state. Consider adding the time dimension to the list of required dimensions so that a story builder adds the time dimension to the drill state.
• In stories, use the default date hierarchy when working with accounts that use dynamic time navigation. When a widget doesn’t use the default date hierarchy, these accounts don’t show any data.
  • i.e. dynamic time functions created in the modeler only work with the default time hierarchy, which was set when the formula was created.
• If the user wants to use the formula with a different hierarchy you need to set that hierarchy as the default hierarchy and rebuild the dynamic time formula.

• 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?
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAC, SAP analytics Cloud, Import model, Measure, Dynamic, Time, Dimension, Account, Limitation, Default, Hierarchy, "Year, Half-Year, Quarter", Chart, Table, Widget, Hierarchy, "Year, Quarter", "No data is available" , Refresh, No data, Display, No longer, Not. , KBA , LOD-ANA-ML-CAL , Calculation Management , Problem