You can quickly create a subset containing only
a user-defined consolidation with the Roll Up button in the Subset
Editor. This process is easier to execute than inserting a user-defined
consolidation into an existing subset. However, you cannot save or
edit the subset. This process is available only when you open the
Subset Editor from a cube view (Cube Viewer or In-Spreadsheet Browser)
and is best suited for quickly creating a consolidation of elements
while browsing a cube.
Procedure
- From a cube view, open the dimension for which you want
to create the user-defined consolidation in the Subset Editor.
- Use the options in the Subset Editor to select the elements
you want to include in your user-defined consolidation.
- Click Roll Up.
The
Subset Editor closes and the user-defined consolidation displays in
the cube view. The user-defined consolidation name format is
}ROLLUP_ELEM_###
Where
### represents a sequential number for a Roll Up consolidation you
create during a current server session. For example, the first Roll
Up consolidation name is }ROLLUP_ELEM_000; the second Roll Up consolidation
name is }ROLLUP_ELEM_001, and the third Roll Up consolidation name
is }ROLLUP_ELEM_002.
This user-defined consolidation is considered
a "pseudo-element" of the subset. You can use any sort method on the
user-defined consolidation. You can select the user-defined consolidation
using the Select by Regular Expression option in the Subset Editor.
However, the user-defined consolidation is not assigned a unique level
in the subset; so you cannot use the Filter by Level option in the
Subset Editor to select the user-defined consolidation.
In
the following view, the row dimension includes a user-defined consolidation
of all wagons in the Model dimension. This consolidation is named
}ROLLUP_ELEM_003, indicating that it is the fourth consolidation created
during the current server session.
Note: If you save this view, the user-defined consolidation
is not saved as part of the view, but the members of the consolidation are saved
as part of the view.