How Can Planned And Actual Cost Be Found On FIN_COST_PLAN_DETAILS?

Products

• Clarity PPM SaaS

Issue/Introduction

How can the following information be found on the table FIN_COST_PLAN_DETAILS
-planned units
-planned cost

Resolution

The following base query can be used, given the plan_id:

--Postgres
select cal.start_date, fin_cost_plan_details.id, sum(nk_sum_julian_fct(odf_nk_cost, cal.julian_start, cal.julian_finish)) total
from fin_cost_plan_details, unnest(crv_calendar_fct('MONTH', '2025-01-01',null, 36, 'FISCAL', 'ENTITY=bc_entity')) cal 
where plan_id = <substitution>
group by cal.start_date, fin_cost_plan_details.id

Additional Information

For additional fields, such as
-actual units
-actual cost

The same method can be used.