Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Plant Manager Job Desc by pyw13691

VIEWS: 0 PAGES: 32

Plant Manager Job Desc document sample

More Info
									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         NoetixViews for
                      Noetix                                               for Cognos               PeopleSoft
                   EUL Generator
    Noetix
 incorporated                                                Noetix for Siebel


            1995   1996   1997    1998   1999      2000    2001   2002     2003     2004   2005   2006   2007    2008   2009


1994



   NoetixViews                   Noetix Platform          Noetix Dashboard          Noetix Generator            Noetix Generator
                                                                                  for BusinessObjects             for Oracle BI
Noetix Business Intelligence
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
Operational Reporting
BI Content Generation Experts




          Oracle E-Business    NoetixViews       Oracle Discoverer
                Suite
                              NoetixAnswers       Noetix Platform
            Siebel CRM
                              Noetix Analytics      Cognos BI
             PeopleSoft
                                                 Business Objects
                                                 Oracle Business
                                                 Intelligence EE
The Information Gap



      Query, Reporting and Analysis Tools


              Generic Templates
                                            Additional costs
                                            70% of BI
                                             Additional
                        a p p Gap
       < ThepInformation on g >
         Ma ual
         M a n p i n g MR e w i r k         implementation
                                             resources
                                            costs & delay
                                             Additional delay
       Custom Application Configuration


          Enterprise Application (v1)
                                 (v2)
The Information Gap



      Query, Reporting and Analysis Tools


              Generic Templates
              Generated Content

                                            Generates
       < The Information Gap >
            Noetix MetaBuilder              configuration
                                            specific BI content

       Custom Application Configuration
                                            No additional
                                 (v2)
          Enterprise Application (v1)       rework costs or
                                            delay
Information About Your Setup

         Information about your
          enterprise application                   Business Best Practices



                             User
       Configuration                               Financials      Supply Chain
                          Interfaces


                                                    Human
         Flexfields           Security                            Manufacturing
                                                   Resources


               [Interrogated]                              [Handcrafted]



   Generated data



         Business Views                  Reports                Documentation


    [Configuration-specific      [Configuration-specific   [Configuration-specific
            Views]                      Answers]                   Help]
What is a Noetix view?


Oracle database tables                                      Noetix view of        Your report
                                         Flexfield column
                                            in the table
                                                            the database
[Oracle EBS upgrade]                                         [remaps view]       [doesn’t break]

    HZ_PARTIES           HZ_CUSTOMERS
                       HZ_CUST_ACCOUNTS                       Order Lines              Orders
                       ATTRIBUTE1:   “Customer Status”
                                                              ATO Flag
                                                                             Flexfield column in
                                                              Booked Date              Order No.
                                                                                   the view
                  OE_ORDER_HEADERS_ALL                        Customer
                                                                                     Customer
                                                              Customer No.
                                                              Cust. Status         Customer No.
PA_PROJECTS_ALL        OE_ORDER_LINES_ALL                     Item
                                                              Item Desc.            Cust. Status
                                                              Line Status
                                                              Open Quant.          Booked Date
   PA_TASKS            MTL_SYSTEM_ITEMS_B
                                                              Order No.
                                                                                   Order Quant.
                                                              Order Quant.
                                                              Project              Open Quant.
                   MTL_SYSTEM_ITEMS_TL
                                                              Quantity
                                                              Organization          Selling Org.
Oracle Flexfields and Noetix


           Key Flexfield          Key Flexfield
     Base Table Column Names   View Column Names

            SEGMENT1                 Company

            SEGMENT2                 Division

            SEGMENT3                Cost Center




       Descriptive Flexfield   Descriptive Flexfield
     Base Table Column Names   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
                                       Business Group                             Business Group
     HR, BEN,
     PAY, OTL                               United States                         United Kingdom



    Global
                     Chart of Accounts “A”             Chart of Accounts “B”    Chart of Accounts “C”
 GL, FA, FV, AR, AP,
                     Sets of Books/Ledgers             Sets of Books/Ledgers    Sets of Books/Ledgers
PO, OE, PB, PC, GMS     Operating Units                   Operating Units          Operating Units




    Global
                           Master INV                          Master INV            Master INV
INV, BOM, WIP, CST,
                         Organization “X”                    Organization “Y”      Organization “Z”
   MRP, EAM, QA         INV Organizations                   INV Organizations     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              Oracle                                BusinessObjects
    WebQuery           Discoverer                               Enterprise XI      Other
                                              Cognos
                                                                                 Third-party
                                               8 BI
      Noetix             Oracle                                BusinessObjects    BI Tools
    Dashboard          BI Suite EE                               Edge Series

                      End User Layer /
      Virtual                                 Models /                           Other data
                         Enterprise                               Universe
      tables                                  Packages                            models
                     Information Model


                BI Platform Semantic Layer Repositories and Report Catalogs

                                         Noetix Generator
                                     Oracle E-Business Suite




                                           NoetixViews
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                          Discrete Manufacturing          Asset Lifecycle Management
  General Ledger                              Bill of Materials                   Enterprise Asset Management
  Payables                                    Work in Process
  Receivables                                 Inventory                                           Service
  Assets                                      Master Scheduling/MRP               TeleService
                                              Cost Management                     Install Base
                 Procurement                  Quality                             Depot Repair
  Purchasing                                                                      Field Service
                                                      Process Manufacturing       Service Contracts (LA)
           Order Management                   Product Development
  Order Management                            Process Planning                                      Projects
                                              Process Execution                   Project Costing
             Human Resources                  OPM Financials                      Project Billing
  Human Resources                             OPM Inventory
  Advanced Benefits                                                                               Grants
  Payroll (US, UK, CAN, & AUS legislations)            Project Manufacturing      Grants Proposal
  Time and Labor                              Project Manufacturing (LA)          Grants Accounting

             EBS Administration                Advanced Planning and Scheduling              Industry Verticals
  Application Object Library                  Advanced Supply Chain Planning      US Federal Financials
  Finanicals Interface Tables

   PeopleSoft Enterprise 8.9                    Siebel CRM 6.0 - 8.0
       Human Capital Management               Customer Releationship Management
  Human Resources                             Sales
  Payroll North America                       Service
  Time and Labor                              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                                                                              Discrete
                   Profitability     Projects           Sales            ASCP
    Capital                                                                                MFG


      Cash                            Project
                     Daily Net                                       Full Pegging by
   Conversion                       Commitment         Backlog                          BOM Costing
                     Revenue                                           MSC Plans
     Cycle                            Details

                                                                       Exception
                    Margins by                       Cost of Sales
   Days Sales                       Expenditure                      Demand/Suppl       Make Items
                    Customer,                        by Customer,
   Outstanding                        Details                            ies by         with no BOM
                   Product, Rep                      Product, Rep
                                                                       Resource

                                                                       Exception
                                       Project                                          Order Items
  Days Inventory      Projects                         On-time       Demand/Suppl
                                      Revenue                                             with no
   Outstanding       Revenues                        Performance         ies by
                                       Details                                         Associated Job
                                                                       Customer

                                                                       MFG BOM
      Days                          Cost Center                                          Component
                     Projects                       Net Bookings &     Operation
   Purchasing                       Distribution                                           Usage -
                   Expenditures                      Net Change      Sequences by
   Outstanding                         Lines                                           History, Trends
                                                                      MSC Plans

      Open           Operating                                        PO Lines by      Quantity Built
                                    Job Bill Rate    Debookings/
   Receivables     Income as %                                        Implement         vs. Quantity
                                     Overrides       Rebookings
   & Payables         of Sales                                           Task             Ordered

                                                                       MFG BOM            Material
     Spend by                        Cost Center      Projected
                    Gross Profit                                       Operation        Transactions
    Period and                      Organization      COGS Per
                   (Contribution)                                    Sequences by        By Plant to
      Vendor                        Relationships       Order
                                                                       Customer             Ship
Noetix Analytics Architecture



                                                                           Data                                                   Packaged Analytics


                         Packaged ETL
                                                                           Warehouse
  Oracle
  E-Business                                                                Operational                                           Dashboards
  Suite                                                                     Data Store
      Extraction Views
                                                 Informatica PowerCenter




                                                                                              Noetix Generator


                                                                                                                 Metadata Layer
                                                                                                                                                       Reports
                                                                             Data Marts
                                                                                                                                   Cubes
                         Integration Interface




 2nd Tier
 ERP

                                                                           Metadata
                                                                           Repository
                                                                                                                                                       KPIs
  100+ Data                                                                                                                        Revenue
  Sources                                                                     Help System
                                                                                                                                   Trends
                                                                           Metadata Manager
Product Demonstration
   Noetix Analytics
Noetix Functional Coverage
Noetix Business Intelligence
Reporting across the BI spectrum

       BI APPLICATIONS


         Packaged                          Packaged
         Reports                                                                      Drillable
                          Answers          Analytics    Dashboards         KPIs
                                                                                      Reports

      BI PLATFORMS


                            Noetix for                                                  Business
            Noetix                          Oracle BI     Discoverer       Cognos
                             Excel                                                       Objects



                                             METADATA GENERATORS

       ENTERPRISE BI MODELS

        OLTP                                      Data Warehouse
                                Database                               Operational
                                                                                      Data Marts
                                 Views                                 Data Store




                                    METADATA SERVICES & DATA INTEGRATION

        ENTERPRISE APPLICATIONS



             E-Business                                                               QAD
                              PeopleSoft      Siebel       Legacy      JD Edwards
                Suite                                                                MFG/PRO
Noetix Business Intelligence
Supports Noetix Core Values



     Rapid           Open
                                    Configuration
 Implementation   Architecture
                                      Specific

     P               P                  P

                                 Bringing Data Into View

                                                                 Metadata   Lowest
                                                    Extensible
                                                                  Driven     TCO


                                                      P           P          P

								
To top