About Star Field Mappings

Previous TopicNext TopicContents

The Star schema consists of data pulled from the P6 EPPM Extended view schema. Other data is calculated as part of the Transformation process. Calculated data includes: historical captures, hierarchies, and burndown and work planning calculations.

If you would like to see how the Extended schema fields are mapped, look in the ETL_MAPPING table. Choose what your source schema version is (for example: P6 EPPM 8.3 = 83).

select * from etl_mapping where source_version = 83;

From here you can view how these fields are directly mapped to the staging tables (for example: W_PROJECT_DS). These fields would map similarly to the corresponding dimension or fact tables. You can find this information in the P6 Reporting Database installation directory \res folder in the mapping.tcsv file.



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014