Skip to Content
0

IDT Multi Level Security

Dec 13, 2016 at 02:07 AM

35

avatar image

Hi,

I checked below Youtube video.

https://youtu.be/X9DJuV0_vY4

Our scenario requires security to applied at more than one dimension as in Area, City, State and region. Area manager will have access to only Area and City Manager to have access to all Area and City.

All above dimensions are available in the main fact table. Question is should I create a table with all above field and have user id as one more column and then link it in IDT? If yes how do I add filter?

Can someone please shed light?

Thanks,

Prakash

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Prakash Murugiah Dec 14, 2016 at 11:36 PM
0

Hi experts,

Any thoughts?

Thanks,


Prakash

Share
10 |10000 characters needed characters left characters exceeded