1 / 32

Spanning the Oracle EBS Reporting Spectrum Operational and Analytical Reporting

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

kordell
Download Presentation

Spanning the Oracle EBS Reporting Spectrum Operational and Analytical Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spanning the Oracle EBS Reporting SpectrumOperational 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. Noetix’s 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 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 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 Enterprise Models Strategic Common Dimensions Performance Management Packaged ETL Enterprise-wide Data Integration Analytics / KPIs Near Real-time Operational Reports Summarized Data Ad hoc query Historical Trending Real-time Drillable Reports Detailed Data Database Views Application Security

  6. Operational Reporting

  7. BI Content Generation Experts

  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 < The Information Gap > Custom Application Configuration Enterprise Application (v1) Enterprise Application (v2)

  9. Generated Content Custom Application Configuration The Information Gap Query, Reporting and Analysis Tools Generic Templates Generates configuration specific BI content Noetix MetaBuilder < The Information Gap > Custom Application Configuration No additional rework costs or delay Enterprise Application (v2) Enterprise Application (v1)

  10. Information about your enterprise application Business Best Practices Financials Supply Chain Configuration User Interfaces Human Resources Manufacturing Flexfields Security [Interrogated] [Handcrafted] Generated data Business Views Reports Documentation [Configuration-specific Views] [Configuration-specific Answers] [Configuration-specific Help] Information About Your Setup

  11. Your report Noetix view of the database HZ_PARTIES HZ_CUST_ACCOUNTS HZ_CUSTOMERS Order Lines Orders ATO Flag Booked Date Customer Customer No. Item Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Order No. OE_ORDER_HEADERS_ALL Customer Customer No. OE_ORDER_LINES_ALL PA_PROJECTS_ALL OE_ORDER_LINES_ALL Cust. Status Booked Date PA_TASKS PA_TASKS MTL_SYSTEM_ITEMS_B Order Quant. Open Quant. MTL_SYSTEM_ITEMS_TL Selling Org. What is a Noetix view? Oracle database tables Flexfield column in the table [Oracle EBS upgrade] [doesn’t 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. Chart of Accounts “C”Sets of Books/LedgersOperating Units Chart of Accounts “A”Sets of Books/LedgersOperating Units Chart of Accounts “B”Sets of Books/LedgersOperating Units Master INV Organization “X” INV Organizations Master INV Organization “Y” INV Organizations Master INV Organization “Z”INV Organizations SIRA Inc. Business Group Business Group HR, BEN, PAY, OTL United States United Kingdom GL, FA, FV, AR, AP, PO, OE, PB, PC, GMS Global Global Global INV, BOM, WIP, CST, MRP, EAM, QA NoetixViews Global Extension Also Global: ASCP, Service & OPM Suites

  15. 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

  16. Noetix Generator

  17. How BI Tools Ship – No Content

  18. Noetix leverages existing EBS and BI platform investments NoetixWebQuery Noetix Dashboard Universe Other data models End User Layer / EnterpriseInformation Model Models /Packages BI Platform Semantic Layer Repositories and Report Catalogs Noetix Generator Oracle E-Business Suite OracleDiscoverer OracleBI Suite EE OtherThird-partyBITools Cognos8 BI BusinessObjects Enterprise XI BusinessObjects Edge Series Virtualtables NoetixViews

  19. Noetix Provides a Reporting Application With Any Front End Tool NOETIX HELP FILE OBI EE COGNOS DISCOVERER

  20. 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!

  21. 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

  22. NoetixViews Coverage

  23. Analytical Reporting

  24. 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

  25. 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

  26. Sample Noetix Analytics Subject Areas Working Capital Profitability Projects Sales ASCP Discrete MFG Cash ConversionCycle Daily NetRevenue Project Commitment Details Backlog Full Pegging by MSC Plans BOM Costing Days SalesOutstanding Margins byCustomer, Product, Rep Expenditure Details Cost of Sales by Customer, Product, Rep Exception Demand/Supplies by Resource Make Items with no BOM Days InventoryOutstanding ProjectsRevenues Project Revenue Details On-timePerformance Exception Demand/Supplies by Customer Order Items with no Associated Job Projects Expenditures Cost Center Distribution Lines Net Bookings & Net Change MFG BOM Operation Sequences by MSC Plans Component Usage - History, Trends DaysPurchasingOutstanding OpenReceivables& 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

  27. Noetix Analytics Architecture OracleE-BusinessSuite OperationalData Store Extraction Views Data Marts 2nd Tier ERP 100+ DataSources Help System Metadata Manager DataWarehouse Packaged ETL Informatica PowerCenter Noetix Generator Metadata Layer Packaged Analytics Dashboards Reports Integration Interface Cubes MetadataRepository KPIs Revenue Trends

  28. Product DemonstrationNoetix Analytics

  29. Noetix Functional Coverage

  30. Noetix Business IntelligenceReporting 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 BusinessObjects 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

  31. Noetix Business Intelligence

  32. Supports Noetix Core Values OpenArchitecture Configuration Specific RapidImplementation P P P Bringing Data Into View Metadata Driven Extensible Lowest TCO P P P

More Related