Applying a Story or Page Filter

Apply a filter in one of these ways:

For a story filter, select (Story Filter/Prompt) on the top navigation panel. In the filter bar, select (Add Story Filter/Prompt).
For a page filter, select (Input Control) on the top navigation panel.

If you need to change the data source, select the name of the current data source and then select the data source that you want to filter.

From the Add Time Filters list, you can quickly create a dynamic time filter that shifts based on the current date, such as Month to Date or Previous Quarter.

Choose which periods to include, for example, Previous or Current & Next.
If you have multiple date dimensions, pick the one that you want to filter.
Select the granularity of the time period under Full Period or To Date, depending on the range that you want to include.

Otherwise, select the dimension or measure you want to filter from the Add Story Filter/Prompt list.

Note

Certain dimensions, for example date dimensions, can be filtered either by choosing members from a list or by selecting a range. To filter by choosing members, choose the option Filter by Member. To filter dimensions by selecting a range, choose the option Filter by Range, and skip to Step 9.
Measures are automatically filtered by range. If you're applying a measure-based filter, skip to Step 9.

For models with an Account dimension, this will appear as the Measures dimension and can only be selected in the page filter as a measure-based range filter.
You can create filters and input controls based on dimension attributes as well. For more information about dimension attributes, see Combine Data with Your Acquired Data.

To change the display information for the filter, select

to expand the Available Members menu and select one of the Show Description options:

Description
ID and Description
ID

When you change how the dimension information is displayed, the corresponding tooltip is updated.

To display dimension members that don't contain any data, switch the Show unbooked members option On.

If the Show unbooked members option is Off, only those members that contain data will be displayed. For example, if you are filtering a currency dimension and only the Euro and US dollar members contain data, the rest of the currency members will not be displayed.

In the Available Members area, select the checkbox beside the members you want to filter.

You can use the Search function to find the members you want. Select All Members to automatically select all members in the dimension, or select the Exclude selected members checkbox to exclude the members you select.

Note

When you select a member node in a hierarchy, all of its children are automatically selected.

Ensure that the members in the Selected Members area are correct.

To filter certain dimensions by selecting a range, choose the option Filter by Range instead of Filter by Member.

If you're defining a measure-based filter, it's filtered by range automatically, and these options aren't shown.

Configure the filter range as follows (some of these configurations are available only for measure-based filters, and some are available only for dimension-based filters):

For measure-based filters, select the Dimension Context.
The dimension context is one or more dimensions that the measure is aggregated against. For example, if you're analyzing salaries of company employees based on country and gender, you could choose the two dimensions Country and EmployeeGender for context.
For dimension-based filters, if you want viewers of your story to specify a single value within a range instead of a range of values, expand the Multiple Selection list, and select Single Value Slider.
Select end points for your range:
- For dimension-based filters, you can either drag the sliders on the range bar, or select end points from the drop-down lists.
- For measure-based filters, type end point values into the Min and Max boxes.
Select Add a New Range if you want to define additional ranges. Note that the single value slider is not available if you define more than one range.
- For a single value slider, the end points you select represent the maximum and minimum values that viewers of your story will be able to select, using the page filter or input control.
- For measure-based filters, viewers can set the Min and Max values outside of the initial range you define. For example, if you set an initial range of 100 to 200, they could change the range to 50 to 500.
- Otherwise, the end points you select represent the initial ranges that viewers of your story will see in the page filter or input control. Users can redefine the ranges using the page filter or input control.
Note
By default, only the range between the end points you initially define is selectable in the page filter or input control. If you select Display entire range slider, viewers will be able to select areas outside of the initial ranges you define.
If you want your range to extend to the start or end of the data set, even if the start or end values change when the data is refreshed, choose Start or End instead of discrete values.
For date dimensions, also define the granularity (for example, year or month). You can also set dynamic ranges that shift based on the current date. To learn about this, see Story and Page Filters.

Choose whether you want to Allow viewers to modify selections.

If you allow viewers to specify filter values, they can either toggle on and off each filter value (if you chose the Multiple Selection option or the Multiple Selection Hierarchy option), or select a single filter value (if you chose the Single Selection option). The Multiple Selection Hierarchy option allows users to select children nodes of specific dimension members.

Note

Viewers can reset any changes that they made to filters and input controls to get the original view of the story by selecting

(Reset) on the story toolbar.

Note

Using large hierarchies in story filters has an impact on performance. It is recommended to use booked values instead of accessing master data.

Choose whether you want to Allow viewers to delete filter.

Viewers shouldn't be able to delete a designer's story filter, but you can allow them to do so.

Select OK to create the filter.

If you created a page filter, you can resize it to convert it to an input control.

An input control displays the filter values with checkboxes or radio buttons, to let users experiment with different filter settings.

The filter or input control is assigned a name according to the dimension being filtered. If you want to change the name, double-click it.

By default, the cascading effect is applied. If you don't want the cascading effect to apply to this filter, turn off Cascading Effect in the filter settings.

For more information, see Story and Page Filters.

Applying a Story or Page Filter

Prerequisites

Procedure