SAP Knowledge Base Article - Public

2481888 - Charts are not showing correct value when using filters and linked analysis in SAP Cloud Analytics

Symptom

  • Linked analysis within the charts (Bar charts, Numeric point chart) during drill down and drill up are not giving expected results.
  • After defining filter and drilling down a time dimension and then drill up the values are not correct in the Story.
  • The issue is reproducible only when adding or removing a filter of a time dimension, when only drilling up or drilling down works properly.
  • Filter + drill down + drill up results in seemingly inconsistent data in driver vs. other charts.

Environment

  • SAP Analytics Cloud 2017.9.3

Reproducing the Issue

  1. Create a story with Time dimension.
  2. Create a story filter on Time dimension (in the form of date range)
  3. Create a bar chart with KPI displayed across Time dimension (highest level being year).
  4. Filtered chart to see data for a year (say 2016).
  5. Drill down to quarter level.
  6. Drill up to year level.(data will be displayed for year 2016).    

Cause

This is the expected behavior, as after drilling up, the time data in other charts is unfiltered because the story filter is set to All.

Resolution

This behaviour is by design, as non-exclude chart filters will always replace story filters on the same dimension.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC , 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 , Problem

Product

SAP Analytics Cloud 1.0