How to provide All access using DAC in SAP Datasphere

[former_member853922]

I am trying to build a DAC in SAP Datasphere which can restrict access based in comp code. But the same view needs to be used by some super user who should have access to the whole dataset irrespective of the conditions.

I am unable to do it. Kindly help.

Regards,

Tanumay Banerjee.

[thorebedey]

Hi,

I have performed this for a customer. (in my case it is not CompCode but MARKTID)

you can do this through a mapping table where you have your comp code mapped to a column that says "ALL" see: 2023-05-23-12-30-41.png

This table you join to your normal DAC table (see: 2023-05-23-12-35-17.png) and add a calculated column with the coding "case when MarktID is null then Marktvalue else MarktID end".

Then it should restrict the users for their specific company codes and for users with ALL access, they will get ALL.

Feel free to come back questions.

BR,

Thore