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.
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
Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved.