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 (Enterprise) 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

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

There are two current workarounds:

  1. Create a view of the dimension in DWC and then create a second DAC to apply at that level
    or
  2. 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