Sales_Data_Base

Get Started. It's Free
or sign up with your email address
Sales_Data_Base by Mind Map: Sales_Data_Base

1. 2b Volumes Monthly Distribution

1.1. 1. Working Days Input Grid 1. CES _ Monthly_Allocation_Selection.xls 1. Input Level => zAdmSelectors (PickList ) 1. Brand Grouping => zAdmSelectors (PickList) 1. Apply => CES_Volumes_Monthly_Allocation_Feed.pro 1. Botton SAVE => CES_Monthly_Allocation_Calculations.pro => copier les données sur l'axe Periode Natif (01 -> YYYY.01 sur WOrking Days tech. [Attention]: le calcul du Turnover est désactivé pour le moment suite aux modification des volumes????????? 1. Affichage des Plant_OEM_Ship-to.dim (mdx) 3. Periods (FullYear.Year) vs Month.dim des PO Business Plan et Working Days

1.2. 2. CES - Monthly_Calculation_Selection.xlsm 2. Input Level => zADM_Selectors (PickList) 2. Ship-to Selection => zADM_Selectors (PickList) 2. YEAR => zADM_Selectors (PickList) 2. Project => zADM_Selectors (PickList) 2. Current Version Selected => zADM_Selectors (PickList) 2. Botton Apply Selection=> Refresh 2. Botton Save => CES_Volumes_Monthly_Allocations_Send_Volumes_To_ID_CES.pro => envoi des volume vers Order_input_CES.cub 2. Affichage des Orders_CES (mdx) vs Periods vs OH_Informations_CES (PO Business Plan Volumes) dans le cube Sales_DB_CES.cub

1.3. 3. CES - Volumes_Monthly_Distribution_Selection.xlsm 3. Input Level => zAdm_selectors (picklist) 3. Plant Selection => zAdm_selectors (picklist) 3. YEAR => zAdm_selectors (picklist) 3. Project => zAdm_selectors (picklist) 3. Current Version Selected => zAdm_selectors (picklist) 3. Botton Apply Selection=> Refresh 3. Botton Save => CES_Volumes_Monthly_Allocations_Send_Volumes_To_ID_CARD.pro => envoi des volume vers Order_input_CES.cub 3. Affichage des Orders_CES (mdx) vs OH_Infor_CES (Mthly distri Adju) vs Period (mdx) vs Version (mdx)

2. Create or Maintain ORDER

2.1. 1. Creation des Order Line (Order_Header_CES.dim) CES - Order Links.xlsm ( Order ID ) => zADM_Selectors (pickList) ( Product Family ) => Order_links_ces (pickList) ( Order Description ) => Order Header CES (DBRW) ( Product Category ) => Order_links_ces (DBRW) ( Current Version ) => Order_links_ces (DBRW) 1. Botton Refresh = Order_Header_CES_Reset_Filter_IHS.pro => il initialise les champs à vide et il vide le % OH_Information_CES.Dim 1. Create_Header_CES.pro (CES et IES) ajout des element dans la dimension Order_Header_CES 1. Order_Header_CES_Change_Order_Header_Name.pro => modification des descriptions des Order Header. 1. Order_Header_CES_Create&Feed_Order_Line_Without_IHS_Link.pro => nous permet de creer un order header sans attendre les informations IHS (processus normal on doit avoir les Infos IHS), Creation de l'order Header dans l'orders_CES.dim 1. Filter IHS => Order_Header_CES_Feed_IHS.pro => il va recuperer les volumes et les attributs à partir de IHS_Powertrain.cub dans le Order_Link_CES.cub

2.2. 2. IHS LINES SELECTED Contient la liste des Mnemonics_Orders_CES (MDX) vs Order_Headers_CES (MDX) vs Version dans le Cube Order_Link_CES.cub elle contient les volumes + % (IHS), avec une RG on recalcul les Volumes suite à la modification des %

2.3. 3. Existing Links 3. Order_Header_CES_Keep_Selection.pro => Source / Cible Order_link_ces.cub => sauvegarder le % modifié dans % Save 3. Affichage des la totalité des Mnemonics (All_Elem) vs Order_Headers_CES (MDX) vs Version avec les % save avec la possibilité de modifider le % save dans le Cube Order_Link_CES.cub

2.4. 4. Suppression Links ( Order_Header_CES_Erase_Selection.pro) => Suppression des %save pour vider les volumes. 4. Create Order And Related Lines ( Order_Header_CES_Create&Feed Order Header & order Line (C&V)) => Source Order_Link_CES / Cible Sales_DB+Orders_input_CES.cub, => Le meme Order Header ne peut pas contenir deux Order_line avec et sans IHS => Run Order_Header_CES_Create_Order_line_ID => mise a jour Update_order_line_ces.dim dimension tempo toujours vide / vérifier si les codes Order_Header_Line existe déja dans la dimension Order_CES et les creer dans Update_Order_CES en premiere position pour afficher dans un correct ordre, on ajoute aussi le reste des Order_line

3. Order ID CARD

3.1. 1. Order ID => zADM_Selectors ( PickList ) 1. Priority => Order_input_CES ( PickList ) 1. Sales Manager => Order_Input_CES ( PickList ) 1. PLM => Order_Input_CES ( PickList ) 1. Type => Order_Input_CES ( PickList ) 1. Save (Sprint_2_CES_Feed_Sales_DB_CES_Order_Header.pro) => Permet d'envoyer les carac et les volumes dans Sales DB (mendatoryField) => PLM code a supprimer (Perf)

3.2. 2. Affichage des données sur les Volumes 2. Orders_Input_CES. cub liste des OH_Informations_CES vs Order_Header_ND

3.3. 3. Affichage de la liste des Orders_CES vs version selectionnée vs all periods vs Kpy OH informations CES

4. ORDER LINE ID CARD

4.1. 1. ORDER & ORDER LINE DESCRITPION 1. ( Order ID ) => zADM_Selectors (pickList) 1. ( Order Line ID ) => zADM_Selectors (DBRW) 1. Line Description (Attribut) 1. Duplicate Order Line => Order_Header_CES_Duplicate_Order_Line.pro => Permet de dupliquer un OL a partir d'un OL existant (select) ok que si les champs sont rempli en totalité on recupere que les Carac pas de volumes

4.2. 2. IHS CARAC 2. Desactivate Order Line => Order_Header_CES_Desactivat_Order_Line.pro => il va modifier le parent pour le mettre sous les Desactiver_Oder

4.3. 3. Tank Technology => Orde_Input_CES (Pick list) 3. Filler Pipe Origin => Orde_Input_CES (Pick list) 3. Mat Group 1 => Orde_Input_CES (Pick list)

4.4. 4. BUSINESS ATTRIBUTES 4. PO Selling Plant => Orde_Input_CES (Pick list) 4. PLM Project Code => Orde_Input_CES (Pick list) 4. Type => Orde_Input_CES (Pick list) 4. In OI Budget => Orde_Input_CES (Pick list) 4. Status => Orde_Input_CES (Pick list) 4. Incumbent supplier => Orde_Input_CES (Pick list) 4. Contract Currency => Orde_Input_CES (Pick list) 4. Destination => Orde_Input_CES (Pick list) 4. Brand Grouping Trigram => Orde_Input_CES (Pick list) 4. In Reforecast => Orde_Input_CES (Pick list)

4.5. 5. Material MARGIN 5. TOTAL Sales Price => Orde_Input_CES (DBRW) 5. Resin => Orde_Input_CES (DBRW) 5. Directed Components => Orde_Input_CES (DBRW) 5. Contract Amortization => Orde_Input_CES (DBRW) 5. Value Added & Other => Orde_Input_CES (DBRW) 5. BOM Costs => Orde_Input_CES (DBRW)

4.6. 6. DATES 6. SOP (Order Line) => Orde_Input_CES (picklist) 6. EOP (Order Line) => Orde_Input_CES (picklist)

4.7. 7. SAP INFORMATION 7. Short Part Code => Orde_Input_CES (DBRW) 7. Ship-To Description => Orde_Input_CES (DBRW) 7. Save => Sprint_2_CES_Feed_Sales_DB_CES_Order_Line.pro => Copie les données Carac et les volumes de Order_inpput_CES.cub vers Sales_CES_DB.cub Source Attr Updatable de la dimension OH_Information_CES, aussi on copie les volumes

4.8. 8. Affichage des données sur les Volumes 8. Order_Inpput_CES. cub liste des OH_Informations_CES vs Order_Header_ND

5. PLM ID CARD

5.1. 1. PLM Informations => affichage des données avec les code Projet 1. PLM Code => zADM_Selectors (pickList) 1. Le reste vient de PODF 1. Save => Recalculer automatiquement la feuille

5.2. 2. Volumes venant de PODF 2. Affichage des OH_Information_CES vs Version mdx vs Orders_CES mdx (Order_input_CES.cub)

5.3. 3. Hight Runner Volume Details => Affichage des Order line Enfant du PLM code 3. Affichage de la liste des Orders_CES mdx vs version mdx vs PO Business Plan Volumes (OH_INof) vs Periods (Order_input_CES.cub)

5.4. 4. Low Runners vol & Sales 4. Affichage des Orders_CES mdx (LR) et OH info_ces ( PO busi plan Vol, Price, Turn) vs Version mdx vs Period mdx ( Sales_DB_CES )

5.5. 5. Service Parts Volumes & sales 5.Affichage des Orders_CES mdx (Serv) et OH info_ces ( PO busi plan Vol, Price, Turn) vs Version mdx vs Period mdx ( Sales_DB_CES )

5.6. 6. Tooling & Dev Sales 6. Affichage des Orders_CES mdx ( Tooling & Dev) et OH info_ces ( PO busi plan Vol, Price, Turn) vs Version mdx vs Period mdx ( Sales_DB_CES )

5.7. 7. Other Sales 7. Affichage des Orders_CES mdx (Other) et OH info_ces ( Turnover) vs Version mdx vs Period mdx ( Sales_DB_CES )

6. Data Entry Grid

6.1. CES - ORDER HEADER SELECTION.XLSM Vue sur la Sales_DB 1. Apply Selection => Order_Header_CES_Filter_Sales_DB_CES.pro => a remplacer par un refresh 1. Save => Order_Header_CES_Masterprocess_Save_Sales_DB.pro => copier les données de Sales_DB.cub vers INPUT_Order_CES.cub 1. Order or PLM => zAdm_Selectors 1. Information Set => zAdm_Selectors 1. Check Data Quality

6.2. 2; Affichage des Orders_CES mdx (ALL) et OH info_ces ( ALL ) vs Version mdx vs Period mdx ( Sales_DB_CES )

7. Go To

7.1. 1. Affichage de la totalité des information (attribut) de la dimension Order_CES 1. Filter on this line => zAdm_Selectors ( pickList )

8. d

9. PAW

10. 2a Sales Price Variances

10.1. Input SPV per Order Line 1. CES - Selection ComSaving.xlsm 1. Selection: 1. Order Number => zAdm_selectors ( picklist 'Order_Header_ID_CES') 1. Project => zAdm_selectors (picklist 'Project_ID_CES') 1. Short PartCode => zAdm_selectors ( picklist 'PartCode_ID_CES') 1. Plant => zAdm_selectors ( picklist 'Customer_Plant_CES') 1. OEM => zAdm_selectors ( picklist 'OEM_ID_CES') 1. Ship-To => zAdm_selectors ( picklist 'Ship-to_ID_CES') 1. Current Version Selected => zAdm_selectors ( picklist 'Versions_CES') 1. Botton Apply => refresh calcul 1. Botton Save SPV => ComSaving_CES_SendDate_To_Calculation_Cube.pro 2. Selected Order Lines 2. Affichage des Orders_CES (mdx) vs ComSaving_Change_Number (mdx) vs ComSaving_Informations sur le cube ComSaving_Input_CES.cub

10.2. Input SPV - Multiple Order Line 1. CES - ComSaving Only Selection.xlsm 1. Selection: 1. Order Number => zAdm_selectors ( picklist 'Order_Header_ID_CES') 1. Project => zAdm_selectors (picklist 'Project_ID_CES') 1. Short PartCode => zAdm_selectors ( picklist 'PartCode_ID_CES') 1. Plant => zAdm_selectors ( picklist 'Customer_Plant_CES') 1. OEM => zAdm_selectors ( picklist 'OEM_ID_CES') 1. Ship-To => zAdm_selectors ( picklist 'Ship-to_ID_CES') 1. Current Version Selected => zAdm_selectors ( picklist 'Versions_CES') 1. Botton Apply => refresh calcul 1. Botton Save SPV => ComSaving_CES_SendDate_To_Calculation_Cube.pro 2. Affichage des données ComSaving_Inpout_CES.cub 3. CES - ComSaving Change Information.xlsm 3. ComSaving_CES_SendDate_To_Calculation_Cube.pro 3. Input données ComSaving_Input_By_User_CES.cub 4. Order Line 4. Affichage des données Versions_CES (mdx) vs Orders_CES (mdx) vs ComSaving_Change_Number (mdx)

10.3. Reporting 1. CES - ComSaving Only Selection.xlsm 1. Selection: 1. Order Number => zAdm_selectors ( picklist 'Order_Header_ID_CES') 1. Project => zAdm_selectors (picklist 'Project_ID_CES') 1. Short PartCode => zAdm_selectors ( picklist 'PartCode_ID_CES') 1. Plant => zAdm_selectors ( picklist 'Customer_Plant_CES') 1. OEM => zAdm_selectors ( picklist 'OEM_ID_CES') 1. Ship-To => zAdm_selectors ( picklist 'Ship-to_ID_CES') 1. Current Version Selected => zAdm_selectors ( picklist 'Versions_CES') 2. Affichage des données Order-Ces (mdx) vs ComSaving_Change_Number (mdx) vs ComSaving_Reasons_Code (mdx) dans le cube ComSaving_DB_CES.cub