Query and Filter (Browser Tab, Cube Designer) (Analysis Services - Multidimensional Data)

  • Article

This area of the Browser tab in Cube Designer contains a query and filter area, to help you choose data from the cube to use in browsing or in queries. You can add as many cube objects as you want, and then view the results in the data area, or export the results to a report using Analyze in Excel to visualize how the data would be viewed by end users.

Warning

When you are working with data in this area, by default the Browser uses the graphical design mode. However, you can edit the query directly using MDX, by clicking the Design Mode toggle button. When you do so, the pane that lets you design filters on dimensions disappears. If you want to add a filter, you can switch back to graphical design mode.

By default, the credentials of the current user, not the credentials specified in the Impersonation Information page, are used to connect to the data source when a query is executed. However, you can also change the user context for the query or report by clicking Change User on the Toolbar.

Options

  • Dimension
    Select the dimension on which to slice the subcube.

  • Hierarchy
    Select the hierarchy on which to slice the subcube.

  • Operator
    Select the operator that defines how the expression in Filter Expression is applied to the selected hierarchy. The following table describes the available operators.

    Value

    Description

    Equal

    The results are restricted to the set defined in Filter Expression.

    Not Equal

    The results are restricted to the members excluded by the set defined in Filter Expression.

    In

    The results are restricted to the named set chosen in Filter Expression.

    Not In

    The results are restricted to the members excluded by the named set chosen in Filter Expression.

    Contains

    The results are restricted to members whose member names contain the string in Filter Expression.

    Begins With

    The results are restricted to members whose member names begin with the string in Filter Expression.

    Range (Inclusive)

    The results are restricted to the range chosen in Filter Expression.

    Range (Exclusive)

    The results are restricted to the members excluded by the range chosen in Filter Expression.

    MDX

    The results are restricted to the Multidimensional Expressions (MDX) expression set in Filter Expression.

  • Filter Expression
    Type the expression that is to be evaluated by Operator, which restricts the results to be browsed.

    Note

    This field is a dynamic data entry element, changing appearance to reflect the types of data necessary for the selected operator.

See Also

Reference

Cube Designer (Analysis Services - Multidimensional Data)

Browser (Cube Designer) (Analysis Services - Multidimensional Data)

Toolbar (Browser Tab, Cube Designer) (Analysis Services - Multidimensional Data)

Analyze in Excel (Browser Tab, Cube Designer) (Analysis Services - Multidimensional Data)

Metadata (Browser Tab, Cube Designer) (Analysis Services - Multidimensional Data)