Spanning the Oracle EBS Reporting Spectrum Operational and
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, e. WEEK, 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 Noetix. Views for People. Soft Noetix for Siebel 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1994 Noetix. Views Noetix Platform Noetix Dashboard Noetix Generator for Business. Objects 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 Database Views Application Security
Operational Reporting
BI Content Generation Experts Oracle E-Business Suite Siebel CRM People. Soft Noetix. Views Oracle Discoverer Noetix. Answers Noetix Platform Noetix Analytics Cognos BI Business Objects Oracle Business Intelligence EE
The Information Gap Query, Reporting and Analysis Tools Generic Templates M Ma ap n. Information p u ianl g MRa ep w p io nr g k > < The Gap Custom Application Configuration (v 1) Enterprise Application (v 2) Additional costs 70% of BI Additional implementation resources costs & delay Additional delay
The Information Gap Query, Reporting and Analysis Tools Generic Templates Generated Content < The. Noetix Information Meta. Builder. Gap > Generates configuration specific BI content Custom Application Configuration Enterprise Application (v 2) (v 1) 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 [Oracle EBS upgrade] HZ_PARTIES Flexfield column in the table HZ_CUSTOMERS HZ_CUST_ACCOUNTS ATTRIBUTE 1: “Customer Status” OE_ORDER_HEADERS_ALL Noetix view of the database Your report [remaps view] [doesn’t break] Order Lines Orders ATO Flag Booked Date Customer No. Cust. Status PA_PROJECTS_ALL PA_TASKS OE_ORDER_LINES_ALL MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_TL Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Flexfield column in Order No. the view 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 SEGMENT 1 Company SEGMENT 2 Division SEGMENT 3 Cost Center Descriptive Flexfield Base Table Column Names Descriptive Flexfield View Column Names ATTRIBUTE 1 Web Site ATTRIBUTE 2 Preferred Vendor ATTRIBUTE 3 Approved Until
Noetix. Views 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.
Noetix. Views Global Extension SIRA Inc. Global HR, BEN, PAY, OTL Business Group United States United Kingdom Global GL, FA, FV, AR, AP, Chart of Accounts “A” 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 Web. Query Oracle Discoverer Noetix Dashboard Oracle BI Suite EE Virtual tables End User Layer / Enterprise Information Model Cognos 8 BI Models / Packages Business. Objects Enterprise XI Business. Objects Edge Series Other Third-party BI Tools Universe BI Platform Semantic Layer Repositories and Report Catalogs Noetix Generator Oracle E-Business Suite Noetix. Views 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 Noetix. Views. Guided navigation enables searching by roles, modules, and Oracle configuration
Noetix. Views Coverage
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 Help System Metadata Manager Metadata Layer Data Marts Noetix Generator 100+ Data Sources Integration Interface 2 nd Tier ERP Packaged Analytics Operational Data Store Informatica Power. Center Extraction Views Packaged ETL Oracle E-Business Suite Data Warehouse Reports Cubes Revenue Trends KPIs
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 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 People. Soft 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
- Slides: 32