Forum Discussion

Senthil_Kumar's avatar
Senthil_Kumar
Frequent Visitor
5 years ago

Rank changes when RLS is applied

Hi Team,   I have 3 tables Accountid table (used for RLS) Dealer Master table Fact sales tables   I am showing ranking of dealers based on their sales quantity. I also want to apply RLS in my...
RANKX
RankX issue with RLS
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Senthil,

 

Thanks for the reply. I dont think i will be able to implement your approach since i have huge dataset almost 10M records and also my requirement is to create Rank based on measure value(these are again from different fact tables). I think its getting complicated.

Looking for any simple/straight forward solution.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

 

You are absolutely right. The only one way to do it so that it's dynamic is to make  a copy of the fact table and the dimensions which are being affected by RLS and then use TREATAS to move relationships from one sub-model to another. Yes, this will certainly work but your model... well, it'll at least double in size. If you can afford it, no problem. If the ranks were static, you could do with calculating them in PQ. But here it's no option 😞 So, you'll have to live with duplication of the fact table.