1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Oracle General Ledger Balances from the Oracle ERP Cloud
  4. Mapping Dimensions

Mapping Dimensions

Mapping dimensions enables you to define how source dimensionality translates to the target dimensionality between the Oracle Enterprise Performance Management Cloud application and the dimensions in the Oracle General Ledger application.

Note:

Oracle General Ledger creates one Essbase cube per Chart of Account/Calendar combination. In this case, you can use the same import format to import data from Ledgers sharing this Chart of Accounts. Ledgers can be specified as a filter in the data load rule.

To map dimensions between the source Oracle General Ledger application and the EPM Cloud target application:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Map Dimensions.

  2. On the Map Dimensions page, then Import Format, select the name of the import format to use for the integration.

    You can also add a user defined import format name.

  3. In the mappings grid, map the source columns in the source to the dimensions in the target application.

    The dimensions from the target application are populated automatically.

    If the import format has already been defined for the integration, then the source and target columns are mapped automatically.

    If you are adding a new import format or editing an existing import format, complete the following:

    • In Column, specify the field number from the file to import.

    • In Select Source Dimension, specify the name of the source dimension to assign to the target application.

      Multiple source columns of the same dimension can be mapped to target dimensions. For example, you can map four "Account" source columns.

    • Add a source or target expression: assign an expression that operates on values directly from the source or target.

      See Using Source Expressions and Using Target Expressions.

      Optional: For a comma delimited file, select an additional row to map in the import format by clicking Image shows the Add row icon. to the right of a row and selecting the row to add from the drop-down.

      Available rows:

      • Source Period
        • Year
        • Period
        • Period Number
      • Currency
      • Attribute
      • Description
      • Dimension Row
        • Account
        • Version
        • Entity
        • View

      You can also skip a row.

  4. Click Save.