Creating Dimension Subsets

Subsets can be created using three different tools.

You can create subsets through the following:

  • Server Explorer window
  • Cube Viewer window
  • In-Spreadsheet Browser

Procedure

  1. Open a dimension in the Subset Editor.
    • From the Server Explorer, select a dimension for which you want to create a subset and click Dimension, Insert New Subset.
    • From either the Cube Viewer or the In-Spreadsheet Browser, click a row or column dimension label.

    The Subset Editor window opens, with elements of the current subset displayed in the Tree pane.

  2. To see all the elements in their dimension hierarchies, click All All button and then click Edit, Sort, Hierarchy.

    All dimension elements display in hierarchical order.

  3. Select one or more elements in the dimension by using the methods described in Selecting Elements.
  4. Click Subset, Save.

    The Save Subset dialog box opens.

  5. Decide whether you want to create the Default subset or a named subset. If you want to create a named subset, skip to step 6.

    To create the Default subset, click Default.

    The word Default displays in the Subset Name box.

  6. Create a private or public subset.

    To create a private subset, select the Private check box.

    To create a public subset, clear the Private check box. You must have Admin privilege to the parent dimension to create a public subset.

  7. To create a named subset, type a name (256 bytes maximum) in the Subset Name box.
    Note: For Western character sets, such as English, a single character is represented by a single byte, allowing you to name a subset with 256 characters. However, large character sets, such as Chinese, Japanese, and Korean, use multiple bytes to represent one character. In this case, the 256 byte limit may be exceeded sooner and not actually allow the entry of 256 characters.
  8. Click OK.

    In the View list, the Private Subset Private Subset icon icon to the left of the subset name, S Series Sedan, represents a private subset.

  9. Click OK to return to the Cube Viewer or In-Spreadsheet Browser.
  10. Recalulate.

    In the Cube Viewer or In-Spreadsheet Browser, the subset name replaces the name of the row or column dimension.

    The following examples show the Model dimension positioned as a row dimension. Each row label contains the name of one of the nine elements in the S Series Sedan subset.

    Cube Viewer

    Image shows the S Series Sedan subset on the row axis of a view.

    In-Spreadsheet Browser

    Image shows the S Series Sedan subset on the row axis of an In-Spreadsheet Browser view.

    In the Server Explorer, the Public Subset Public Subset icon icon represents s a public subset, while the Private Subset Private Subset icon symbol represents a private subset.

Parent topic: Narrowing the List of Elements