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
- Log Into Tenant
- Go to a Model with Data Access Control enabled
- Ensure user is using both Role and Dimension Level Data Access Control.
- Ensure Unbooked Data is enabled
- 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
Keywords
KBA , LOD-ANA-ADM-DAC , Data Access Control , Problem
Product
SAP Analytics Cloud 1.0