Resolving Dimension Names

When you select Member Selection in a blank grid, the Dimension Name Resolution dialog box is displayed, where you choose a dimension or members to place on the grid. This process is referred to as resolving dimensions because when you choose the Member Selection option on a blank sheet, the data source has no way of predicting which dimension or members, including attribute members, you want to see and choose from in the Member Selection dialog box.

When you choose dimensions and members using this method, be sure that the first cell you select on the sheet is the cell in which you want to begin your free-form layout.

Note:

In Hyperion Enterprise, you cannot place dimensions on the grid.

  To resolve dimensions names in a grid:

  1. Select a cell.

  2. From the data source ribbon, select Member Selection.

  3. In the Dimension Name Resolution dialog box, select the dimension to place on the sheet.

  4. To orient members vertically in the worksheet starting from the cell you selected in step 1, select the Vertical Orientation check box.

    This check box is cleared by default; meaning that members will be oriented horizontally across the sheet from the cell you selected in step 1.

  5. Click OK to launch the Member Selection dialog box.

  6. Select the members to place on the worksheet and click OK.

  7. View the layout of the dimension or members you just placed on the sheet.

  8. Perform one of the following actions:

    • If you placed members vertically on the grid:

      • Repeat step 1 through step 7 to place a new set of members horizontally on the grid

      • Use the POV to pivot a dimension to a row

      • Type a dimension or member name (including attribute dimension or member names) directly on the grid

    • If you placed members horizontally on the grid:

      • Repeat step 1 through step 7 to place a new set of members vertically on the grid

      • Use the POV to pivot a dimension to a column

      • Type a dimension or member name (including attribute dimension or member names) directly on the grid

  9. Refresh.