Including Inactive Resources from P6 EPPM in the Primavera Data Warehouse Tables

By default, the Primavera Data Warehouse tables filter out inactive resources. If you include inactive resources, the spread data and other dimension tables will also include them. You may not need to process this extra resource assignment information.

If you want to include inactive resources in the Primavera Data Warehouse tables and have deployed Primavera Analytics Administration Application, see Customizing STARETL Process Runs for a Data Source.

If you are not using Primavera Analytics Administration Application:

  1. Log in to the Primavera Data Warehouse database instance as the schema owner. For example, the STARUSER account.
  2. Use the following statement to change the setting for inactive resources in the ETL_PARAMETER table:

    update etl_parameter

    set p_1 = 'true'

    where p_feature = 'star.utilization.include.active.rsrc'

    and datasource_id = 1;

    commit;


Last Published Thursday, December 12, 2024