SAP Knowledge Base Article - Public

2913169 - Unable to get variance based on combination of versions and time periods in SAP Analytics Cloud (SAC)

Symptom

  • Unable to get variance based on combination of versions and time periods in SAP Analytics Cloud (SAC)
  • A simple bar char with a variance that shows the percentage change compared to previous period does not work if you have multiple versions

Environment

  • SAP Analytics Cloud (Enterprise) 2020.2.10

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Bar/Column chart based on planning model containing multiple versions.
  3. Add the time dimension into Dimensions and then set Hierarchy Level to Level 3 to show data in month or quarter.
  4. Add Variance to compare measures between Current Period and Previous Period.
    => The variance will appear correctly in each data point of chart.
  5. Click + Add Version/Time and then pick version dimension from list in Edit Variance panel.
    => It doesn't generate the expected comparison across 'mixed' versions and 'pivot' such as FORECAST for Q1 2017 - ACTUAL for Q4 2016.

Cause

  • This is limitatio of current SAC version.

Resolution

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, variance, version, time, date, mix, er , KBA , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement

Product

SAP Analytics Cloud 1.0