SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

SAP Analytics Cloud (Enterprise) 2023.21.6 

Reproducing the Issue

  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".

 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAC, SAP analytics Cloud, Import model, Measure, Time, Dimension, Default, "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 , SAC Modelling , Problem

Product

SAP Analytics Cloud all versions