Creating User-Defined Consolidations on the Fly

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

  1. From a cube view, open the dimension for which you want to create the user-defined consolidation in the Subset Editor.
  2. Use the options in the Subset Editor to select the elements you want to include in your user-defined consolidation.
  3. 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.

    Image shows a cube view with a user-defined consolidation containing all wagons in the Model dimension on the row axis.
    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.