SAP Knowledge Base Article - Public

2872901 - "Unrestricted Drilling" settings causes incorrect calculation result in SAP Analytics Cloud (SAC)

Symptom

"Unrestricted Drilling" settings causes incorrect calculation result in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2020.1.2

Reproducing the Issue

  1. Create a story on a model which has Measure & Date with hierarchy, e.g. 2017 ~ 2019 with quarters and months.
  2. Add a table in story with Date and Measure.
  3. Create a new restricted measure with Values "Previous Year", add it to the table.
  4. Check only data of 2018 & 2019 being shown in the restricted measure which is right because there is no previous data for 2017.
  5. Add a filter on Date (Range) with all default settings. E.g. Dynamic type, Range: 2019, "Unrestricted Drilling" enabled.
  6. Confirm the restricted measure data is shown as empty now which is not right.
  7. Disable the "Unrestricted Drilling" in the filter.
  8. Confirm the restricted measure data is shown as same as step 4 which is right.

* If the filter is set to Fixed type, Range: 2017~2019, "Unrestricted Drilling" enabled, still the restricted measure data is shown normal.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

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, drill , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0