Transcript Document 7448685

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, eWEEK, 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
NoetixViews for
PeopleSoft
Noetix for Siebel
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
1994
NoetixViews
Noetix Platform
Noetix Dashboard
Noetix Generator
for BusinessObjects
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 Data
Database Views
Application Security
Operational Reporting
BI Content Generation Experts
Oracle E-Business
Suite
Siebel CRM
PeopleSoft
NoetixViews
Oracle Discoverer
NoetixAnswers
Noetix Platform
Noetix Analytics
Cognos BI
Business Objects
Oracle Business
Intelligence EE
The Information Gap
Query, Reporting and Analysis Tools
Generic Templates
Additional costs
M
Ma
ap
nInformation
p
u ianl g MRa ep w
po
iGap
nr g
k >
< The
Custom Application Configuration
(v1)
Enterprise Application (v2)
70%
of BI
Additional
implementation
resources
costs & delay
Additional delay
The Information Gap
Query, Reporting and Analysis Tools
Generic Templates
Generated
Content
< TheNoetix
Information
MetaBuilderGap >
Generates
configuration
specific BI content
Custom Application Configuration
Enterprise Application (v2)
(v1)
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
Flexfield column
in the table
[Oracle EBS upgrade]
HZ_PARTIES
HZ_CUSTOMERS
HZ_CUST_ACCOUNTS
ATTRIBUTE1:
“Customer Status”
OE_ORDER_HEADERS_ALL
PA_PROJECTS_ALL
PA_TASKS
OE_ORDER_LINES_ALL
MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
Noetix view of
the database
Your report
[remaps view]
[doesn’t break]
Order Lines
Orders
ATO Flag
Booked Date
Customer
Customer No.
Cust. Status
Item
Item Desc.
Line Status
Open Quant.
Order No.
Order Quant.
Project
Quantity
Organization
Flexfield column in
Order No.
the view
Customer
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
SEGMENT1
Company
SEGMENT2
Division
SEGMENT3
Cost Center
Descriptive Flexfield
Base Table Column Names
Descriptive Flexfield
View Column Names
ATTRIBUTE1
Web Site
ATTRIBUTE2
Preferred Vendor
ATTRIBUTE3
Approved Until
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.
NoetixViews Global Extension
SIRA Inc.
Global
HR, BEN,
PAY, OTL
Business Group
Business Group
United States
United Kingdom
Global
Chart of Accounts “A”
GL, FA, FV, AR, AP,
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
WebQuery
Oracle
Discoverer
Noetix
Dashboard
Oracle
BI Suite EE
Virtual
tables
End User Layer /
Enterprise
Information Model
Cognos
8 BI
Models /
Packages
BusinessObjects
Enterprise XI
BusinessObjects
Edge Series
Other
Third-party
BI Tools
Universe
BI Platform Semantic Layer Repositories and Report Catalogs
Noetix Generator
Oracle E-Business Suite
NoetixViews
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
NoetixViews.
Guided navigation
enables searching
by roles, modules,
and Oracle
configuration
NoetixViews Coverage
Oracle E-Business Suite 11i & 12.0
Financials
General Ledger
Payables
Receivables
Assets
Procurement
Discrete Manufacturing
Bill of Materials
Work in Process
Inventory
Master Scheduling/MRP
Cost Management
Quality
Purchasing
Order Management
Order Management
Human Resources
Human Resources
Advanced Benefits
Payroll (US, UK, CAN, & AUS legislations)
Time and Labor
EBS Administration
Application Object Library
Finanicals Interface Tables
PeopleSoft Enterprise 8.9
Human Capital Management
Human Resources
Payroll North America
Time and Labor
Process Manufacturing
Product Development
Process Planning
Process Execution
OPM Financials
OPM Inventory
Asset Lifecycle Management
Enterprise Asset Management
Service
TeleService
Install Base
Depot Repair
Field Service
Service Contracts (LA)
Projects
Project Costing
Project Billing
Project Manufacturing
Project Manufacturing (LA)
Grants
Grants Proposal
Grants Accounting
Advanced Planning and Scheduling
Advanced Supply Chain Planning
Industry Verticals
US Federal Financials
Siebel CRM 6.0 - 8.0
Customer Releationship Management
Sales
Service
Call Center
Marketing
Horizontal Applications
Vertical Applications
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
Metadata Layer
Data Marts
Noetix Generator
100+ Data
Sources
Integration Interface
2nd Tier
ERP
Packaged Analytics
Operational
Data Store
Informatica PowerCenter
Extraction Views
Packaged ETL
Oracle
E-Business
Suite
Data
Warehouse
Reports
Cubes
KPIs
Help System
Metadata Manager
Revenue
Trends
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
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
PeopleSoft
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