Spreading over the Oracle EBS Reporting Spectrum Operational and Analytical Reporting

1483 days ago, 602 views
PowerPoint PPT Presentation
Traversing the Prophet EBS Reporting Range Operational and Expository Reporting. Joe Dahl

Presentation Transcript

Slide 1

Spreading over the Oracle EBS Reporting Spectrum Operational and Analytical Reporting Joe Dahl – Product Specialist

Slide 2

About Noetix BI arrangements specialists since 1994 Offices in North America, Europe and South Asia Certified with all driving BI Platforms Recent Product Awards: KMWorld, eWEEK, DMReview 1400+ clients all around PARTNERSHIPS

Slide 3

Noetix's History of Dedication to Oracle Applications Reporting Noetix Analytics Noetix Generator for Cognos NoetixViews for PeopleSoft Noetix EUL Generator Noetix consolidated 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 Generator for Oracle BI

Slide 4

Noetix Business Intelligence

Slide 5

Noetix Supports the Full Spectrum of Reporting Needs Enterprise Models Strategic Common Dimensions Performance Management Packaged ETL broad Data Integration Analytics/KPIs Near Real-time Operational Reports Summarized Data Ad hoc inquiry Historical Trending Real-time Drillable Reports Detailed Data Database V iews Application Security

Slide 6

Operational Reporting

Slide 7

BI Content Generation Experts

Slide 8

The Information Gap Query, Reporting and Analysis Tools Generic Templates Additional costs Additional assets Additional postpone 70% of BI execution costs & defer M a n u a l M a p i n g M a p i n g R e w o r k < The Information Gap > Custom Application Configuration Enterprise Application (v1) Enterprise Application (v2)

Slide 9

Generated Content Custom Application Configuration The Information Gap Query, Reporting and Analysis Tools Generic Templates Generates design particular BI content Noetix MetaBuilder < The Information Gap > Custom Application Configuration No extra modify expenses or postpone Enterprise Application (v2) Enterprise Application (v1)

Slide 10

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

Slide 11

Your report Noetix perspective of the database HZ_PARTIES HZ_CUST_ACCOUNTS HZ_CUSTOMERS Order Lines Orders ATO Flag Booked Date Customer No. Thing Item Desc. Line Status Open Quant. Arrange No. Arrange Quant. Extend Quantity Organization Order No. OE_ORDER_HEADERS_ALL Customer No. OE_ORDER_LINES_ALL PA_PROJECTS_ALL OE_ORDER_LINES_ALL Cust. Status Booked Date PA_TASKS MTL_SYSTEM_ITEMS_B Order Quant. Open Quant. MTL_SYSTEM_ITEMS_TL Selling Org. What is a Noetix see? Prophet database tables Flexfield segment in the table [Oracle EBS upgrade] [doesn't break] [remaps view] ATTRIBUTE1 : "Client Status" Flexfield section in the view Cust. Status

Slide 12

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

Slide 13

NoetixViews Help File Noetix bunches sees by useful range into parts. An arrangement of parts are made for every business aggregate, arrangement of books and working unit for every module where relevant. The initial 3-5 characters in a part name, or part "prefix", is characterized by the client at introduce time.

Slide 14

Chart of Accounts "C" Sets of Books/Ledgers Operating Units Chart of Accounts "A" Sets of Books/Ledgers Operating Units Chart of Accounts "B" Sets of Books/Ledgers Operating 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 INV, BOM, WIP, CST, MRP, EAM, QA NoetixViews Global Extension Also Global: ASCP, Service & OPM Suites

Slide 15

Global Security Row-level security EBS information get to benefits of the client Manual & programmed setup Applications Data is secured Organizational availability Application-particular security is authorized MOAC (Multi Org Access Control) upheld Custom line level security choice, as required

Slide 16

Noetix Generator

Slide 17

How BI Tools Ship – No Content

Slide 18

Noetix use existing EBS and BI stage ventures Noetix WebQuery Noetix Dashboard Universe Other information models End User Layer/Enterprise Information Model Models/Packages BI Platform Semantic Layer Repositories and Report Catalogs Noetix Generator Oracle E-Business Suite Oracle Discoverer Oracle BI Suite EE Other Third-party BI Tools Cognos 8 BI BusinessObjects Enterprise XI BusinessObjects Edge Series Virtual tables NoetixViews

Slide 19

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

Slide 20

Noetix Search Key Benefits Powerful Search Capability for Report Developers Familiar UI Easily locate the privilege view(s) for questions & reports Reporting Objects Cross-Referenced List all perspectives by section List all Oracle tables by view List all segments by Oracle table by view List all perspectives by Oracle table Print/Save PDF Files of Views/Columns/Tables Detail 360 Degree View of Your Views!

Slide 21

Bringing Search to Noetix Reporting Filter seek by view names, see section names, table names and table segment names. Look over various occurrences of NoetixViews. Guided route empowers seeking by parts, modules, and Oracle arrangement

Slide 22

NoetixViews Coverage

Slide 23

Analytical Reporting

Slide 24

BI Challenges Achieve business announcing and information examination necessities Minimize or dispose of effect on the creation exchange database (OLTP) Improve inquiry execution Capture short lived or verifiable information that no longer dwells in the OLTP database Integrate information from different divergent databases

Slide 25

Noetix Analytics "Bundled" branch of knowledge information models in star diagram information shops Conformed measurements and measurement progressive systems Snapshot information for history and inclining Detailed information for full bore in Operational Data Store Pre-manufactured ETL mappings from Oracle EBS Complex changes into information bazaars Change Data Capture for incremental invigorate Integration interface to coordinate legacy information Extensibility structure for customizations Pre-characterized execution measures (KPIs), dashboards and reports AP/AR Aging, Working Capital Management, Net Bookings, Profitability Analysis, Vendor Performance & Quality, Headcount & Turnover Analysis Active metadata archive with organization apparatuses Generators for mix with BI Platforms

Slide 26

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/Supplies by Resource Make Items with no BOM Days Inventory Outstanding Projects Revenues Project Revenue Details On-time Performance 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 Days Purchasing Outstanding Open Receivables & Payables Operating Income as % of Sales Job Bill Rate Overrides Debookings/Rebookings PO Lines by Implement Task Quantity Built versus Amount 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

Slide 27

Noetix Analytics Architecture Oracle E-Business Suite Operational Data Store Extraction Views Data Marts 2 nd Tier ERP 100+ Data Sources Help System Metadata Manager Data Warehouse Packaged ETL Informatica PowerCenter Noetix Generator Metadata Layer Packaged Analytics Dashboards Reports Integration Interface Cubes Metadata Repository KPIs Revenue Trends

Slide 28

Product Demonstration Noetix Analytics

Slide 29

Noetix Functional Coverage

Slide 30

Noetix Business Intelligence Reporting over the BI range 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 Data Warehouse Database Views Operational Data Store Data Marts METADATA SERVICES & DATA INTEGRATION ENTERPRISE APPLICATIONS E-Business Suite PeopleSoft Siebel Legacy JD Edwards QAD MFG/PRO

Slide 31

Noetix Business Intelligence

Slide 32

Supports Noetix Core Values Open Architecture Configuration Specific Rapid Implementation P Bringing Data Into View Metadata Driven Extensible Lowest TCO P