SAP Knowledge Base Article - Public

3478004 - DAC in Datasphere does not apply in SAC when hierarchy view is set to flat in SAP Analytics Cloud (SAC)

Symptom

In DWC (Data Warehouse Cloud or Datasphere), you have set up DAC (Data Access Control) at the dimension level.  However, when the dimension is consumed in SAC (SAP Analytics Cloud), if the hierarchy is set to "Flat Presentation", then the DAC set up in DWC is not applied

Environment

  • SAP Analytics Cloud 2024.8.10

Reproducing the Issue

  1. Set up DAC in DWC at the dimension level
  2. Consume that dimension in SAC
  3. Set the Hierarchy view type to Flat Presentation
  4. Note that DAC is not applied

Cause

SAP Analytics Cloud does not support protecting the data shown in Analytic Preview through DACs set up in the associated dimensions.

Resolution

Workarounds:

  • Create a view of the dimension in DWC and then create a second DAC to apply at that level; OR
  • In SAC set the presentation to anything other than Flat Presentation.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

DWC, Datasphere, DAC, Data, Control, Security, rights, flat, hierarchy, view, dimension , KBA , LOD-ANA-DES , Story Design & Visualizations , DS-AUT , Authorizations (Locks, etc.) , Problem

Product

SAP Analytics Cloud 1.0