Defining Filters

Filters restrict the returned result set. Use the Filter tab in the Query Clause section of the Fields page to define a filter.

*  To add a member to a filter:

    Table 36. Filter Options 

    OptionDescription

    Member

    Selected member.

    Operand

    Operands to use in the Filter clause.

    Use the following operands with key figures:

    =

    >

    <

    >=

    <=

    <>

    BottomCount

    BottomSum

    BottomPercent

    TopCount

    TopSum

    TopPercent

    Use the following operands with non-key figure members:

    =

    <>

    Value

    Integer numeric value for a key figure or the selected member of hierarchy for a non-key figure member.

    Characteristics

    Characteristic in the hierarchy for the selected member.

    Input

    Whether the value is an input parameter to be defined during runtime.

    Type

    Optional: The type of filter. Select a type of filter for a specific member in the output:

    • Children

    • Ancestor

    • Descendent

    Flag

    Optional: Select a flag:

    • After

    • Before

    • Before and After

    • Self

    • Self and After

    • Self and Before

    • Self Before After

    Join

    Optional: Join type used for the filter. Select a join type:

    • And

    • Or

    The join type joins multiple filters on the same characteristic.

    Runtime

    Allows users to define filter values at runtime. (SeeDefining Runtime Parameters.)

    Note: Runtime is enabled only when Input is checked.

    Note:

    When creating filters, you can further restrict the data retrieved by selecting a level member, hierarchy level, hierarchy member, hierarchy child member, property member, or key figure, clicking Range, and entering information in the Select Members dialog box. (See Restricting the Members Retrieved.)

    Tip:

    Except clauses provide additional filtering capability by limiting the set of values used for a selected characteristic. You can define an Except clause on a non-key figure member by using the < > operand in the Filter tab. This indicates that the selected characteristic should not be included in the required output.