Setting Filter and Slicer Values for OLAP Queries

You can set OLAP variable filters and slicers when importing or scheduling a job with an OLAP query. In the query, you can filter data on cube dimension levels to be displayed in the top or side labels of the query.

Slicers are filters on a dimension that are not in top or side labels but are visible in the data displayed. The filters list on Set Values displays the slicers last.

Note:

When modifying filters, you cannot remove the last filter. You need at least one filter value per filter.

  To access filter and slicer values:

  1. From Explore, select an Interactive Reporting job.

  2. Select Run Job.

  3. Click Go to add a schedule.

  4. Enter the schedule properties and click Next until you can define the value and filter options.

    Table 81. Fileter Options

    Option

    Description

    Set Values (MDD)

    OLAP Query Name — (Read-only) Query name

    Filter On — (Read-only) The dimension level on which the filter is applied

    Operator Type — (Read-only) The type that is set

    Data Operator — (Read-only) The operator that the filter uses, such as =, <, and >. (Slicers have no data operators.)

    Value(s) — (Read-only) The values that the filter uses (Variable system values such as $USER are acceptable. The values are from the database that the query is using.)

    Ignore — Disables the filter when the query is processed

    Don’t Prompt — Disables prompting for runtime values. (A dynamic value such as a system variable can be used for a value. This option essentially changes the variable filter to a static filter with fixed values.)

    Modify Filter

    Lists OLAP Query Name/Filter On values. Toggles filter list to filters applied for selected OLAP Query section and filter.

    Operator Type

    Availability determined by the database:

    • Select Members From Database

    • Select By Measure

    • Top N

    • Bottom N

    • Top Sum

    • Bottom Sum

    • Top N%

    • Bottom N%

    • Select Members

    • User Defined Attributes

    • Substitution Variables

    Available operator types are displayed in the filter list. Slicers have no operator types.