6 Filter

Filters in the Infrastructure system allow you to filter metadata using the defined expressions.

You can access Filters by expanding United Analytical Metadata section within the tree structure of LHS menu and selecting Filter.

Based on the role that you are mapped to, you can access read, modify or authorize Filters window. For all the roles and descriptions, see Appendix A. The roles mapped to Filters are as follows:

  • Filter Access
  • Filter Advanced
  • Filter Authorize
  • Filter Phantom
  • Filter Read Only
  • Filter Write

Figure 6-1 Filter Summary window


This illustration shows the Filters Summary window, which displays the list of Filters created in all public folders, shared folders to which you are mapped and private folders. The window has the Search pane, you can specify the details of the filter and search. The search results are displayed, you can also Add, View, Edit, Copy, Check Dependencies, Delete, and View SQL the filter.

The Filters Summary window displays the list of Filters created in all public folders, shared folders to which you are mapped and private folders for which you are the owner, along with the other details such as the Name, Type, Modification Date, and Modified By.

For more information on how object access is restricted, see Object Security in Dimension Management module section.

You can also search for a specific Filter definition based on Folder Name, Filter Name, or Type and view the list of existing definitions within the system. If you have selected Hierarchy from the Type drop-down list, the Dimension drop-down list is also displayed.

  • Adding Filter Definition
    This option allows you to add a filter. Filter can be of 4 types namely, Data Element, Hierarchy, Group, and Attribute. To create filter definition, the Write role should be mapped to your user group.
  • Viewing Filter Definition
    You can view individual Filter details at any given point.
  • Modifying Filter Definition
    This option allows you to modify the details of Filters.
  • Copying Filter Definition
    The Copy Filter Definition facilitates you to quickly create a new Filter Definition based on the existing parameters or by updating the values.
  • Checking Dependencies
    You can view the dependencies of a defined Filter. You can use filter in a Run definition. However, the Run definitions are not shown as dependent objects when you check dependency for a filter. This is a limitation.
  • Viewing SQL of Filter
    You can view the corresponding SQL of a defined filter.
  • Deleting Filter Definition
    You can remove the Filter Definitions which are not required in the system by deleting from the Filters Summary window.