SAP Knowledge Base Article - Public

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


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


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


By Design Behaviour


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


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


SAP Analytics Cloud 1.0