Spanning the Oracle EBS Reporting Spectrum Operational and

Spanning the Oracle EBS Reporting Spectrum Operational and Analytical Reporting Joe Dahl – Product Specialist

About Noetix • BI solutions experts since 1994 • Offices in North America, Europe and South Asia • Certified with all leading BI Platforms • Recent Product Awards: KMWorld, e. WEEK, DMReview • 1400+ customers globally PARTNERSHIPS

Noetix’s History of Dedication to Oracle Applications Reporting Noetix Analytics Noetix Generator for Cognos Noetix EUL Generator Noetix incorporated 1995 Noetix. Views for People. Soft Noetix for Siebel 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1994 Noetix. Views Noetix Platform Noetix Dashboard Noetix Generator for Business. Objects Noetix Generator for Oracle BI

Noetix Business Intelligence

Noetix Supports the Full Spectrum of Reporting Needs Enterprise Models Common Dimensions Strategic Performance Management Packaged ETL Enterprise-wide Analytics / KPIs Data Integration Near Real-time Operational Reports Summarized Data Ad hoc query Historical Trending Real-time Drillable Reports Detailed Database Views Application Security

Operational Reporting

BI Content Generation Experts Oracle E-Business Suite Siebel CRM People. Soft Noetix. Views Oracle Discoverer Noetix. Answers Noetix Platform Noetix Analytics Cognos BI Business Objects Oracle Business Intelligence EE

The Information Gap Query, Reporting and Analysis Tools Generic Templates M Ma ap n. Information p u ianl g MRa ep w p io nr g k > < The Gap Custom Application Configuration (v 1) Enterprise Application (v 2) Additional costs 70% of BI Additional implementation resources costs & delay Additional delay

The Information Gap Query, Reporting and Analysis Tools Generic Templates Generated Content < The. Noetix Information Meta. Builder. Gap > Generates configuration specific BI content Custom Application Configuration Enterprise Application (v 2) (v 1) No additional rework costs or delay

Information About Your Setup Information about your enterprise application Business Best Practices Configuration User Interfaces Financials Supply Chain Flexfields Security Human Resources Manufacturing [Interrogated] [Handcrafted] Generated data Business Views [Configuration-specific Views] Reports [Configuration-specific Answers] Documentation [Configuration-specific Help]

What is a Noetix view? Oracle database tables [Oracle EBS upgrade] HZ_PARTIES Flexfield column in the table HZ_CUSTOMERS HZ_CUST_ACCOUNTS ATTRIBUTE 1: “Customer Status” OE_ORDER_HEADERS_ALL Noetix view of the database Your report [remaps view] [doesn’t break] Order Lines Orders ATO Flag Booked Date Customer No. Cust. Status PA_PROJECTS_ALL PA_TASKS OE_ORDER_LINES_ALL MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_TL Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Flexfield column in Order No. the view Customer No. Cust. Status Booked Date Order Quant. Open Quant. Selling Org.

Oracle Flexfields and Noetix Key Flexfield Base Table Column Names Key Flexfield View Column Names SEGMENT 1 Company SEGMENT 2 Division SEGMENT 3 Cost Center Descriptive Flexfield Base Table Column Names Descriptive Flexfield View Column Names ATTRIBUTE 1 Web Site ATTRIBUTE 2 Preferred Vendor ATTRIBUTE 3 Approved Until

Noetix. Views Help File Noetix groups views by functional area into roles. A set of roles are created for each business group, set of books and operating unit for each module where applicable. The first 3 -5 characters in a role name, or role “prefix”, is defined by the customer at install time.

Noetix. Views Global Extension SIRA Inc. Global HR, BEN, PAY, OTL Business Group United States United Kingdom Global GL, FA, FV, AR, AP, Chart of Accounts “A” Sets of Books/Ledgers PO, OE, PB, PC, GMS Operating Units Chart of Accounts “B” Sets of Books/Ledgers Operating Units Chart of Accounts “C” Sets of Books/Ledgers Operating Units Master INV Organization “Y” INV Organizations Master INV Organization “Z” INV Organizations Global INV, BOM, WIP, CST, MRP, EAM, QA Master INV Organization “X” INV Organizations Also Global: ASCP, Service & OPM Suites

Global Security • Row-level security • EBS data access privileges of the user – Manual & automatic setup – Applications Data is secured – Organizational accessibility – Application-specific security is enforced – MOAC (Multi Org Access Control) supported • Custom row-level security option, as needed

Noetix Generator

How BI Tools Ship – No Content

Noetix leverages existing EBS and BI platform investments Noetix Web. Query Oracle Discoverer Noetix Dashboard Oracle BI Suite EE Virtual tables End User Layer / Enterprise Information Model Cognos 8 BI Models / Packages Business. Objects Enterprise XI Business. Objects Edge Series Other Third-party BI Tools Universe BI Platform Semantic Layer Repositories and Report Catalogs Noetix Generator Oracle E-Business Suite Noetix. Views Other data models

Noetix Provides a Reporting Application With Any Front End Tool NOETIX HELP FILE OBI EE COGNOS DISCOVERER

Noetix Search Key Benefits • Powerful Search Capability for Report Developers – Familiar user interface – Easily find the right view(s) for queries & reports • Reporting Objects Cross-Referenced – List all views by column – List all Oracle tables by view – List all columns by Oracle table by view – List all views by Oracle table • Print/Save PDF Files of Views/Columns/Tables Detail • 360 Degree View of Your Views!

Bringing Search to Noetix Reporting Filter search by view names, view column names, table names and table column names. Search across multiple instances of Noetix. Views. Guided navigation enables searching by roles, modules, and Oracle configuration

Noetix. Views Coverage

Analytical Reporting

BI Challenges • Achieve business reporting and data analysis requirements • Minimize or eliminate impact on the production transaction database (OLTP) • Improve query performance • Capture transitory or historical data that no longer resides in the OLTP database • Integrate data from multiple disparate databases

Noetix Analytics • “Packaged” subject area data models in star schema data marts – – Conformed dimensions and dimension hierarchies Snapshot data for history and trending • Detailed data for full drill in Operational Data Store • Pre-built ETL mappings from Oracle EBS – – Complex transformations into data marts Change Data Capture for incremental refresh • Integration interface to integrate legacy data • Extensibility framework for customizations • Pre-defined performance measures (KPIs), dashboards and reports – AP/AR Aging, Working Capital Management, Net Bookings, Profitability Analysis, Vendor Performance & Quality, Headcount & Turnover Analysis • Active metadata repository with administration tools • Generators for integration with BI Platforms

Sample Noetix Analytics Subject Areas Working Capital Profitability Projects Sales ASCP Discrete MFG Cash Conversion Cycle Daily Net Revenue Project Commitment Details Backlog Full Pegging by MSC Plans BOM Costing Days Sales Outstanding Margins by Customer, Product, Rep Expenditure Details Cost of Sales by Customer, Product, Rep Exception Demand/Suppl ies by Resource Make Items with no BOM Days Inventory Outstanding Projects Revenues Project Revenue Details On-time Performance Exception Demand/Suppl ies by Customer Order Items with no Associated Job Days Purchasing Outstanding Projects Expenditures Cost Center Distribution Lines Net Bookings & Net Change MFG BOM Operation Sequences by MSC Plans Component Usage History, Trends Open Receivables & Payables Operating Income as % of Sales Job Bill Rate Overrides Debookings/ Rebookings PO Lines by Implement Task Quantity Built vs. Quantity Ordered Spend by Period and Vendor Gross Profit (Contribution) Cost Center Organization Relationships Projected COGS Per Order MFG BOM Operation Sequences by Customer Material Transactions By Plant to Ship

Noetix Analytics Architecture Dashboards Metadata Repository Help System Metadata Manager Metadata Layer Data Marts Noetix Generator 100+ Data Sources Integration Interface 2 nd Tier ERP Packaged Analytics Operational Data Store Informatica Power. Center Extraction Views Packaged ETL Oracle E-Business Suite Data Warehouse Reports Cubes Revenue Trends KPIs

Product Demonstration Noetix Analytics

Noetix Functional Coverage

Noetix Business Intelligence Reporting across the BI spectrum BI APPLICATIONS Packaged Reports Packaged Analytics Answers Dashboards KPIs Drillable Reports BI PLATFORMS Noetix for Excel Oracle BI Discoverer Cognos Business Objects METADATA GENERATORS ENTERPRISE BI MODELS OLTP Database Views Data Warehouse Operational Data Store Data Marts METADATA SERVICES & DATA INTEGRATION ENTERPRISE APPLICATIONS E-Business Suite People. Soft Siebel Legacy JD Edwards QAD MFG/PRO

Noetix Business Intelligence

Supports Noetix Core Values Rapid Implementation Open Architecture P P Configuration Specific P Bringing Data Into View Extensible Metadata Driven Lowest TCO P P P