Share via


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

Use the Subcube pane on the Browser tab in Cube Designer to restrict the data to be browsed in the Result pane to a specified subcube.

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.