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.