Skip to Content
0
May 24, 2020 at 07:43 AM

Row Level Security on Dimension table connected to more than one aggregate IDT 4.2 LOVs Filter

68 Views Last edit May 26, 2020 at 11:07 AM 3 rev

Hi All,

I am having requirement of applying row level security on universe.But there is one dimension table that is connected to 6 aggregate tables and it is not getting filtered LOVs.

As it's a big universe with more than 45 tables ,I have created one look up table that is connected to each aggregate table by col X and created security profile on Col X from lookup table then in .blx layer created filter on lookup table then applied it on object folders.

But 4 dimension tables are directly connected to 6 aggregate tables and security not getting applied on these while checking for LOVs it's not getting filtered until we are adding other objects from aggregate tables in result objects in WEBI .

Adding Col X to dimension table and applying row level security is not feasible for me as it will add 4 more where condition to the query and hamper performance.

Could you please advice a solution by which I can apply security on those 4 tables?