We have a set of users who should on be restricted to see the data for a particular region. What is the best way to achieve it in Dundas.
For example I have User1, User 2 , User 3 …
And regions as NA , GCG , AP
I want User 1 to see only NA Data
I want User 2 to see only AP data
I want User 3 to see everything (all regions)
Note : We are using only one data cube and one de normalized table where we have this entire data.
Thanks in Advance.