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

The next step is to map the dimensions from the Multi_Account_Column-All-Data-Types.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 a driver feature for the Data dimension.

1. On the Edit Integration screen, change the Type to Multi-Column – All Data Type, and click Save. (Clicking Save adds the Data dimension.)

   
   
   

2. Map the source dimensions for Account, Entity, Product, and Version to the target dimensions as shown.

   
   
   

3. 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.

      
      
      

4. Enter driver parameters for the Data dimension.

   In this example, we will edit the source express to set the Account dimension as the driver, to specify that there is a header row, and to specify that the periods are in columns 1,2 3, and 4.

   1. In the Data row, select , and then select Edit Source Expression.

      
      
      

   2. In the Edit Source Expression dialog box, select Expression Type, and then select Driver.

      
      
      

   3. Set the Dimension to Account, the Header Row to 1, and the Column to 1,4, and then click OK.

      
      
      

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