SAP Knowledge Base Article - Public

3088551 - Filtering on a chart with a time dimension and drilling to any level other than the root shows incorrect results in SAC

Symptom

When filtering on a chart that has a time dimension which is drilled to any level (other than the root), the results displayed on the chart are for deeper levels than the level selected for filtering.
The results returned depend on the original level the chart was filtered on, before applying the filter.
If the filter is applied at page filter level (Input Control), the results match the chart original level.

Environment

  • SAP Analytics Cloud (SAC) 2021 QRC2

Reproducing the Issue

  • Scenario 1 : Filter on a drill down
    1. Create a bar chart base on a model or dataset with TIME dimension.
    2. Click the hierarchy button. And choose to display Level 2.
    3. Set a filter to the TIME dimension object.
    4. The display result is to the next drill down level.

  • Scenario 2 : Page Filter on a TIME dimension
    1. Create a bar chart base on a model or dataset with TIME dimension.
    2. Add a Page Filter to the TIME dimension.
    3. Display result is kept to Level 2.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Keywords

drilldown, drill down, 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, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions