Mapping Dimensions for a Reconciliation Compliance Balances Application

By default "Profile" is mapped to the "Account" (Reconciliation Account ID) target dimension class and "Period" is mapped to the "Period" target dimension class.

To define dimension details for a Reconciliation Compliance Balances application:

1. From the Data Integration home page, click to the right of the Reconciliation Compliance Balances integration, and then select Map Dimensions.
2. From 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. From Type, select Delimited.

   Delimited enables you to load numeric data from a delimited file format.

4. From Delimiter, select the character to use for delimiting columns in the output file.

   A delimited file contains one or more records set off from each other by a specified delimiter.

   Available options:

   • Comma (,)

   • Pipe (|)

   • Exclamation (!)

   • Semicolon (;)

   • Colon (:)

   • Tab

   • Tilde (~)

5. In the mappings grid, map the source columns in the source data-load file to the appropriate Reconciliation Compliance Balances dimensions.

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

6. Add the Currency Dimension to map the currency code.
7. Optional: Add additional Profile dimensions to concatenate Profile Segments in the Profile dimension.
8. Edit the source expression on the Amount column and add the NZP expression type to load zero balances.
   For more information about source expressions, see Using Source Expressions.
9. Click Save.