Configuring Custom Dimensions in Data Integration

Predictive Cash Forecasting allows you to add additional dimensions using Enable Features. If you enable additional dimensions, you must modify the provided ERP integration pipelines to pick up these additional dimensions.

Because the out-of -box ERP integration pipeline does not automatically pick up additional dimensions, you need to refresh the metadata, map the source dimension to the target dimension and optionally define simple transformation rules using expressions. A meta data load for the additional dimension should be loaded separately. When you load an additional dimension, the ERP integration definition used in the Pipeline is modified to pick up any additional dimensions.

To refresh the metadata:

1. Select Data Exchange and then select the Data Integration tab.

2. From the Data Integration home page, then from the Actions drop-down, select Applications.

3. From the Applications page, select the Predictive Cash Forecasting application with the OEP_PCSH suffix and then from the Actions menu, click Refresh Metadata.

To associate the <custom> dimension with a table column name in the staging table:

1. From the Applications page, select the Predictive Cash Forecasting application with the OEP_PCSH suffix, and then from the Actions menu, click Application Details.

2. Select the Dimensions tab.

3. Under Dimension Name, select the <custom> dimension to add to the integration definition.

4. From the Data Table Column Name drop-down, select the table column name of the column in the staging table (TDATASEG) where the <custom> dimension value will be stored and click Save.

To associate a <custom> dimension as a target dimension in the integration definition:

1. From the Data Integration home page, select the PCF_DATA_WEEKLY integration, and then from the Actions drop-down, select Map Dimensions.

2. On the Map Dimensions page, scroll to the end of the page and then from the * (Action) drop-down, select Add Dimension Row.

3. From the Add Dimension Row drop-down, select the <custom> dimension to add as a target.

4. On the Map Dimensions page, scroll to the end of the page and then from the Action drop-down, select Add Target Expression.

5. On the Add Target Expression page, click Expression Type, then select Constant and optionally, a value in the Text field.

   Use the Constant expression type to assign a constant value to the column. For target columns, the constant applies, regardless of the source column. The parameters are: constant(""). For example, to assign the value "P_001" to each row in a Product column, specify: constant("P_001"). In the example, the result is: P_001.

6. Click Save.