IDT Multi Level Security

[Former Member]

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

[Former Member]

Hi experts,

Any thoughts?

Thanks,

Prakash