1 Overview of Oracle Product Lifecycle Analytics

Oracle Product Lifecycle Analytics (OPLA) is a comprehensive, pre-built Business Intelligence solution that delivers pervasive intelligence and provides key insights into your Product Lifecycle Management (PLM) data. The Oracle Product Lifecycle Analytics Application provides an integrated view of the product to enable greater alignment of information across product organizations. It is built on Oracle Data Integrator (ODI) ETL and Oracle Business Intelligence Enterprise Edition (OBIEE) platforms.

1.1 Introduction

OPLA addresses the business use cases specific to Product Quality Management (PQM), Product Collaboration (PC), and Product Portfolio Management (PPM), Agile PLM for Process: New Product Development (NPD) and Global Specification Management (GSM).

OPLA provides you with the ability to use different source systems. Data is transferred from the source systems to the OPLA target analytical data store. In OPLA, the transactional data sources are either Agile PLM 9.x or Agile PLM for Process.

1.2 Oracle Product Lifecycle Analytics Architecture

OPLA is designed and developed using a layered Data Warehouse and OLAP architecture on Oracle enterprise technologies. At the bottom of the stack is the Agile PLM OLTP Agile PLM for Process OLTP database which is optimized for core transactions. The database is the source data system for OPLA, but it can be extended to load data from other data sources.

Layer 2 includes the ODI and PL/SQL ETL tasks for extracting data, including metadata, from the Agile PLM source system and loads it into the Staging Schema (Layer 3). Layer 4 provides ETL tasks using ODI and PL/SQL for extracting data from the operational data store, then transforms, aggregates, and loads data to the pre-defined multi-dimensional schema in Layer 5. MDS as a set of star schemas that were designed based on top-down business analytical requirements. Layer 6 provides the pre-built analytical repository for OBIEE and its metadata repository. Layer 7 has the pre-built roles-based and functional dashboards with a pre-defined set of reports and KPIs along with alerts and guided navigation for providing actionable insights into PLM data.

Oracle Product Lifecycle Analytics with Agile PLM

Oracle Product Lifecycle Analytics with Agile PLM for Process