1 / 11

Movex User Association

Movex User Association. John Calvey European B.I. Manager NewellRubbermaid - www.newellco.com. Project Background. Company Overview NewellRubbermaid Business Requirement Identify Issues Possible Options Chosen Solution Current Status and Future Plan. The Company. Fortune 500 Company

edmund
Download Presentation

Movex User Association

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Movex User Association John Calvey European B.I. Manager NewellRubbermaid -www.newellco.com

  2. Project Background • Company Overview NewellRubbermaid • Business Requirement • Identify Issues • Possible Options • Chosen Solution • Current Status and Future Plan

  3. The Company • Fortune 500 Company • European Headquarters in Paris • European Data Centre Located in Sunderland • Systems • Movex Installed Since 1999 • Demand Solutions (Forecasting) • PKMS Warehouse Management • Hyperion – Financial Budgeting • TM1 – Financial Budgeting • Cognos Used for BI Reporting • Web based 1200 users • 400+ Powerplay Cubes • 1000 Impromptu Reports

  4. Business Requirement • Company Re-Organisation • From Four Business Units • RCP • GRACO • Sanford • Irwin Tools • To a Single Reporting Structure • What Does That Mean? • Each split into a number of Divisions • Reporting • Each with their own store of data & Reporting Requirements • Cognos Cubes and Reports built in the overnight window

  5. Current Architecture iSeries (DB2) Data Point to Impromptu Transactional Reports Data Point to Impromptu Transactional Reports. Sanford, RCP. Graco & Irwin P1 Movex ERP System P2 BI Staging NOMAX Replication Data Point to Powerplay Cubes RCP & Graco Wintel (SQL) Microsoft SQL Server DTS Extracts Sarbanes-Oxley DataWarehouse Data Point to Impromptu Business Level Reports (Sarbanes) Sanford DataWarehouse Exchange (External data) Data Point to Impromptu Reports and Powerplay Cubes (Sanford) Irwin Tools DataWarehouse Data Point to Impromptu Reports and Powerplay Cubes (Irwin Tools)

  6. Business Requirement - Implications • Issues - 1. Data & Process Harmonisation • Use of Master Data, Customer Numbering etc • Product Hierarchies • Customer Hierarchies • Supplier Harmonisation complete • Process Change • External (non Movex) Data to be captured • Solution Internal Resource • Business Knowledge • Movex Knowledge

  7. Business Requirement - Implications • Issues - 2. Reporting • New Powerplay Cubes • Larger Data Volumes • 500k Customer Records • 450k Item Master Records • OSBSTD 150 Million Records • Larger Cubes / More Variations • Greater Build Times (Same Overnight Window Available) • New Reports • Historical and Real Time Reporting Requirements • External Data (non Movex) • Business Logic – In One Place

  8. Proposed Architecture Data Point to Impromptu Transactional Reports Movex ERP System Data Push (Changes) Wintel DataWarehouse Environment Enterprise Environment Data Point to Impromptu Business Level Reports Exchange (External data) Data Views (DataMarts) Data Push (Changes) Staging Environment Other Data Sources Data Point to Powerplay Cubes Staging linked to ERP / Source Systems Enterprise & Data Marts Independent of ERP / Source System

  9. Proposed Solutions for Architecture • Have to Change • Combining the Extracts, the Overnight Window – Too Small • Cubes Build Time – will increase • Available Time For Data Extract – will decrease • Re-handling Data • Time • Bandwidth • Options • Part Data Extracts / Full Weekly Extracts • Build Cubes Weekly, Incremental Builds • ETL Tool

  10. Solution • Vision Software - Integrator • Reasons • Software • iSeries and SQL Server • Identify Changes • Data Transformation Capabilities • Daisy Chain (iSeries >>> SQL Staging >>> SQL Enterprise) • Monitoring • Company • iSeries knowledge • Previous work • Prototype Test • Project Plan • Vision installed software / basic training • Ran for 4 weeks • Contact with Vision support during this time – excellent (and since!) • Additional Benefits Identified • Reduced Development and Maintenance Time • Reduced Errors • Standardisation • Single Data View • Business Process Rules held once • Date and Time Stamp on Records

  11. Current Status • Software • Live Version Installed • Replication Status • 25 tables replicating Movex to Staging • 5 tables to Enterprise • Plan • 60 tables • 30 Master Tables • 30 Transaction Tables • Business Logic being applied to Enterprise • “Use of Data” – transaction date / time information

More Related