General Scope and Data Refresh

Scope:

• Period - 3 calendar years
• Intra-GBU - All Intra-GBU sales are excluded (except Novecare and Silica, see below)
• Legal Entities - All except for Butachimie & Rhodia Manyar
• Order Type - "KB" excluded for Engineering Plastics
• Distribution Channels - All except "7O"
• Products - All except for Native Guar
• Integrated Margin - For Engineering Plastics refer to its Market Margin

Flags:

• Intra-Group (Intracompany) (Y/N) - Intra-group sales may be included or excluded using this filter
• Consolidated Entities (Y/N) - Choose Y or N for whether each Legal Company consolidation method should be taken into consideration in the analysis at hand
  For example, selecting (N) will show 100% sales, volumes and margins while selecting (Y) will consider the consolidation methods of each Legal Entity by multiplying the sales, volumes and margins by the Entity consolidation rate (eg. joint venture of 50%/50%, only 50% of sales will be shown in the analysis)
• Intra-GBU (Intra Enterprise)- This flag contains Intra-GBU sales only for Novecare and Silica. Otherwise all other intra-GBU sales have been excluded from the scope.
• Intra-Zone - This is a Novecare and Silica specific flag which is used to eliminate indirect sales for certain zone
• Margin Types - Choose between:
   - Contribution Margin
   - Integrated Margin
   - Integrated (Market) Margin

Data Refresh Frequency:

• Data is refreshed on the Analytics dashboard daily. Sources for the dashboard include:
• Order Book: OBAS, PPS (BW and BI4)
• Sales Performance: BI4 or Business Warehouse (see detailed info on this below)
• Overdue and DSO: Business Warehouse FIAR
• Quality: Salesforce.com
• Opportunities: Salesforce.com

Detailed information for loading of Sales Performance Data:

WP1 and PF1 data is loaded from BW P&L Cube since Jan 2018.

• WP1 Data is loaded from BI4 PPE Cube.
• PF1 Data works as follows:
  • For current month invoiced amounts, data is loaded from the Business Warehouse SD cube daily.
  • For historical data > M-1, Data is loaded monthly from the Business Warehouse P&L Cube. This is done on the 6th to the 10th of each month for all historical data and overwrites the SD data.