Forum Discussion

quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
5 years ago
Solved

Handling Bi-directional cross-filtering

Hello guys, Let’s say I have a simple model and I fully understand how bi-directional filtering works and I really need to optimize my model performance.   So, what is the best way, and why so?   ...
Need Help
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    quantumudit 

    Personally I would avoid bi-directional filters at all costs (I've only used them for RLS security tables), and go for TREATAS ( I use this function very often) or CROSSFILTER

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi quantumudit ,

 

I agree with PaulDBrown. Use CROSSFILTER function.

Best practice is to avoid Bi-Directional relationships as they sometimes introduce complex joins between the tables and affect background performance a lot; specially when you are dealing with millions of rows in the dataset.

 

Thanks,

Pragati