Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
iconfalse
titleProcess Owner
GBU Sales & Marketing / Finance
Info
iconfalse
titleD&PS Expert
Miriam Luttrin



Dimension Dictionary:

Dimensions:

Dimension:Relevant GBU(s):Definition:Source:GBUALLGBU NameBI4/BWGroup of ActivityALLBFC BU/Business UnitBI4/BWSub ActivityALLMarket IECRA/Business AreaBI4/BW

Market

ALLCorporate Market NameBI4/BWSegmentALLSegment of use for end productBW and GBR => BI4ApplicationALLMarket Application of ProductBW and GBR => BI4End UseALLEnd use of productBW and GBR => BI4Account TypeALL SFDC GBUsComes from Salesforce.com -> searches within the fields "RCS ID" & "PRS ID" within each account in order to show the sales figures in Analytics.Salesforce.comCustomer ClassificationALL SFDC GBUsClassifcation of customers (ex: A, B, C, D)Salesforce.comCompanyAll GBUsLegal Entity/Company CodeBI4/BWCompany ZoneAll GBUsLegal Company Geographical ZoneBI4/ Country code +QV mapping BWRegion (Ship to)All GBUsShip to Geographical zone name. Allows you to see sales by zone based on physical ship to location.BI4/Ship to Party Country + QV Mapping BWCountry (Ship to)All GBUsShip to country location of ship to.BI4/Ship to Party Country BWPlantAll GBUsPlant name after internalizationBI4/BWPlant OriginAll GBUsValue Stream plant origin or material industrial originBI4/BWCorp Sold-to/Payer GrpALL GBUsRelevant Sold to or Payer group depending on GBUSold to Party BW / GBR => BI4Corp Sold-to/Payer Sub GrpNovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemPayer Sub Group NameGBR => BI4Corp Ship To GroupALL GBUsShip to group name or ship to partyBI4/BWCorp Ship To Sub GroupNovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemShip to Sub group nameGBR => BI4Ship to KANovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemShip to Key Account. A link between a ship to and a product. Assigned by GBUs.GBR => BI4Sold-to/PayerAll GBUsPayer or Sold To PartyBI4/BWShip toAll GBUsShip to name/Ship to PartyBI4/BWGBU Product FamilyALL GBUsProduct Family division from GBR or CHEOPSGBR => BI4/ CHEOPS =>BWProduct HierarchySoda Ash, Peroxides, Special Chem, Specialty Polymers, PeroxidesProduct Hierarchy defined by GBUs. Provides product grouping for PF1 businesses.BWProductAll GBUsProduct or Material GroupBI4/BWMaterialAll GBUsMaterial name, usually including packagingBI4/BWPackaging TypeAll GBUsMaterial Packaging group name or Packaging TypeBI4/BWValue-StreamNovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemPlant Value StreamBI4Sales RepAll GBUsDynamic(WP1) or Static(PF1) sales rep data. Manual mapping provided for Special Chem and Peroxides.BI4/BWIntra-GroupAll GBUsIntra group (Intra Company) flag set to either Y (Show Intra Group Only), N (Don't show any Intra Group sales) or Both (Show all Sales).BI4/BWIntra-GBUNovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemIntra Enterprise flag. This is automatically excluded for all GBUs except for Novecare and Silica.BI4Intra-ZoneNovecare, SIlica, PePol, Aroma, Coatis, Tech Solutions, Special ChemUsed to eliminate indirect sales for selected zones.BI4Distributor FlagAll GBUsDistribution Flag lets you select whether to see only distribution, no distribution, or all sales.BI4/BWIncoterms   CRH Number   BFC MarketNon PF1 GBUs OnlyBFC allocated marketBI4

GBU Specific:

Dimension:Relevant GBU(s):Definition:Source:GBU Ship to Grp

Aroma, Coatis, Fibras, Novecare, PePol, Peroxides, Silica, Special Chem, Tech Solutions

Ship to groups assigned by GBU (separate from Corporate). Analogous to the "GBU Ship to Grp" filter available in the main menu.GBR => BI4 & BWGBU Ship to SubGrpAroma, Coatis, Fibras, Novecare, PePol, Silica, Special Chem, Tech SolutionsShip to Sub Groups assigned by GBU (separate from corporate).GBR => BI4Material Ent. GroupAroma, Coatis, Fibras, Novecare, PePol, Special Chem, Tech SolutionsEnterprise groupings of materials.GBR => BI4Material Ent. SubGrpAroma, Coatis, Fibras, Novecare, PePol, Special Chem, Tech SolutionsEnterprise sub groupings of materias.GBR => BI4Marketing MarketPePolDivision of sales based on markets assigned by PePol for marketing.GBR => BI4Enterprise End MarketPePol, Aroma, NovecareEnd Market assigned at the Enterprise level. Can be used to sort sales by enterprise specific markets.GBR => BI4Micro RegionPePol, PeroxidesAnother way to geographically group countries.QV MappingStrategic SegmentPePolMarket Segment defined by PePol for sales division.GBR => BI4Ent. SegmentAroma, Coatis, Novecare, PePolMarket segment defined at enterprise level.GBR => BI4Ship to StateAroma, Coatis, Fibras, Novecare, PePol, Silica, Special Chem, Tech SolutionsShip to state (US), province, county etc. of the physical ship to location.BI4GBU BFC Market (RCS)All RCS EntitiesMarket classification based on the BFC system.SAP => BI4

 

 

For detailed technical documentation: Dimensions Overview