Skip to Content
1
Jan 10, 2023 at 03:46 PM

SAP DWC Multiple DAC with OR Logic

276 Views Last edit Jan 10, 2023 at 03:48 PM 2 rev

Hello Experts,

can we create and apply row securities ( DAC ) with multiple logic in a good way?

For example if 1 report (imagine it get the data from an analytical dataset) is accessed by :
- users that need to view only specific companies information.

- users that need to view only specific sales org. information.

- users that need to view only specific material types information.

- users that need to view everything (no row securities applied).

can we do this without having a cardinal explosion in the source table/view for DAC ?

Or better,

-> can users be assigned to DAC (so DWC modeler users or power users can view everyting without maintaining records for these users in DAC source table/view) ?
and

-> can DAC be set to work in an OR logic istead of an AND logic when applied to views? => so some users are assigned to a DAC that filter on company, other user are assigned to another DAC that filter on material type and so on.

This is the logic of Hana Modelling analytic privileges and roles, that give great flexibility in defining securities.

an ( i hope you agree), it is a BASIC FEATURE and a MUST to have in DWC.