When using a Date type dimension in a page or story filter and you add a variance, the following error or warning message occurs in SAP Analytics Cloud (SAC):
- Unable to retrieve data from the datasource.
- Variance on time does not support having a story/page/group filter and a chart filter defined on the Date dimension at the same time.
- SAP Analytics Cloud 2019.4.5
Reproducing the Issue
- Add Date as dimension and a measure in a line chart
- Add a filter on the Date dimension by range
- Add a variance analysis and select Date as dimension
- Error occurs Unable to retrieve data from the datasource. Variance on time does not support having a story/page/group filter and a chart filter defined on the Date dimension at the same time.
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Bug Filed