1. Administrator's Guide
  2. Working with an Application
  3. Mapping an Application for Reporting
  4. Defining Dimension Mappings

Defining Dimension Mappings

On the Map Dimensions tab, you map the Oracle Hyperion Planning dimensions on the left to the reporting application members on the right. If mappings are correct, data can be pushed when dimensions in both applications are mapped or have valid default members for storing data in the reporting application (see Setting the Point of View).

To define dimension mappings:

  1. For each Planning dimension, select a Mapping Type:

    • Dimension to dimension: Displays the available unmapped dimensions in the Planning application. In order to push data, the dimension and all of its members must reside in both the source and target applications.

      Dimensions that are identical between the Planning and reporting applications (for example, Scenario to Scenario) are automatically mapped.

    • Smart List to Dimension: Displays the available Smart Lists. When a Smart List is selected, the account members associated with it are displayed. If there is only one member, it is automatically selected.

      Note:

      Smart List labels are used for mapping to member names or member aliases in the reporting application.

  2. In Dimension/Smart List name, select the name of the dimension or Smart List.

    With Smart List to dimension mapping, the source plan type must contain a dense Account dimension with at least one member associated with a Smart List.

    Note:

    When mapping Smart Lists to dimensions, you can synchronize Smart Lists to identify dimensions in reporting applications to which Smart Lists are mapped. This also adds level 0 members of the selected dimensions as new Smart List entries to the selected Smart Lists. See Synchronizing Smart Lists in Reporting Applications.

  3. In Member Selection, select the member name by clicking Browse button.

    By default, Lev0Descendants is selected. You can select only level 0 members. If there is only one member, this member is automatically selected.

  4. Click either:

    • Next to display the Point of View. See Setting the Point of View.

    • Save if all dimensions are mapped and there is no need for a POV. (If so, the Next button is grayed out.)