Symptom
- The Week Date Dimension Dynamic Filter is not working after converting a story from Classic to Optimized Mode in SAP Analytics Cloud.
- The issue does not occur in the Classic Design Experience.
- The Optimized story does not recognize Dynamic filter created on top of Week Dimension and all widgets are appearing blank due to this with a error message "failed to fetch data"
Environment
SAC Analytics Cloud 2025.1.6
Reproducing the Issue
Import Connection from BW.
- Log into SAC
- Go to files > Open Classic Story > (note that every widget is working properly)
- Go to files > Open converted story (ODE) > (note that the widgets are not working and a error message is being displayed: 'failed to fetch data')
- Also, when forcing the date range filter, an error message is displayed: "SQL ERROR: Error in Value Lookup for the variable: xxx. For more details, see SQL Exception"
Cause
The error in the optimized story is due to a new feature that's implemented for optimized stories that are not available in classic stories - Flexible Time (https://community.sap.com/t5/technology-blogs-by-sap/introducing-flexible-time-in-sap-analytics-cloud/ba-p/13528946). The problem is that the dimension does not have a current date row that needs to be populated.
There is an error from the backend that indicates this:
- "No valid date can be found in masterdata for current date. All masterdata entries are in the past of the current date. Please extend your masterdata to the future."
Also, it seems the dimension is missing a lot of data which could result in data correctness issues. The Date column has lots of gaps. For example, there is no 2025-03-11.
For the Flexible Time feature to work properly, gaps are not allowed in the Date column.
Resolution
As a workaround, the custom date feature can be applied to create a custom date that the range filters can use.
- Click on 'edit filter' > it will open the Range Dialog
- Under 'Current Date' there will be a dropdown where a Current Date Input Control can be created. Creating one for the desired week will allow using the range filter again like in the classic stack.
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?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- 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!
Keywords
SAC, date, filter, dynamic, range, dimension, SAC, error, converted, optimized, classic, converting, failed to fetch data, no data for this range, error after QRC , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem
Product
Attachments
Pasted image.png |
Pasted image.png |