Creating Data Maps

To create a data map that maps an application to a reporting application:

  1. Click Application, then Data Exchange, and then click Data Maps.
  2. On the home page. click Create.
  3. Enter a name and description for the data map.
  4. Make your Source and Target selections as follows:
    • Under Source, select a cube from the available cubes for the current application.

    • Under Target, select an application and a cube from the available applications and cubes for the target reporting application.

    The current mappings for the selected source and target cubes are displayed under Source and Target, and any unmapped dimensions are displayed under Unmapped Dimensions.

    Note:

    If you are creating a data map to push data between Strategic Modeling and Planning, you see additional Source and Target options:

    • For Source, the options are Select Model and Select Scenario Rollup. Select a model or consolidation, and then click Select.

    • For Target, if a model is your Source, then select a target Planning cube or target Models. If a scenario rollup is your Source, then select a target Planning cube or the scenario rollup.

    If you don’t see your Strategic Modeling model in the list, from the Actions menu, select Synchronize.

  5. Optional. Change the current mappings and map any unmapped dimensions.

    To change the current mappings, see Changing Mapping Information for a Dimension.

    To map unmapped dimensions, see Moving Unmapped Dimensions.

  6. Define data map options.
  7. Click Save and Close.

    The new data map is added to the end of the data maps list.