The following example demonstrates how to create a view for only active projects and a filter called active_projects.
- Log in to the Primavera Unifier instance (with SQL Plus, SQL Developer, and so on), with the schema owner account (for example, unifier).
- Use the following statement to create the active_projects filter:
create or replace view active_projects as select project_object_id objected from sys_stg_project where project_status = 'Active'
- Upon successful completion of the sample filter, log out of the instance.
- Log in to the Primavera Data Warehouse database instance as the schema owner (for example, the STARUSER account).
- Use the following statement to add a setting into the ETL_PARAMETER table with the name of the view you created:
insert into etl_parameter(p_feature, p_1, datasource_id)
values ('star.project.filter.ds1', 'active_projects', 1);
commit;
- Go to <PDW Install Folder>\star\etl_homes\staretl<id>.
- Run staretl.bat (with Windows) or staretl.sh (with UNIX or Linux).