Skip to Content

IDT Multi Level Security

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 14, 2016 at 11:36 PM

    Hi experts,

    Any thoughts?

    Thanks,


    Prakash

    Add comment
    10|10000 characters needed characters exceeded