Go to primary content

Oracle® Product Lifecycle Analytics Multi-Dimensional Schema Data Reference Manual Release 3.6 E84200-01 |
| Contents

Previous | Next |

# 1 Introduction

## Introduction

The Data Reference Manual (DRM) describes the data model entities of the Published Model of Oracle Product Lifecycle Analytics Multi-Dimensional Schema (MDS). The schema reference tables are documented across DRM Volume 1 and DRM Volume 2 in release 3.3.1.1.

Intended users of this document are advanced database developers who extend and customize the MDS data model to build custom solutions based on the prepackaged dashboards and reports within the Oracle Product Lifecycle Analytics application.

Note: The schema reference provided with the product may change in future releases. Any customized solution provided on the basis of this reference manual is not supported and you may need to make appropriate changes in future releases.

### Acronyms

Table 1-1 Acronyms used in this manual

Acronym | Expansion
--- | ---
BI | Business Intelligence
CAPA | Corrective and Preventive Action
DB | Data Base
DEV | Deviations
ECO | Engineering Change Order
ECR | Engineering Change Request
ETL | Extract-Transform-Load
FK | Foreign Key
MCO | Manufacturing Change Order
MDS | Multi-Dimensional Schema
NCR | Non-Conformance Report
OBIEE | Oracle Business Intelligence Enterprise Edition
ODI | Oracle Data Integrator
PC | Product Collaboration
PLM | Product Lifecycle Management
PPM | Product Portfolio Management
PQM | Product Quality Management
PR | Problem Report
PSR | Problem Service Request
SS | Stop Ship

### What's New in Oracle Product Lifecycle Analytics 3.3.1.0.0

New tables (PC_ECO_CUM_%) have been added to aggregate fact tables in ECO area at fiscal week, month, quarter, and year levels.

New dimension tables (W_WEEK_D, W_MONTH_D, W_QTR_D,W_YEAR_D) have been added to store calendar data for report calculations.

The following columns have been added into existing tables:

Table 1-2 New tables in OPLA 3.3.1.0.0

Table Name | New Column
--- | ---
PC_ECO_F | NEW_FLG NUMBER(1)
ETL_PARAMETER | ECO_WKLY_AGGR_SINCE DATE