Narrowing the List of Elements
You can narrow the list of elements that you see along
the row and column dimensions in the Cube Viewer or In-Spreadsheet
Browser by creating dimension subsets.
A subset can include both consolidated and simple elements.
Using dimension subsets, you can focus on:
- Product groups that you track.
- Top-producing salespeople.
- Lagging sales regions.
- Stores that have common attributes, such as square footage and the number of employees.
A subset is either static or dynamic.
- Static subset - Contains a user-defined list of dimension elements that does not change unless you manually edit the subset.
- Dynamic subset - Contains an MDX expression that executes to display the elements to the dynamic subset. For details, see Creating Dimension Subsets.
You can also narrow the display of elements along row dimensions by filtering cube values. For details, see Creating a Filter-Based Dynamic Subset.