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
- 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
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.
KBA , LOD-ANA-ADM-DAC , Data Access Control , Problem
SAP Analytics Cloud 1.0