Setting up a Successful Reporting Solution with Oracle

Setting up a Successful Reporting Solution with Oracle Discoverer and Other Tools The Top 7 Reasons Why Oracle Users Rely on Noetix. Views for Reporting Joe Dahl, Sales Consultant

Agenda • • • About Noetix Reporting Challenges The Noetix Solution Product Demonstration Q&A Copyright © June 2006 by Noetix Corporation – All Rights Reserved

About Noetix • Enterprise Application Metadata experts since 1994 • Offices in Europe, US and Asia • Oracle Certified Partner • Siebel Validated Software Partner • Microsoft Gold Partner • 1, 400+ Customers Worldwide Copyright © June 2006 by Noetix Corporation – All Rights Reserved Industry AWARDS

Reporting Challenges

Reporting Challenges Packaged Business Intelligence Tools Tailored Templates Generic Reporting Templates ü Manual mapping of data equates to significant cost and delay of most BI tools With Noetix you have ™ Reporting Gap – Manual Mapping Noetix Meta. Builder ü Reduced time to information ü Reduced cost of implementation Unique to Application Configuration Changes Application Configuration Oracle Applications ü Reduced total cost of ownership ü Minimum project risk ü No additional rework costs or delay with upgrades Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Performance at a Price • RDBMS and underlying Database design allows optimal Online transaction processing (OLTP) performance Oracle Applications 11 i Copyright © June 2006 by Noetix Corporation – All Rights Reserved

The DB Consists of 1000 s of Objects Tables Packages (Procedures & Functions) Grants/Synonyms Views (Limited use) Database Users (Application User Security) Roles (Limited use in HR modules) Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Querying Oracle Applications Using SQL Columns Tables (or Views) Conditions & Data Relationships Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Overview of Noetix. Views

7 Reasons Oracle Users Rely on Noetix. Views for Reporting • • Information All in One Spot Auto-Generated Content Open Systems Flexibility Automatic Upgrade Protection Performance Optimization Index Column Identification Customized Help File System Copyright © June 2006 by Noetix Corporation – All Rights Reserved

#1 Information All in One Spot Oracle changes the database. . . HZ_PARTIES Flexfield column in the table HZ_CUSTOMERS HZ_CUST_ACCOUNTS ATTRIBUTE 1: “Customer Status” OE_ORDER_HEADERS_ALL PA_PROJECTS_ALL PA_TASKS Version 2 1 OE_ORDER_LINES_ALL MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_TL Sample Oracle database tables Copyright © June 2006 by Noetix Corporation – All Rights Reserved üSimplify access üConfiguration specific üUpgrade protection Noetix remaps the View… Order Lines ATO Flag Booked Date Customer No. Cust. Status Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Noetix “View” of the database Doesn’t break Orders Order No. Customer Flexfield column in the view Cust. Status Booked Date Order Quant. Open Quant. Selling Org. Report

# 2 Auto-Generated Content • Noetix. Views creates a comprehensive set of views which “simplify” the underlying database design of Oracle Applications Views mask the complexity Copyright © June 2006 by Noetix Corporation – All Rights Reserved

What is Metadata? Your configuration… Users/Roles Organizations Noetix Meta. Builder Noetix Metadata Repository Oracle Applications 11 i Setups Copyright © June 2006 by Noetix Corporation – All Rights Reserved Business Rules

How Noetix Uses Metadata Oracle Applications 11 i Noetix Metadata Repository Security KPIs and metrics Noetix. Views Transaction data Copyright © June 2006 by Noetix Corporation – All Rights Reserved Query & reporting

Flexfields as Configured Key Flexfield Base Table Column Names Key Flexfield View Column Names SEGMENT 12 Account$Company SEGMENT 6 Account$Division SEGMENT 3 Account$Cost_Center Descriptive Flexfield Base Table Column Names Descriptive Flexfield View Column Names ATTRIBUTE 2 VEND$WWW_Site ATTRIBUTE 9 VEND$Preferred_Vendor ATTRIBUTE 11 VEND$Approved_Until Copyright © June 2006 by Noetix Corporation – All Rights Reserved

List of Values (Quick. Picks Decoded) Stored Oracle Values Retrieved Noetix Values STATUS_LOOKUP_CODE Status A C I P Active Closed In Process Printed TERMS_ID 1000 1001 1002 1020 4 5 Payment_Terms Copyright © June 2006 by Noetix Corporation – All Rights Reserved 2/10, Net 30 30/60/90 Due 10 th Net 30 Net 15 Immediate

# 3 Open Systems Flexibility Audience Business Users/Managers Unique Reporting Needs Pre-built Reports Ad hoc Access ü ü ü ü Discoverer Oracle Reports Crystal Noetix Web. Query Business Objects Cognos Brio Senior Mgmt Dashboards Analysts Controllers Excel Formatted/Ad hoc Copyright © June 2006 by Noetix Corporation – All Rights Reserved

# 4 Upgrade Protection • Insulates queries against physical changes – – Application upgrades Patches Point Releases Configuration Changes Copyright © June 2006 by Noetix Corporation – All Rights Reserved 11 i R 12

# 5 Performance Optimization • Each View references many tables – Complex Queries – Union Relationships • Noetix Development involves Tuning – SQL Trace – “Explain Plan” – TKProf Copyright © June 2006 by Noetix Corporation – All Rights Reserved

# 6 Indexed Columns Identified View Columns which use an index (indicated by ‘A$’ prefix) PO_Purchase_Orders Search by hints tell how to build fast queries A$BUYER_NAME A$BUYER_NUMBER A$PO_CREATION_DATE A$PO_NUMBER A$VENDOR_NAME A$VENDOR_NUMBER PRINTED_DATE VENDOR_NAME STATUS TERMS Copyright © June 2006 by Noetix Corporation – All Rights Reserved

# 7 Customized Help File System • MS Windows Help File Format • HTML Help File Structure Format Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Noetix. Views for Oracle Applications • • • Financials — AP, AR, FA & GL Supply Chain — INV, OM & PO Manufacturing — MRP, BOM, WIP, CST and OPM Human Resources — HR, PAY, BEN, OAB Project Accounting — PC & PB Service — Field Service, Teleservice, Depot Repair, Install Base Grants Cross Operations Extension Custom Modules Through Oracle Applications versions 11. 5. 10 Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Noetix. Views Cross Operations Extension SIRA Inc. Set of Books Operating Units Inventory Orgs Set of Books Airplane Group Automobile Group Operating Unit Commercial Military Automotive Motorcycles INV / Man. Organization Washington INV / Man. Organization California New York Copyright © June 2006 by Noetix Corporation – All Rights Reserved INV / Man. Organization Texas INV / Man. Organization Virginia

BI Content Generation Experts Oracle E-Business Suite Siebel CRM People. Soft Noetix. Views Oracle Database Noetix. Answers Oracle Discoverer Cognos BI Business Objects Oracle Business Intelligence EE Copyright © June 2006 by Noetix Corporation – All Rights Reserved

Noetix Solution — Components • Noetix Dashboards KPI’s for various functional areas presented via a graphical display • Noetix Query. Server® Integrates disparate data sources into a secure query routing and management platform. Noetix Web. Query® Empowers decision makers to create and modify reports without IT involvement. Noetix Answers™ Delivers hundreds of click-on, customizable answers to business questions. • • • Noetix Generators for BI Tools Automatically generates the metalayer for Discoverer, Cognos, BOBJ, and OBIEE with your content Noetix. Views® Provides hundreds of views of the underlying data structures organized by functional area. Noetix Navigator™ Efficiently instructs users in report creation by documenting your Oracle Application specific configurations Copyright © June 2006 by Noetix Corporation – All Rights Reserved Through Oracle Applications - 11. 5. 10 • • Financials – AP, AR, FA & GL • • • Cross Operations – Sof. B’s, OU’s, Inv Org’s Supply Chain – INV, OM & PO Discrete Manufacturing – MRP, BOM, WIP & CST Process Manufacturing - OPM Human Resources – HR, PAY & OAB Project Accounting – PC & PB Service – Teleservice, Field Service, Depot Repair, Install Base DW Views – GL, AP, AR & OM Solutions for: CRM

Product Demonstration

Why We are Successful Pre-generated Content – Views and reports that pick up configuration End User Independence – Ease of use Faster Time to Market – Predictable, proven implementation Open Architecture – Easily integrate with other data sources Performance – Don’t have to sacrifice real-time data Change Management – Upgrade protection Copyright © June 2006 by Noetix Corporation – All Rights Reserved