Intra-GBU - All Intra-GBU sales are excluded (except Novecare, 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 (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 - This flag contains Intra-GBU sales only for Novecare. Otherwise all other intra-GBU sales have been excluded from the scope.
Intra-Zone - This is a Novecare specific flag which is used to eliminate indirect sales for certain zone
Data is refreshed on the Analytics dashboard daily. Sources for the dashboard include:
Order Book: OBAS
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 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.
