- Custom Calculations
- Custom Calculations
- Custom Calculations
- P6 Analytics now allows you to customize the ETL process for counts and calculations using metadata.
- When you edit a calculation, the next time you run the ETL process, the affected column will be updated with the new calculation. If the syntax is invalid, P6 Analytics will use the default calculation.
- To access this feature:
- This feature should be completed by a system or database administrator. The calculations can be updated for any COLUMN_NAME listed in the ETL_CALCULATIONS table. New columns cannot be added.
- Using SQL, update the table named ETL_CALCULATIONS.
- Set the CALCULATION column of the COLUMN_NAME with the new calculation you would like set.
- Run the STARETL.bat for the new calculation to be used.
- For example, the "Completed Last Period" metric for activity history currently displays all the activities finished since the current period start date. You can update the calculation to return only critical activities finished completed last period:
- UPDATE etl_calculations
- SET calculation= 'CASE WHEN a.actual_finish_date IS NULL THEN 0
- WHEN a.IS_CRITICAL AND a.actual_finish_date < s.period_start_date THEN 1 ELSE 0 END'
- WHERE table_name = 'W_ACTIVITY_HISTORY_F'
- AND COLUMN_NAME = 'COMPLETED_LAST_PERIOD';
- Legal Notices