Subcube (Browser Tab, Cube Designer) (SSAS)
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.
See Also
Reference
Cube Designer (SSAS)
Browser (Cube Designer) (SSAS)
Toolbar (Browser Tab, Cube Designer) (SSAS)
Report (Browser Tab, Cube Designer) (SSAS)
Metadata (Browser Tab, Cube Designer) (SSAS)