Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
5 years ago
Solved

Alternative to USERELATIONSHIP & CROSSFILTER for RLS

Hello everyone,   I have RLS in my dataset and there are couple of inactive relationships in our dataset. Microsoft document says that USERELATIONSHIP wouldn't work when RLS is applied. We are achi...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI rajulshah,

    I think you are misunderstanding with RLS features, it can be worked with 'USERELATIONSHIP' functions.
    I think the relationship part which you mentioned is mean the indirectly cross table filter features, it is based on active relationships.
    If tables did not exist relationship link to the raw table, the RLS filter not auto-apply to those tables. You need to manually set filters on these inactive relationship tables.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI rajulshah,

I think you are misunderstanding with RLS features, it can be worked with 'USERELATIONSHIP' functions.
I think the relationship part which you mentioned is mean the indirectly cross table filter features, it is based on active relationships.
If tables did not exist relationship link to the raw table, the RLS filter not auto-apply to those tables. You need to manually set filters on these inactive relationship tables.

Regards,

Xiaoxin Sheng