Advanced Object Filtering

This article describes how to use the “Filter” textbox within Tabular Editor - an incredibly useful feature when navigating complex models.

Filtering Mode

As of 2.7.4, Tabular Editor now lets you decide how the filter should apply to objects in the hierarchy, and how search results are displayed. This is controlled using the three right-most toolbar buttons next to the Filter button:

https://user-images.githubusercontent.com/8976200/46567931-08a4b480-c93d-11e8-96fd-e197e87a0587.pngimage

  • https://user-images.githubusercontent.com/8976200/46567944-44d81500-c93d-11e8-91e2-d9822078dba7.pngimage Hierarchical by parent: The search will apply to parent objects, that is Tables and Display Folders (if those are enabled). All child items will be displayed, when a parent item matches the search criteria.

  • https://user-images.githubusercontent.com/8976200/46567940-2ffb8180-c93d-11e8-9fba-84fbb79b6bb3.pngimage Hierarchical by children: The search will apply to child objects, that is Measures, Columns, Hierarchies, etc. Parent objects will only be displayed if they have at least one child object matching the search criteria.

  • https://user-images.githubusercontent.com/8976200/46567941-37bb2600-c93d-11e8-9c02-86502f41bce8.pngimage Flat: The search will apply to all objects, and results will be displayed in a flat list. Objects that contain child items will still display these in a hierarchical manner.