Member Filtering by Properties

You can filter the members by property.

To do so, click the filter icon in the Member Selector and define the filter(s) in the Member Filtering by Properties area that appears.

• To define a filter, select one of the properties available for current dimension/hierarchy using the Property dropdown list.
  Then select an operator and property values:

  • =: equal.
    • For example, to filter all the entities that belong to the France value for the Country property: Country=France.
    • For example, to filter all the entities for which the currency is the context member of the Currency dimension. In the filtering area, select the following information: Currency = <CONTEXT> Currency
  • <>: not equal.
    • For example, to filter all the entities except the ones that belong to the France value for the Country property: Country<>France.
    • For example, to filter all the entities except the ones for which the currency is the context member of the Currency dimension. In the filtering area, select the following information: Currency <> <CONTEXT> Currency
  • LIKE: equals the entered value. You can enter text or figures and use the * character before or after the entered value. For example, to filter the chart of accounts beginning with "10", enter "10*": Chart of Accounts LIKE 10*.
  • BT: range between a low and high value. For example, to filter the chart of accounts for values between 1000 and 1100: Chart of Accounts BT 1000 1100.
• The Dimension Members area displays only the members that meet the filter criteria because the Display Only Filtered Members option is selected by default.
  Note When the Display Only Filtered Members option is selected, the members appear in a list; they no longer appear in a hierarchy. Therefore, the dropdown list on the top left corner of the dialog box automatically displays List. If you deselect the option, all the members for the current dimension/hierarchy are displayed in a hierarchy, and the dropdown list on the top left corner of the dialog box automatically displays Hierarchy.
• To make a selection, you can do one of the following:
  • Check the members you want and click the right arrow button. The checked members, and any related members depending on the Selection Relationship choice, are moved to the bottom of the selected members list.
  • Select the filter itself. The filter is dynamic, meaning for example that if a member with a specified property is created in the cube or model, it will be added automatically to the report. To select the filter itself, click the Add Dynamic Filter button.