Spanning the Oracle EBS Reporting Spectrum Noetix Business

Spanning the Oracle EBS Reporting Spectrum Noetix Business Intelligence Joe Dahl – Product Specialist

BI: Necessary & Difficult The return on your investment in E-Business Suite can’t be realized without a robust BI solution… The challenges are many, the options few. .

Why Invest in BI? “Don’t implement BI – implement an end goal…. It’s vital to remember that the purpose of BI is to produce information and insight. Thus, deciding what insight your business needs is the first step to implementing BI. ” - Ian Whiting, SVP Brocade Communications Vendor view: Five tips for integrating BI and ERP, CIO. com

How Not to Invest in BI

Common Business Drivers Maximize Revenue • Increase product margins • Increase Projects Profitability dsd Maximize Efficiencies • Business users writing their own reports • Streamlined GL period close Maximize Global view of vendor spend to maximize vendor discounts – GE Global Visibility • Global view of customer margins and profitability • Global instances for US, EMEA, Brazil, etc.

Common IT Drivers a Change ERP Exp Change BI Platform Organization • Major Oracle EBS upgrade • New implementation of Microsoft BI • New Oracle EBS implementation • Migration from Discoverer to Cognos • Acquisition required new ERP instance • New joint venture required new ERP instance

Full-Spectrum BI Content Copyright © 2011 by Noetix Corporation. All rights reserved.

How Useful Is The Information? • How useful is this information? • Could you easily find your destination? • Would maps help? • How about search and navigation?

Noetix provides the mappings • How useful is this information? • Could you easily find your destination? • Would maps help? • How about guided navigation?

Noetix Provides Management Dashboards

Noetix. Views Content Real-Time Transaction Reporting Financials Human Resources Order Management Procurement Discrete Manufacturing General Ledger Human Resources Order Management Purchasing Receivables Advanced Benefits Quoting Payables Payroll i. Expense Learning Management Assets Incentive Compensation Cash Management Time & Labor Work in Process Enterprise Asset Management Labor Distribution Cost Management Process Manufacturing Projects Service Costing Tele. Service Development Billing Field Service Bills of Material Execution Project Contracts Depot Repair Master Scheduling MRP Financials Project Management Install Base Inventory Quality i. Procurement Advanced Supply Chain Planning Service Contracts

Noetix Analytics Content Enterprise Strategic and Analytical Reporting Financials Human Resources Order Management Procurement General Ledger Human Resources Order Management Purchasing Receivables Benefits Quoting Payables Payroll Advanced Pricing Bills of Material Execution Depot Repair i. Expense Learning Management Release Management Master Scheduling MRP Financials Install Base Assets Incentive Compensation Shipping Execution Financial Statement Generator Warehouse Management Discrete Manufacturing Process Manufacturing Inventory Quality Development Advanced Supply Chain Planning Work in Process Working Capital Cost Management Enterprise Asset Management Engineering Projects Service Costing Tele. Service Billing Field Service Contracts

Noetix Business Intelligence BI APPLICATIONS Operational Noetix. Answers Strategic/ Analytical Noetix Analytics Dashboards Noetix Analytics Answers BI PLATFORMS Noetix Platform Oracle BI EE Oracle Discoverer IBM Cognos BI SAP Business Objects Microsoft BI NOETIX GENERATOR ENTERPRISE BI MODEL Data Warehouse Transactional Noetix. Views NOETIX METABUILDER Noetix Analytics ODS Noetix Analytics Data Marts INFORMATICA ENTERPRISE APPLICATIONS Oracle E-Business Suite Other Oracle Applications Legacy Applications Other ERP/CRM Applications Custom Applications

Noetix Business Intelligence Noetix. Views BI APPLICATIONS Operational Noetix. Answers Strategic/ Analytical Noetix Analytics Dashboards Noetix Analytics Answers BI PLATFORMS Noetix Platform Oracle BI EE Oracle Discoverer IBM Cognos BI SAP Business Objects Microsoft BI NOETIX GENERATOR ENTERPRISE BI MODEL Data Warehouse Transactional Noetix. Views NOETIX METABUILDER Noetix Analytics ODS Noetix Analytics Data Marts INFORMATICA ENTERPRISE APPLICATIONS Oracle E-Business Suite Other Oracle Applications Legacy Applications Other ERP/CRM Applications Custom Applications

Noetix Business Intelligence Noetix Analytics BI APPLICATIONS Operational Noetix. Answers Strategic/ Analytical Noetix Analytics Dashboards Noetix Analytics Answers BI PLATFORMS Noetix Platform Oracle BI EE Oracle Discoverer IBM Cognos BI SAP Business Objects Microsoft BI NOETIX GENERATOR ENTERPRISE BI MODEL Data Warehouse Transactional Noetix. Views NOETIX METABUILDER Noetix Analytics ODS Noetix Analytics Data Marts INFORMATICA ENTERPRISE APPLICATIONS Oracle E-Business Suite Other Oracle Applications Legacy Applications Other ERP/CRM Applications Custom Applications

Analytical (BI maps) Data Mart Operational Data Store Set of Books Product Order Headers Org Set of Books Product Order Lines Ship To Org Ship To

Product Demonstration

Product Demonstration Agenda Noetix Content in Major BI Tools • Noetix Answers in Cognos (Views) • Advanced Reports in Business Objects (Analytics) • Dashboards in OBIEE (Analytics)

Leverage Your BI Tool of Choice VISA Nordstrom Invacare Hertz Garmin Netflix Discoverer Web. Ex AECOM Technology Goodrich Hologic Trimble Navigation Cognos Other (Web. Focus, Microsoft BI, etc. ) American Tire Boart Longyear Con-Way Meritor Paychex ALSAC/St. Jude Dell Real. Networks Cummins Business Objects Noetix Platform ARCO Aluminum Fiji Water City of Detroit Trinity POM Wonderful Master. Card OBI EE Alticor Boart Longyear Qualcomm Stanford University

Business Value of Noetix BI

Customer Snapshot – AECOM is a global provider of Revenues (Millions): professional technical and $6, 300 management support services to a Employees: broad range of markets, including 46, 000 transportation, facilities, Locations: environmental, energy, water and 100 Countries government. ● Financials ● Procurement ● Human Resources ● Projects Industry: Engineering & Construction

AECOM Architecture REPORTING TOOLS Statistics: ODS. 5 TB Data Marts. 3 TB 160, 000 Projects 1. 4 M Project Tasks IBM Cognos TM 1 20 M GL Lines 50 M Project Cost Distribution Lines 380 M HR Element Entry Values EBS – R 11 Noetix Analytics Warehouse SOURCE SYSTEMS Oracle EBS Cognos TM 1

Customer Snapshot – Boart Longyear is the world’s Revenues (Millions): leading integrated drilling services $1, 460 provider and products manufacturer Employees: for the Minerals Industry, with a 9, 500 substantial presence in the Locations: Environmental & Infrastructure and 100 Countries Energy Industries. ● Financials ● Procurement ● Order Management ● Manufacturing ● Inventory ● Costing ● Working Capital ● Service Contracts ● Supply Chain Industry: Drilling Products & Services

Boart Longyear Architecture REPORTING TOOLS Quick Stats: 1 Production Instance of Noetix Analytics Business Objects OBI EE BI Publisher Oracle On Demand Customer. Warehouse in Customer Data Center Customer Since: 2010 Noetix Analytics Warehouse Alternatives Considered: OBI EE and BI Applications SOURCE SYSTEMS Legacy ERP, Hyperion, Salesforce. com Oracle E-Business Suite [Clone] Oracle E-Business Suite [On Demand]

Boart Longyear Reporting Statistics

Customer Snapshot – American Tire ATD is one of the nation's largest Revenues (Millions): independent suppliers of tires to the 2, 700 replacement tire market. It operates 84 distribution centers providing a selection of tires, wheels and related products and value-added Employees: 2, 500 Locations: 37 States services. Industry: ● Financials ● Procurement ● Discrete Manufacturing ● Order Management ● Inventory Distribution/Wholesaler

American Tire Architecture REPORTING TOOLS DW Stats: 1 Production Instance 6 TB Warehouse on SQL Server Microsoft Reporting Services Microsoft Share. Point Microsoft Analysis Services Microsoft BI Highlights: Analysis Services Cubes Excel primary tool Noetix Analytics Warehouse SOURCE SYSTEMS One Production Instance of Oracle E-Business Suite Custom Distributor Management System

Customer Snapshot – Invacare Corporation is the global Revenues (Millions): leader in the manufacture and $1, 600 distribution of innovative home and Employees: long-term care medical products 6, 000 that promote recovery and active Locations: lifestyles. 80 Countries Industry: ● Financials ● Procurement ● Manufacturing ● Order Management ● Inventory, Costing ● Working Capital ● Service Contracts ● Human Resources ● Payroll Manufacturing

Invacare Architecture BI APPLICATIONS Quick Stats: 2 Production Instances of EBS (NA and Europe) as well as third-party and custom data sources Cognos OBI EE Discoverer Live 4 years on Noetix Analytics Noetix. Views for real-time reporting Customer Since: Noetix Analytics Global Management Reporting (GMR) Warehouse Noetix Analytics for Revenue and Profitability Analysis (IBIZ instance) Invacare ASSETS MFG Pro, JDE, Custom 2 Production Instance of Oracle E-Business Suite 2007

Customer Snapshot – Sleeman Breweries Ltd. is a leading Revenues (Millions): brewer and distributor of premium Privately Held beer in Canada and the country's third largest brewing company. Sleeman’s parent company is Sapporo Holdings Ltd. of Japan. Employees: 750 Locations: Ontario Industry: ● Financials ● Procurement ● Discrete Manufacturing ● Order Management ● Inventory Distribution/Wholesaler

Sleeman Breweries Architecture REPORTING TOOLS DW Stats: 1 Production Instance <1 TB Warehouse on Oracle Server Microsoft Reporting Services Microsoft Share. Point Microsoft Analysis Services Microsoft BI Highlights: TBD Noetix Analytics Warehouse SOURCE SYSTEMS One Production Instance of Oracle E-Business Suite

Why the Noetix Packaged Solution? • Rapid Implementation – Subject area BI maps empower users to answer their own questions • Lower TCO – Creating BI maps and maintaining them is resource intensive • Mitigated Risk Noetix BI Maps with search and navigation – Custom projects don’t meet expectations more than 50% of the time

About Noetix • BI solutions experts since 1994 • Oracle E-Business Suite centric solution • Certified with all leading BI Platforms • 1500 customers globally PARTNERSHIPS

Thanks for Attending!