3334971 - Date dimension with hierarchy results in error in Times-series chart in SAP Analytics Clouds (SAC)

• Story based on DS view contains two very similar dimensions: TimestampDayLevel (Day) and TimestampDayLevelString (Day string).
• The only difference is the data type: first one is of type "Date", second one of type "String(100)". 
• Both dimension are linked via associations to the same dimension view with a hierarchy.
• In the SAC story, in time-series chart only the dimension of type date (-> Day ) is visible, but when selecting error notification appears under the time-series chart: The chart can’t be displayed because one or more dimensions that the chart requires have been altered in the model.  and the dimension Date is no longer visible in Builder panel > Time. The dimension of string type (Day string)  is not even visible

• SAP Analytics Cloud  2023.2.11 
• LIVE data connection to SAP DataSphere (DS)

1. Log on to customer tenant
2. Go to the affected story 
3. Go to the affected time-series chart
4. Notice error under empty chart: Time dimension is required to build a Time Series chart
5. Go to Designer > Builder panel 
6. In the time section notice that only Date is visible
7. Choose Date dimension with hierarchy
8. Notice that error under chart changed to The chart can’t be displayed because one or more dimensions that the chart requires have been altered in the model.
9. Notice that in Designer > Builder panel > Time there is no Date dimension with hierarchy anymore

This issue is currently under investigation by development.

This issue is currently under investigation by development.

• 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 an incident for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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 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.

SAP Analytics Cloud (SAC), SAC, Times-series chart, Times-series, chart, builder panel, builder, panel, Date dimension with hierarchy, date, dimension, time, hierarchy, error, error message, notification, missing, visible, available, not visible, not available, select, selected, not appear, DWC, Data Warehouse Cloud, Datasphere, data type, string, linked association , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem