You can apply a filter during the STARETL process that can limit the data loaded into Primavera Data Warehouse based on a specific criteria. By creating a filtered view, you can limit the projects you include in Primavera Data Warehouse to a portfolio, an EPS, or any other specified criteria. In this way, you can customize Primavera Data Warehouse with only the projects that are needed.
If you want to create a filtered source of data for loading into Primavera Data Warehouse, the filter must be created with the user account that was created for the publication tables/views (for example, PXRPTUSER) with the P6 EPPM database instance.
Before creating a new filtered view, Oracle recommends that a new data source be added to Primavera Data Warehouse. Doing this ensures that the existing STARETL process and associated data is unaffected by any filtering that is occurring. To create a new data source, see the Primavera Data Warehouse Installation and Configuration Guide for details on how to create and set up a new data source for details.