migrating to obi ee? a simplified strategy for oracle e...
TRANSCRIPT
Migrating to OBI EE?
A Simplified Strategy for Oracle E- Business Suite & Discoverer
Users
Daryl Orts, VP Engineering [email protected]
Agenda
• Introduction• Overview of Oracle BI Suite EE Plus• Integrating OBI EE with Oracle EBS• Product Demonstration• Migrating from Oracle Discoverer to OBI EE• Summary• Q & A
About Noetix• Oracle BI solution experts since 1994• Offices in North America, Europe and South Asia• Certified with all leading BI Platforms• 2007 Product Awards: KMWorld, eWEEK,
DMReview• 1400+ customers globally
PARTNERSHIPS
Oracle Certified Advantage Partner
Reporting Requirements Change Over TimeRelationship Over 14 Years
Co-developed EUL Generator for Discoverer
Noetix integration — Oracle on Demand
Noetix / Oracle PeopleSoft Agreement
Launch of NoetixViews for Oracle E-Business Suite
Noetix/Oracle BI Suite EE Migration Services
Release 12 and Fusion Plans
1994
Generator for OBI EE
Oracle BI Server
A highly scalable, highly efficient query and analysis server that integrates data via sophisticated query federation capabilities from multiple relational, unstructured, OLAP, and pre-packaged application sources
Oracle BI Server
A highly scalable, highly efficient query and analysis server that integrates data via sophisticated query federation capabilities from multiple relational, unstructured, OLAP, and pre-packaged application sources
Oracle BI Answers
A powerful ad-hoc query and analysis tool that works against a logical view of information from multiple data sources in a pure Web environment
Oracle BI Answers
A powerful ad-hoc query and analysis tool that works against a logical view of information from multiple data sources in a pure Web environment
Oracle BI Interactive Dashboard
Rich, interactive pure Web dashboards that display personalized information to help guide users in effective decision making
Oracle BI Interactive Dashboard
Rich, interactive pure Web dashboards that display personalized information to help guide users in effective decision making
Oracle BI Publisher
A highly scalable reporting engine capable of generating reports from multiple data sources in multiple formats via multiple delivery channels
Oracle BI Publisher
A highly scalable reporting engine capable of generating reports from multiple data sources in multiple formats via multiple delivery channels
NOT INCLUDED
OBI EE Plus does NOT include Oracle’s BI Applications.
Those are separate products, with separate pricing and additional implementation costs.
NOT INCLUDED
OBI EE Plus does NOT include Oracle’s BI Applications.
Those are separate products, with separate pricing and additional implementation costs.
© Oracle Corporation
Data Warehouse, Data MartOLTP RDBMS
Operational Tactical Strategic
Present dayWhat is happening now ?Live transactional reporting
History and short to medium termAd hoc reporting, Why ?Management & statutory reporting
Long termWhat will happen ?KPIs, Long term plansScorecards,Dashboards
Oracle BI Suite EE PlusOracle Discoverer
Meeting Reporting Needs with Oracle
Federated Data Sources
OBIEEDashboardsAnswersBI Publisher
Direct access
to source data
Data Warehouse
ETL
EDW People Soft
Oracle Siebel SAP Other
Direct Access
to Source
Data
Oracle EBS
NoetixViewsfor Oracle
Operationaland Tactical
reporting
Tactical and Strategic reporting
KEY POINT: You don’t have to wait until you build a data warehouse to get reporting value from OBI EE
Oracle BI Suite EE Plus and Noetix
MTL_SYSTEM_ITEMS
HZ_CUSTOMERS
OE_ORDER_LINES_ALL
OE_ORDER_HEADERS_ALL
MTL_SYSTEM_ITEMS_TL
PA_PROJECTS_ALL
PA_TASKS
How Noetix views workOracle database tables Noetix view of
the database
Order Lines
ATO FlagBooked DateCustomerCustomer No.ItemItem Desc.Line StatusOpen Quant.Order No.Order Quant.ProjectQuantityOrganization
− Ad hoc query− Report
− Extraction
Customer
Selling Org.
Customer No.
Open Quant.
Order Quant.
Booked Date
Order No.
Orders
MTL_SYSTEM_ITEMS
OE_ORDER_HEADERS_ALL
MTL_SYSTEM_ITEMS_TL
PA_PROJECTS_ALL
How reports are protected during upgrades
Oracle changes the database... Noetix remaps the view…
Order Lines
ATO FlagBooked DateCustomerCustomer No.ItemItem Desc.Line StatusOpen Quant.Order No.Order Quant.ProjectQuantityOrganization
Report doesn’t break
Customer
Selling Org.
Customer No.
Open Quant.
Order Quant.
Booked Date
Order No.
OrdersHZ_CUST_ACCOUNTS
OE_ORDER_LINES_ALL
HZ_PARTIES
PA_TASKS
NoetixViews translates Oracle flexfields
Key Flexfield Base Table Column Names
SEGMENT1
SEGMENT2
SEGMENT3
Company
Division
Cost Center
Key Flexfield View Column Names
Descriptive Flexfield Base Table Column Names
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
WWW Site
Preferred Vendor
Approved Until
Descriptive Flexfield View Column Names
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.
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. The first 3-5 characters in a role name, or role
“prefix”, is defined by the customer at install time.
NoetixViews Functional CoverageFinancials Discrete Manufacturing Enterprise Asset Management
General Ledger Bill of Materials Enterprise Asset Management Payables Work in Process Receivables Inventory Service Assets Master Scheduling/MRP TeleService Financials Interface Tables Cost Management Install Base
Depot RepairProcurement Process Manufacturing Field Service
Purchasing Product Development Product Planning Projects
Order Management Product Execution Project Costing Order Management OPM Financials Project Billing
OPM InventoryHuman Resources Grants
Human Resources Project Manufacturing Grants Proposal Advanced Benefits Project Manufacturing Grants Accounting Payroll - US Legislation Payroll - Canadian Legislation Advanced Supply Chain Planning EBS Administration Payroll - Australian Legislation Advanced Supply Chain Planning Application Object Library Payroll - UK Legislation
Noetix Generator for Oracle Discoverer
Oracle E-Business Suite
NoetixViewsOracle
Discoverer EUL
Generate business areas
Generate folders
Populate folders
Noetix Generator for OBI EE
Oracle E-Business Suite
NoetixViews
Oracle BI Server Oracle
BI Server
Generate object definitions
Export UDML
Convert UDML to RPD
UDMLUDML
RPD(Repository
Model)
RPD(Repository
Model)
Convert Discoverer “Model” to OBI EE
Discoverer EUL
Oracle Business IntelligenceEnterprise Edition
Oracle EOracle E--Business SuiteBusiness Suite
Oracle BI Presentation Catalog
Oracle BI Server
Oracle Presentation Services
Answers
Oracle BI RepositoryEnterprise Semantic Model
Presentation LayerSemantic Object LayerPhysical Layer
Discoverer Server
DiscovererWorkbooks
Convert EUL to Repository Model for
OBI EE
Oracle EBS Tables
Converter for OBI EE
Oracle plans to deliver an EUL conversion utility
Oracle plans to deliver an EUL conversion utility
Oracle EBS Tables
Convert Discoverer Workbooks to OBIEE Answers
Oracle EOracle E--Business SuiteBusiness Suite
Workbook Conversion
Discoverer EUL
NoetixViews
Oracle Business IntelligenceEnterprise Edition
Oracle BI Presentation Catalog
Oracle BI Server
Oracle Presentation Services
Answers
Oracle BI RepositoryEnterprise Semantic Model
Presentation LayerSemantic Object LayerPhysical Layer
Noetix offers tools and services to perform this conversion.
Noetix offers tools and services to perform this conversion.
DiscovererWorkbooks
Discoverer Server
Summary
• OBI EE provides a powerful BI platform• You don’t need a data warehouse to use it• You can gain immediate benefit by connecting to
transaction systems– Get results before creating a data warehouse – Noetix enables that “faster time to value”
• Noetix can migrate your Discoverer reporting environment to OBI EE