SAP Knowledge Base Article - Public

2770397 - 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 in SAP Analytics Cloud (SAC)

Symptom

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.

Environment

  • SAP Analytics Cloud 2019.4.5

Reproducing the Issue

  1. Add Date as dimension and a measure in a line chart
  2. Add a filter on the Date dimension by range
  3. Add a variance analysis and select Date as dimension
  4. 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.

Cause

Limitation.

Resolution

See 2748851 - Limitation: Measures with dynamic time calculation and story/page filter can't be displayed in SAP Analytics Cloud.

See Also

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

Keywords

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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Bug Filed

Product

SAP Analytics Cloud 1.0