Getting Started

Tasks

Additional Information

• Access to Filtering

• Introduction to Filtering

Adding

• Apply a Filter to Levels

• Apply a Filter to Measure Items

• Apply a Filter to Totals

• Apply a Relationship or Empty Filter

• Apply a View Filter

• Apply an Axis Filter

Editing

• Change Existing Filters

• Clear Filters

Examples

• Expressions for Rolling "N" Period Based Views

• Expressions for Filtering Levels

• Expressions for Filtering an Axis

• Filtering Totals

Windows

• Advanced Select Members Window

• Display Options Window for Select and Advanced Select Members Windows

• Expression Window For Filters

• Filters Window

• Grid Pop-up Menus

• Measure Item Filter Window

• Navigation Panel

• Paste Members Window

• Properties Windows for:

• Attribute Relationships

• Columns

• Individual Measure Items

• Levels

• Rows

• View Filter

• Select Filter Method Window

• Select Members Window

• Select Named Set Filter Window

• Select User List Filter Window

Advanced Concepts

• Axis Filter Behavior When Levels are on Opposite Axis

• Comparison of Top / Bottom, Recursive, and Overall Filters

• Edit the Information Displayed in the Select and Advanced Select Members Windows

• Factors Influencing Default Settings in Filtering Windows

• Guidelines for Sorting and Filtering on Totals

• Named Sets

• Potential Sources of Data for use with Pasting Members

• Recommendations for View Filters

• Treatment of Time-Related Levels in the Filters Window

• Using a View Filter vs. a Level Filter

• Using Relationship and Empty Filters

FAQ's

• Can Measure Items with Conditional Formatting including Images and Indicators be included in a Filter?

• What Does 'Not Mapped' Mean in Views and Filter Windows?

• What Does 'Not Valid' Mean in Views and Filter Windows?

• Why can't I Access the Select Members Window?

• Why can't I Filter or Sort Cumulative Calculated Measure Items?

• Why Did a Level That I Filtered Get Moved to the View Filter Section of My View?

• Why Doesn't a Level for a View Show in the Filters Window?

• Why is a Filter Property Disabled?

Definitions

• Axis Filter

• Display Column

• View Filter