SAP Knowledge Base Article - Public

3192978 - Unbooked data with Data Access Control (DAC) not filtering correctly

Symptom

Data Access Control (DAC) enabled on both Dimension Level and Role level with Unbooked Data enabled shows all assets.

Environment

SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Log Into Tenant
  2. Go to a Model with Data Access Control enabled
  3. Ensure user is using both Role and Dimension Level Data Access Control.
  4. Ensure Unbooked Data is enabled
  5. Observe all assets show regardless of Data Access Control

Cause

By Design Behaviour

Resolution

By Design however workaround is as follows:

Define the filter in this way is to make sure “All Members” in the member selector is selected when creating the filter. If specific values are added to the filter explicitly then the filter will show those values regardless of what DAC setting was used behind the scene.

See Also

https://influence.sap.com/sap/ino/#/idea/260855

Keywords

KBA , LOD-ANA-ADM-DAC , Data Access Control , Problem

Product

SAP Analytics Cloud 1.0