For Fast Rollout of End User Reporting

1
NoetixViews

• For Fast Rollout of End User Reporting

across your entire organization
2
Agenda

• About Noetix
• Overview of our Products
• NoetixViews
• NoetixDW
• Demonstration of NoetixViews

3
About Noetix
Over 800 NoetixViews Customers Oracle Cooperative
Applications Initiative Offices in the US
UK Distributors in Europe, Middle East and Asia
4
NoetixViews
5
Running Your Business
I want to see the top 10 vendors in dollar
volume over the last year.
Which invoices were charged to my department
this month?
What is the backlog for item 1265?
What is the salary history for employees in my
department?
Now What?
6
How Do You Get Data?

• Standard Reports Usually not Available
• Technical Staff Writes Reports Time Consuming,
  Costly
• 1. Use Technical Reference Manuals
• 2. Find Tables
• 3. Determine Joins
• 4. Write SQL
• 5. Optimize SQL
• 6. Hope that all relationships were identified!
• End Users Write Reports Too Hard!

7
Querying Oracle Apps using SQL
8
End User Query Tools
All I need is an End User Query Tool

• Oracle Discoverer
• Business Objects
• Cognos Impromptu
• Crystal Reports

9
End User Query Tools - Example
10
Overview of NoetixViews
Query Tools Crystal Reports MS Access,
Excel SQLPlus Oracle Reports ODBC, Java, XML
Query Analysis Oracle Discoverer Business
Objects Cognos Impromptu Brio Query Hummingbird/GQ
L
Noetix Web Query
Metadata Layer
NoetixViews
Oracle Applications Data Base
11
Complex Joins Done for You
Information in one source that is easy to
recognize
Oracle Tables
NoetixViews
12
Automatic Setup
Customizes NoetixViews to reflect your
configuration
NoetixViews
Oracle Tables


Flexfields
Department
Mfg_Name
Quick Picks


13
Reporting Across Operational Areas
Show me the top 10 vendors in volume for our
entire company.
Get me a list of WIP shortages for all
manufacturing operations.
I need to see all the orders that are backlogged
for the entire company.
NoetixViews Cross Operations Extension
14
Report/Queries With NoetixViews
With Cross Operations Extension
Show me the top 10 vendors in volumefor our
entire company.
15
NoetixViews Product Availability

Oracle Applications NoetixViews Oracle
Financials FIN GL, AP, AR, FA Oracle
Manufacturing MFG BOM, MRP, WIP, CST Oracle
SCM SCM PO, OE, INV Oracle
Projects Projects PC, PB Oracle
HRMS HRMS HR Other Tech AOL Also... Orac
le Discoverer End-User Layer (full support) Other
Query Analysis Tools
16
Adding Value to Oracle Applications

• Faster, easier, more cost-effective access to
  business information
• Automatically builds customized business views,
  online help to your unique configuration
• Shields you from Application upgrades
• Optimized views return results FAST
• Rapid return on investment

17
NoetixViews Customers by Industry
Communications
Industrial
Financial, Insurance

• Pacific Bell
• Bell South Mobile
• Cellular One

• GE Industrial
• Honeywell
• Cummins

• Fidelity
• Merrill Lynch
• ETrade

Software
Electronics
Higher Education

• Cognos
• Oracle
• Novell

• Xerox
• Sony
• Motorola

• Harvard
• Yale
• Stanford

Entertainment
Energy/Utilities
Internet

• ARCO
• Syncrude
• Louisville Gas Electric

• About.com
• Real Networks
• Infoseek

• LucasFilm
• United Artists
• Dreamworks SKG

18
Noetix Query server enables users to query
information across the enterprise and simplifies
administration for IT staff.
NoetixViews for Oracle Applications simplifies
decision support for end users and IT staff.
NoetixDW for Oracle Applications simplifies DW
design, construction and maintenance by
automating the process of data mapping.
NoetixDW
19
Overview of NoetixDW
Business Subject Area
Balances Subject Area
End User Query
Views
Subject Area Schemas
20
Thank You.

• Any Questions ?