NCOAUG Training Day

1

• NCOAUG Training Day
• Winter 2002
• Faster, Easier, More Cost-effective Information
  Access
• Presented by Jeff Ray
• Jeff.ray_at_noetix.com

2
About Noetix

• Oracle experts since 1994
• Leaders in providing metadata
• Offices in the US UK
• Resellers worldwide
• Over 1000 customers

3
Customer Base
4
Agenda

• Challenges
• The Noetix Technology Solution
• Product Demonstration

5

• Is your company makingdata driven decisions?
• Or gambling with best-guess
  guidance??

6
Common Statements

• We have mountains of data but we cant access
  it.

• We spend a lot of time at our operations
  meetings arguing about who has the right numbers.

• I dont even make requests for special reports
  anymore well never get them. IT says they
  wont make a custom report because every time the
  application gets upgraded they have to rewrite
  them.

7
Roadblocks to data-driven decisions

• Data locked in complex databases
• Standard reports Not effective
• Custom reports Costly, time consuming
• User creation Complicated, difficult to
  construct
• Query rework App upgrades, changing business
  requirements, delivery methods
• Increasing amounts demand for information

8
How Do You Get Data?

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

9
The Four Step Noetix Solution

• Simplify data access
• Accelerate report development
• Empower decision makers
• Protect reporting investment

10
1 Simplify Data Access

• Automatic set-up constructs custom views based on
  your configurations
• Generates views automatically
• Performs table joins and data mapping
• Complex table joins constructed at install

11
Complex Joins Done for You
Information in one source - easy to recognize
Oracle Tables Relationship Diagram
NoetixViews Relationship Diagram
Purchase_Order_Lines
12
1 Simplify Data Access

• Automatic set-up constructs custom views based on
  your configurations
• Generates views automatically
• Performs table joins and data mapping
• Complex table joins constructed at install
• Translates data into usable information
• Displays Flex Fields List of Values
• Filters irrelevant data

13
Flexfields and List of Values
14
1 Simplify Data Access

• Automatic set-up builds custom views based on
  your configurations
• Generates views automatically
• Performs table joins and data mapping
• Complex table joins constructed at install
• Translates data into usable information
• Displays Flex Fields List of Values
• Filters irrelevant data
• Customizes views to each application
• Rapid deployment
• Auto-detects custom configurations and constructs
  views unique to your application

15
2 Accelerate Report Development

• The Noetix Help System
• Easily report across operations
• Across modules AR to GL
• Across set of books, operating units

16
Broad Content

• See across the entire organization
• Show me the top 10 vendors in volume for our
  entire company
• Let me see margin information across all
  manufacturing operations
• I need to see all the orders that are backlogged
  for the entire company
• Across functional areas between modules
• AR to GL, PO to AP
• Across sets of books
• Across operational units and inventory
  organizations

17
2 Accelerate Report Development

• The Noetix Help System
• Easily report across operations
• Across modules AR to GL
• Across set of books, operating units
• Centrally secure manage queries/access
• One password login
• Flexible Real-time or cached results
• Centralizes user management
• Secures user access to the column or row level

18
3 Empower Decision Makers

• Delivers data to ANY reporting tool
• Easily exports/embeds into MS Excel
• EUL Discoverer other 3rd party tools

19
End User Query Tools
All I need is an End User Query Tool

• Oracle Discoverer
• Brio Query
• Cognos Impromptu
• Crystal Reports
• AND NOW

Noetix Enterprise Technology Solution
20
Purchase Order
21
Purchase Order
22
Querying Oracles Apps using SQL
23
Querying Oracle Apps using Noetix
N_PO_Vendors
24
3 Empower Decision Makers

• Delivers data to ANY reporting tool
• Easily exports/embeds into MS Excel
• EUL Discoverer other 3rd party tools
• Noetix Web-based reporting
• Easy to use, easy to share, access anywhere
• No desktop install
• Quick answers to business questions
• Pre-built query library auto-customized to your
  application
• Easily customize / create their own

25
4 Protect Reporting Investment

• Protect queries against upgrades
• Queries written to views not data source
• Regenerates views at anytime
• Provides layer of abstraction between queries and
  applications

26
Upgrade Protection

• Minimize custom reports maintenance on the next
  upgrade
• Proven track record since release 9.4.2
• Available NOW for 11i
• Preserve the business area views between
  releases same names, same data

27
4 Protect Reporting Investment

• Protect queries against upgrades
• Queries written to views not data source
• Regenerates views at anytime
• Provides layer of abstraction between queries and
  applications
• Deliver one query to many users, devices
• Open Architecture
• Leverage present reporting tools
• MS Excel most popular familiar

28
Open Architecture
Noetix Enterprise Technology Solution
Query Analysis Oracle Discoverer Business
Objects Cognos Impromptu Brio Query Hummingbird/GQ
L

• Complex Analysis
• Power Users
• 10

• One Click Access
• Everybody Else
• 90

NoetixViews
Oracle Applications Data Base
29
Tools to Get Data
AnswerPoint
Data Sources
30
The Noetix Advantage

• Faster, Easier, More Cost-effective Information
  Access
• Rapid Implementation
• Auto-generates configuration-specific views
• Begin reporting in less than a week
• Eases Information Access Challenges
• Simplifies your unique data structures
• Empowers end users to construct own reports
• Cost Effective / High ROI
• Greatly reduces development effort
• Protects queries
• Open Architecture - Use any reporting tool
• Confident Choice

31
NoetixViews Product Availability
11i Compatible

Oracle Applications NoetixViews Oracle
Financials FIN GL, AP, AR, FA Oracle
Manufacturing MFG BOM, MRP, WIP, CST Oracle
SCM SCM PO, OM, INV Oracle
Projects Projects PC, PB Oracle
HRMS HRMS HR Other Tech AOL, Open
Interface Also... Oracle Discoverer End-User
Layer (full support) - Business Areas, Folders,
Items
32

• Faster, Easier, More Cost-effective Information
  Access
• Find Out
  More
• 
  www.noetix.com 1-866-4Noetix