I use security filters for almost all my data sources. Each of these formulas uses a value calculated from one table (Table A). So, each security filter is recalculating the same value (from Table A) and then using it in the security filter. Would be it be faster to define a User Setting, that calculates this value from Table A, and then each security filter just uses that User Setting. That way it would not be recalculating the value from Table A, every time?
LinkedIn
Twitter
