Map the Dimensions in the Source to the Dimensions in the Target

The next step in the process is to map the dimensions from the Row-based-dates.txt file to the dimensions in the target Planning application. For this integration we will use a single expression for the HSP_view dimension, and we will add the Period dimension and assign the column from the Row-based-dates.txt file to this dimension.

1. On the Edit Integration screen, leave the Type set to Delimited – Numeric Data, and map the source dimensions for Account, Amount, Entity, Product, and Version to the target dimensions as shown.

   
   
   

2. Enter an expression for the HSP_View dimension.

   For the HSP_View dimension, we will use an expression instead of a mapping rule, and we will set a value of "BaseData" as the default.

   1. In the HSP_View row, select , and then select Edit Target Expression.

      
      
      

   2. In the Edit Target Expression dialog box, select Expression Type, and then select Constant.

      
      
      

   3. In the Text field, enter BaseData, and then click OK.

      
      
      

3. Add the Period dimension to the dimension mapping after the HSP_View dimension.

   1. In the HSP_View row, select , then select Add Source Period, and then select Period.

   2. In the newly-created Period row, select Period from the drop-down or type Period in the File column.

      
      
      

4. Click Save and Continue to continue to the next step.