Upgrade Notes 1.11.2 (Customer Insights)

1. Customer Insights Aggregated Data Data Source Fields Update

1.1 Rename Pricing Date Month Field

1. Go to Analytics > Data Manager > Data Sources

2. Select the Customer Insights Aggregated Data (CI_AggregatedData) Data Source.

3. In the Fields tab:

4. Locate and select the field Pricing Date Month (PricingDateMonth) field.

5. Update the field to match the following details:

1.2 Add Aggregation Period Start Date Field

1. Go to Analytics > Data Manager > Data Sources

2. Select the Customer Insights Aggregated Data (CI_AggregatedData) Data Source.

3. In the Fields tab:

4. Click Add Field

5. In the Add Field menu:

   1. Set the Data Type to Date.

   2. Enter Aggregation Period Start Date as the Label.

   3. Enter AggregationPeriodStartDate as the Name.

   4. Check Dimension option.

   5. Click Add Field.

1.3 Add Aggregation Period End Date Field

1. Go to Analytics > Data Manager > Data Sources

2. Select the Customer Insights Aggregated Data (CI_AggregatedData) Data Source.

3. In the Fields tab:

4. Click Add Field

5. In the Add Field menu:

   1. Select Data Type Date.

   2. Enter Aggregation Period End Date as the Label.

   3. Enter AggregationPeriodEndDate as the Name.

   4. Check Dimension option.

   5. Click Add Field.

1.4 Deploy Changes

1. Click Deploy.

2. Go to Analytics > Data Manager > Data Loads.

3. Select the Data Load with the following attributes:

   1. Target – DMDS.CI_AggregatedData.

   2. Data Load Type – Distributed Calculation.

4. Click Run Data Load.