Spanning the Oracle EBS Reporting Spectrum Operational and Analytical Reporting

1
Spanning the Oracle EBS Reporting Spectrum
Operational and Analytical Reporting
Joe Dahl Product Specialist
2
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, eWEEK, DMReview
• 1400 customers globally

PARTNERSHIPS
3
Noetixs History of Dedication to Oracle
Applications Reporting
Noetix Analytics
Noetix Generator for Cognos
NoetixViews for PeopleSoft
Noetix EUL Generator
Noetix incorporated
Noetix for Siebel
1995
1996
1998
1999
2000
2001
2003
2004
2005
2006
2007
2002
1997
2009
2008
1994
Noetix Platform
Noetix Generator for BusinessObjects
Noetix Dashboard
NoetixViews
Noetix Generatorfor Oracle BI
4
Noetix Business Intelligence
5
Noetix Supports the Full Spectrum of Reporting
Needs
6
Operational Reporting
7
BI Content Generation Experts
NoetixViews NoetixAnswers Noetix Analytics
Oracle E-Business Suite Siebel CRM PeopleSoft
Oracle Discoverer Noetix Platform Cognos BI Business Objects Oracle Business Intelligence EE
8
The Information Gap
Query, Reporting and Analysis Tools
Generic Templates
Additional costs Additional resources Additional
delay
70 of BI implementation costs delay
M a n u a l M a p p i n g
M a p p i n g R e w o r k
lt The Information Gap gt
Custom Application Configuration
Enterprise Application (v1)
Enterprise Application (v2)
9
The Information Gap
Query, Reporting and Analysis Tools
Generic Templates
Generates configuration specific BI content
Noetix MetaBuilder
lt The Information Gap gt
Custom Application Configuration
No additional rework costs or delay
Enterprise Application (v1)
Enterprise Application (v2)
10
Information About Your Setup
11
What is a Noetix view?
Oracle database tables
Flexfield column in the table
Oracle EBS upgrade
doesnt break
remaps view
ATTRIBUTE1 Customer Status
Flexfield column in the view
Cust. Status
12
Oracle Flexfields and Noetix
Key FlexfieldBase Table Column Names
Key FlexfieldView Column Names
SEGMENT1
Company
SEGMENT2
Division
SEGMENT3
Cost Center
Descriptive FlexfieldBase Table Column Names
Descriptive FlexfieldView Column Names
ATTRIBUTE1
Web Site
ATTRIBUTE2
Preferred Vendor
ATTRIBUTE3
Approved Until
13
NoetixViews 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.
14
Immediate Answers to Questions

• Automatically generates more than 900 reports
  custom to your Oracle implementations
• Provides end users with immediate answers to
  common business questions

Financials
Which accounts receivable invoices are due this
month and next month?
Supply Chain
What are the on-hand quantities for the
components of a bill of material?
Human Resources
What is the wage or salary history for a specific
employee or group of employees?
Manufacturing
What is the average price difference between a
purchase order and stored cost?
15
NoetixViews Global Extension
Also Global ASCP, Service OPM Suites
16
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

17
Noetix Generator
18
How BI Tools Ship No Content
19
Noetix leverages existing EBS and BI platform
investments
Cognos8 BI
OtherThird-partyBI Tools
OracleDiscoverer OracleBI Suite EE
BusinessObjects Enterprise XI BusinessObjects
Edge Series
Virtualtables
NoetixViews
20
Noetix Provides a Reporting Application With Any
Front End Tool
21
Noetix Platform
Siebel
NoetixViews Oracle ERP
PeopleSoft
Legacy
Other ERP or CRM
DM/DW
22
Noetix SearchA 360 View of Your Reporting
Environment
23
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!

24
Bringing Search to Noetix Reporting
Filter search by view names, view column names,
table names and table column names.
Search across multiple instances of NoetixViews.
Guided navigation enables searching by roles,
modules, and Oracle configuration
25
NoetixViews Coverage
26
Analytical Reporting
27
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

28
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

29
Sample Noetix Analytics Subject Areas
Working Capital
Projects
Sales
ASCP
Discrete MFG
Profitability
Cash ConversionCycle
Project Commitment Details
Backlog
Full Pegging by MSC Plans
BOM Costing
Daily NetRevenue
Days SalesOutstanding
Expenditure Details
Cost of Sales by Customer, Product, Rep
Exception Demand/Supplies by Resource
Make Items with no BOM
Margins byCustomer, Product, Rep
Days InventoryOutstanding
Project Revenue Details
On-timePerformance
Exception Demand/Supplies by Customer
Order Items with no Associated Job
ProjectsRevenues
DaysPurchasingOutstanding
Cost Center Distribution Lines
Net Bookings Net Change
MFG BOM Operation Sequences by MSC Plans
Component Usage - History, Trends
Projects Expenditures
OpenReceivables Payables
Debookings/Rebookings
PO Lines by Implement Task
Quantity Built vs. Quantity Ordered
Operating Income as of Sales
Job Bill Rate Overrides
Spend by Period and Vendor
MFG BOM Operation Sequences by Customer
Gross Profit (Contribution)
Cost Center Organization Relationships
Projected COGS Per Order
Material Transactions By Plant to Ship
30
Noetix Analytics Architecture
DataWarehouse
Packaged Analytics
Packaged ETL
Informatica PowerCenter
Noetix Generator
Metadata Layer
Dashboards
Reports
Integration Interface
Cubes
MetadataRepository
KPIs
Revenue Trends
31
Noetix Analytics Operational Data Store

• Reference Tables
• Lookup tables such as country codes, terms codes,
  etc.
• Master Tables
• Customers, products, sales reps, etc.
• Detail Tables
• Order lines, invoice lines, journal entries, AP
  invoices, etc.

Master Data
Master Data
Transaction Tables
Transaction Tables
Master Data
Master Data
Hybrid Star Schema
- Tactical, Near Real Time -
32
Operational Data Store Configurable Refresh
Functional Groups
Extraction, Transformation, Loading
AP 1 hr
Order Types
CountryCodes
OM 10 min.
Customer
OrderLines
Item
Order Headers
Oracle Applications
Operating Unit
Sales Rep
Rest Nightly
Operational Data Store
- Operational data, dimensionalized, near real
time -
33
Noetix Analytics Data Marts to answer
specific business questions
Dimensions
Dimensions
Customer
Date
Facts

• Analysis
• Slice and Dice
• Trending
• Out of the Box KPIs
• Spend by Period and Vendor
• Days Sales Outstanding
• Cost of Goods Sold
• Inventory Turns
• On-time Performance
• Open Sales Order Aging
• Projects Expenditures
• Margins by Customer, Product, Rep
• Daily Net Revenue

Orders Detail Fact
Orders Detail Fact
Orders Detail Fact
Orders Details
Product
Sales Rep
Operating Unit
Set of Books
Exclusively Star Schema
34
Noetix BI Value Propositions
Packaged Analytics

• Rapid Implementation
• Open Architecture
• EBS centric
• Extensible
• Metadata Driven
• Upgrade Protection
• Lowest TCO

Financials Human ResourcesProjects Procurement
Discrete Manufacturing Order ManagementProcess
Manufacturing Service and ContractsInventory Ince
ntive CompensationWorking Capital
METADATA LAYER
Data Warehouse
OperationalData Store
Data Marts
Enterprise Applications
E-Business Suite LegacyPeopleSoft JD
EdwardsSiebel QAD MFG/Pro
35
Nature of Solution End Goal
36
Product DemonstrationNoetix Analytics
37
Noetix Functional Coverage
38
Noetix Business IntelligenceReporting across the
BI spectrum
BI APPLICATIONS
Packaged Reports
Packaged Analytics
Dashboards
KPIs
Drillable Reports
Answers
BI PLATFORMS
Noetix
Oracle BI
Discoverer
Cognos
BusinessObjects
Noetix for Excel
METADATA GENERATORS
ENTERPRISE BI MODELS
OLTP
Data Warehouse
Database Views
OperationalData Store
Data Marts
METADATA SERVICES DATA INTEGRATION
ENTERPRISE APPLICATIONS
E-Business Suite
PeopleSoft
Siebel
Legacy
JD Edwards
QAD MFG/PRO
39
Noetix Business Intelligence
40
Supports Noetix Core Values
OpenArchitecture
Configuration Specific
RapidImplementation
P
P
P
Bringing Data Into View
Metadata Driven
Lowest TCO
Extensible
P
P
P