Planual rules regarding Filters
4.03-01 Use efficient filters
For the most efficient performance, use filters that have only one Boolean condition. When multiple filters are needed for the same "filter tab", create a new line item encapsulating both conditions and use the new line item as the filter.
When multiple filters are defined for the same tab, the engine reads the filters sequentially, not at the same time. That means the data is read and the first filter is applied; then that filter two is applied to the result set of the first filter.
relatedToRule
bestPracticesArticles
4.03-02 Keep Filters in separate modules
Try and keep filters in separate System modules. They can then be reused for different modules and not defined multiple times.
relatedToRule
4.03-03 Use time filters on all pages
Don't use the Show/Hide function for time; these are static. Instead, use the Time Settings module since this makes the filtering dynamic when the model calendar changes.
relatedToRule
4.03-04 Use User filters to provide dynamic reporting
Create filter modules dimensioned by the Users list to support dynamic filtering of module data.
relatedToRule
bestPracticesArticles
4.03-05 Avoid filtering on nested dimensions
If possible, try and avoid filtering on nested dimensions. Try and pivot the view differently. If this isn't possible, ensure the filters are efficient.
relatedToRule
bestPracticesArticles
4.03-06 Use notes to document line items used as filters
Make use of the notes section in the Blueprint to document where a line item is used as a filter. This will help in the auditing of a model for saved views, as well as with dashboard filters.