Change Existing Filters

Options for editing filters on different types of items follow. Use the Filters window to make your edits if you have multiple items to edit – for example, if you need to add filters to some items and remove or edit filters on other items. You can make all edit changes for levels, measure items, and a view axis from the Filters window then apply all changes at once.

Attribute Relationships Filters

1.   Click the Manage All Filters icon in the grid toolbar to access the Filters window.

2.   In the Levels tab of the Filters window, look for the attribute relationship in the section for its level. Then, click the Change Filter icon next to the attribute relationship’s name.

3.   Use the Attribute Relationship Filter window to change the filter. Then click OK.

4.   Change or add other filters if needed.

5.   Click OK in the Filters window when you’re done with all your changes.

Note: You can also click the filter icon for an item in the grid and make changes from its filter editing window that opens. The steps above are useful when editing filters on multiple items then applying all changes at once.

Axis Filters

1.   Click the Manage All Filters icon  in the grid toolbar to access the Filters window.

2.   From the Filters window, click the Axis tab then the Change Filter icon  next to the Rows or Columns section (whichever axis you want to filter).

3.   Use the Expression window to edit the filter expression, and click OK

4.   Change or add other filters if needed.

5.   Click OK in the Filters window when you're done with all your changes.

Note: In the Navigation Panel, clicking the filter icon  next to the name of the filtered axis opens the Expression window for editing that axis filter.

Level Filters

1.   Click the Manage All Filters icon  in the grid toolbar to access the Filters window.

2.   From the Levels tab in the Filters window, click the Change Filter icon  next to the level name.

3.   The appropriate window for editing the filter will display depending on the filter type (member, named set, expression, user list).

4.   To change the filter mode, use the provided drop-down list next to the level’s Change Filter icon. Choose “Include” to have the applied filter return only the members specified by your filter selections/criteria. Choose “Exclude” to have the applied filter return all members except the ones specified by your filter selections/criteria.

5.   Change or add other filters if needed.

6.   Click OK in the Filters window when you’re done with all your changes.

Note: You can also click the filter icon for an item in the grid and make changes from its filter editing window that opens. The steps above are useful when editing filters on multiple items then applying all changes at once.

Measure Item Filters

1.   Click the Manage All Filters icon in the grid toolbar to access the  Filters window.  

2.   From the Data tab in the Filters window, click the Change Filter icon  next to the measure item.

3.   Use the Measure Item Filter window to edit the filter, and click OK.

4.   Change or add other filters if needed.

5.   Click OK in the Filters window when you’re done with all your changes.

Note: You can also click the filter icon for an item in the grid and make changes from its filter editing window that opens. The steps above are useful when editing filters on multiple items then applying all changes at once.

Relationship or Empty Filters

1.   Double-click the Rows or Columns folder in view explorer. The Rows or Columns Properties window displays.

2.   Adjust the Yes and No settings for the filter that you need to edit.

Note: In order for the Empty Filter property to be Yes, the Relationship Filter property must be Yes.

Total Filters

1.   Click the filter icon  next to the caption of the measure item in the Grand Total row or column.

2.   Use the Measure Item Filter window to edit the filter.