How to add multiple conditions in a DAC in DWC and exclude users of an DAC?

[chrisesco]

I would like to know if there is a default way in DWC to add multiple conditions to a user?

I checked this answer How to add multiple attributes in authorization in DWC in the community where they mention a solution that I did not understand very well, do you know an default alternative for it?

Also, how can I exclude users from the DAC, so that they do not have restrictions?. Currently, I must enter them in the authorization table, otherwise they will not be able to see the data in the history if the DAC is applied.

Thanks for your help.

[XaviPolo · Accepted solution]

Hi,

You can't exclude users from DACs, you must add all the combinations for the dimension to users that need to see all values.
What we usually do to feed a DAC is to generate a view that makes a cross join between the users that have to see everything and the master data of the dimension, this generates all the combinations. Then we make the union with the table that has the normal data for the DAC.

For multiple conditions you can add more fields to DAC, and when apply the DAC jto the view ust make the join using multiple fields.

Regards,

[chrisesco · Accepted solution]

Thank you Xavier for your answer, now it is clearer to me. But I still have a doubt, in the last step "union with the table that has the normal data for the DAC" I'm a little lost, what is for you the normal data for the DAC?

I would feed the DAC for these "Root users" with the View Join Cross (table with emails and view with dimensions) simply and then I would apply the DAC.

Thanks for your help.

[XaviPolo · Accepted solution]

An example with a table with users and companies that they can see (Base table for DAC😞

user1@email.com -> 2310
user2@email.com -> 2310
user2@email.com -> 2410
...

A table with users that can show all companies (Root Users)
user4@email.com
user5@email.com
...

And the master data for Companies
2310
2410
...

With that you can create a view to do:

A cross join between Companies and Root Users to get all the combinations because a root user can see all comparies
user4@email.com -> 2310
user4@email.com -> 2410
user4@email.com -> ...
user5@email.com -> 2310
user5@email.com -> 2410
user5@email.com -> ...
...

then UNION this cross join with the "Base Table for DAC"

user1@email.com -> 2310
user2@email.com -> 2310
user2@email.com -> 2410
...

user4@email.com -> 2310
user4@email.com -> 2410
user4@email.com -> ...
user5@email.com -> 2310
user5@email.com -> 2410
user5@email.com -> ...
...

Now this view returns a complete list, people that can see only specific companies and people that can see all companies, and can be used as a source for the DAC.

I hope it helps