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
- Set up DAC in DWC at the dimension level
- Consume that dimension in SAC
- Set the Hierarchy view type to Flat Presentation
- 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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
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