SAP Knowledge Base Article - Public

3555511 - SAP Analysis for Microsoft Office does not support DAC(Data Access Control) in SAC

Symptom

In SAC, DAC(Data Access Control) has been set for users in a SAC model or in a public dimension, it works fine in a SAC story, however does not work in SAP Analysis for Microsoft Office(AO), data displayed in SAC story and in AO are different.

Environment

  • SAP Analytics Cloud
  • SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Set Data Access Control for a SAC model or a public dimension, so that user can only see value 'a' for dimension A.
  2. Confirm it works in SAC story, user can only see value 'a' for dimension A.
  3. Open AO, login SAC with same SAC user.
  4. Insert same SAC model.
  5. Confirm the Data Access Control does not work in AO, user can also see all the other values than value 'a' for dimension A.

Cause

Product design; Product limitation

Resolution

In AO, SAC DAC(Data Access Control) is not supported. In general we recommend to use SAC Excel add-in instead for all SAC related scenarios including planning and Data Access Control. 

Keywords

SAP Analysis for Microsoft Office, AO, A4O, Analysis Office, access, authorization, data limit, data limitation, data difference , KBA , BI-RA-AO-XLA , Excel Addin , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analysis for Microsoft Office all versions ; SAP Analytics Cloud all versions