Built-In Filtering for P6 Projects

Setup project-level filtering for the ETL process from the P6 application, and enable it from the Primavera Analytics Administration as follows:

Sign in to P6 application.
Create a new project code. For example, ETLFilter.
Assign a code value. For example, 'Y'.
Assign all projects that are to be included in this filter.

In the extended schema, a new default view, ETLFILTER, has a WHERE clause criteria to gather the project object ID for all projects with this code assignment.

To configure for the Data Warehouse:

Sign in to Primavera Analytics Administration application.
Select the data source. For example, staretl1.
Select the Config section and view the configuration options.
Locate star.project.filter.ds1.
To use this default filtering mechanism set this to True and save.
The next ETL run will include projects only in this filter.

Related Topics