Symptom
- The Date Formatting displayed in the Live Stories does not match the Date Formatting set in the Profile Settings.
- Date Formatting in the Profile Settings is set to dd-MM-yyyy (e.g. 13-01-2024), but in Live Stories it is displayed as MM/dd/yyyy format (e.g. 01/13/2024).
Environment
SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Logon to SAP Analytics Cloud
- Open the story based on a Live data Connection
- Look for the Date dimension and note that it is displayed as MM/dd/yyyy format (e.g. 01/13/2024)
- Check your Profile Settings and note that the Date Formatting is set to dd-MM-yyyy format (e.g. 13-01-2024)
- Change the Date Formatting to dd.MM.yyyy format (e.g. 13.01.2024)
- Go back to the story and note that the Date dimension is still displayed as MM/dd/yyyy format (e.g. 01/13/2024)
Cause
The Date dimension is set to be displayed using the ID.
Resolution
Set the Date dimension to be displayed using the description.
- In the builder panel, find the desired Date dimension
- Hover over the Date dimension and click the three dots to display more options
- Hover over Display Options
- Click on Description
See Also
- 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?
- 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.
Keywords
SAC, SAP Analytics Cloud, Story, Live, Date dimension, Profile, Not, Change, Display, Shown, Match, Mismatch, Different. , KBA , LOD-ANA-UNS-DSG , Unified Story Designer Issues , LOD-ANA-DES , Story Design & Visualizations , How To
Product
SAP Analytics Cloud 1.0