Filters are used to control the context within a Form. When designing your Form it is important to be aware of the different options available for configuration on the Form.
Filter Configuration Options
Within the Form editor there is a Filter section that allows you to configure the dimension and attributes that you have selected in Layout.
|Header Display||This will override the display of the hierarchy name for the filter title. If you leave it blank, it will display the filter’s default header, which is set to the selected hierarchy/Member List name of the Dimension.|
|Default Member||For each filter, you can set a default starting member. It is recommended to default each member to the lowest member within a hierarchy to give better performance when the form is first opened. For more information on setting Default Members, check the section below.|
|Scope||A filter can contain a set of Dimension Members. Only members from that set will be allowed for selection by end users. If you need scope your Filters dynamically read this article on relationships.|
|Read Only||Filters can also be set to read only mode. When a filter is set to read only, users will not be allowed to change the value of the filter.|
|Multi-Select||Determine whether this filter allows selecting multiple members at a time.|
|Ensure Selection||This property will enforce selection of at least a single member by a user.|
|(Leaves-Only) Selectable||This will show a check-box beside each member in the hierarchy without any children, with the parent members being non-selectable.|
|(All) Non-Selectable||This will remove the checkbox from the “All” member, preventing it from being selected.|
|Expand All||If the Form is configured with an Advanced Relationship, then the filter will show only valid members based on the relationship. The Expand All option is to override the show valid member relationship behavior by always showing the full definition of the hierarchy.|
|Auto Refresh||When checked, the Form will be automatically refreshed every time the filter selection is changed.|
|Explicit Security||Only members that the user has explicitly been granted access to via security will be shown. For example, when the user only has security to leaf members of a PC hierarchy, the filter will only show those members and not any of the parents.|
|Level Mode||With Level Mode enabled, the filter will provide each level of a Level Hierarchy as members to select. This is useful in conjunction with a Filter Variable as you allow the user to view different granularity on rows and columns based on selection of this filter.|
Select the icon to change the Default Member configuration.
There are four types of default members you can set:
- Selected Member - This is the default setting. You can pick a Default Member from the Member List by clicking the icon and selecting from the list.
- Custom Member - Click on the settings button and select Custom Member. You can enter any display text in this field, such as “Please select…”
- Member Variable - Rather than hard-coding a specific default member, you can set a Member Variable to be the default as an easy way to update default filters across many forms. Note, this will still only affect the default behavior. Users will be able to save APPs with a different filter selected. Refer to the Member Variables article for more information on defining Member Variables.
- Member Variable (Dynamic) - Selecting a Member Variable here will have the same effect as setting a Member Variable in the option above, however a Dynamic Member Variable will ensure user-saved apps always open with the filter set to the current Member Variable setting in Modeler, regardless of what the filter was saved with.