Customizing STARETL Process Runs for a Data Source

To customize the STARETL process runs for a specific data source:

Sign in to the Primavera Analytics Administration Application:
http://<host>:<port>/p6rdb
In the sidebar, select Status.
In the Home menu, select a staretl<id> or a <Custom Name of a data source>.
In the sidebar, select Config.
Set the following ETL properties to perform different functions depending on their selected value:
- Load all Hierarchy Codes builds code hierarchies.
  Select True to run codes_hier.sql script and build code hierarchies with all the codes that come from the source.
  
  Select False to run codes_hier_all.sql script and build hierarchies with codes from configStar. This is the default value.
- ODI LoadPlan Auto Restart controls restart of ODI Load plans.
  Select True to auto restart all real-time ODI load plans. This is the default value.
  
  Select False to manually restart all real-time ODI load plans.
- Include Inactive Resources controls resource filtration.
  Select True to ensure Primavera Data Warehouse tables will not filter out inactive resources.
  
  Select False to filter out inactive resources. This is the default value.
  
  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.
- Turn off all History, keep Slowly Changing Dimensions controls history tables.
  Select True to turn off history tables. Slowly changing dimensions (SCDs) will continue to be captured on the project level without the history tables.
  
  Select False to keep history tables on with SCDs. This is the default value.
- Use project filter in data source 1 selects filtered projects only.
  Select True to ensure the next ETL run includes only projects filtered with the ETLFILTER code = ‘’Y’.
  
  The default value is False.
- Enable Slowly Changing Dimensions and Spread History controls the creation of SCDs and spread history.
  Select True to capture slowly changing dimensions (SCDs) and spread history. This is the default value.
  
  Select False to turn off (SCDs) and spread history.
- Turn off Resource and Role Limits controls resource and role utilization scripts.
  Select True to turn the scripts off.
  
  Select False to keep the scripts running. This is the default value.

Unifier Configuration Settings

Set the following properties to configure STARETL runs for a Unifier data source.

Store Unifier History controls Unifier history tables.
Select True to keep the history tables running. This is the default value.

Select False to disable all history tables.
If Store Unifier History is set to True, you can set the history levels for the following:
- Unifier Space Data History Level controls space history tables. Set this value to Month.
- Use P6 project Name for Unifier Project controls the source that will be used for naming a Unifier project.
  When set to True, if the Unifierproject ID is identical in P6 and Unifier, then the project name from P6 is used for the Unifier project.
  
  Select False to use the project name from Unifier.
- ODI LoadPlan Auto Restart controls restart of ODI Load plans.
  Select True to auto restart all real-time ODI load plans. This is the default value.
  
  Select False to manually restart all real-time ODI load plans.
- Unifier Project Shell History Level controls project shell history levels. Select the frequency of BP history tables as Week or Month.
- Unifier Level Data History Level controls level history (FMRE). Select the frequency of BP history tables as Week or Month.
- Unifier BP Data History Level controls BP history level. Select the frequency of BP history tables as Week or Month.
- Unifier Cash Flow and Cost Sheet Data History Level controls the cash flow history and cost sheet history tables. Select the frequency of history tables as Week or Month.

Last Published Thursday, December 12, 2024