The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Comparision work plan with base line portlet

Highlighted
Semenov Alexand
Esteemed Contributor

Comparision work plan with base line portlet

Good Day ALL.
I have interest issue. My PM's want to campare work plan with base line visually (not with help baseline comparision report)(as in MSP). For exaple it can be any portlet allowed by pressing buttom "Compare" in work plan edit mode.
(screens in attach)
Any ideas?
2 REPLIES
patrick-sa
Regular Collector

Re: Comparision work plan with base line portlet

Hi ,

i've got the exact requirement from our pm's as well.what i'm planning to do is to create a seperate portlet which populates the scheduled finish dates of tasks from the baseline.for instance when u create a project you baseline it immediately to create a "basis point"then as the project progress the portlet will show what the scheduled finish date was (at the baseline) my problem right now is how to get these dates from the baseline.
Semenov Alexand
Esteemed Contributor

Re: Comparision work plan with base line portlet

patrick hi.
For solve you problem try use this query:
select
to_char(wpa.perc_complete) perc_complete
,blts.sched_start_date bl_start_date
,blts.sched_finish_date bl_finish_date
,nvl(wpti.name, '###absent in WP###') wp_name
,nvl(blti.name, '###absent in BLa###') bl_name
,nvl(wpts.sched_start_date, blts.sched_start_date) wp_start_date
,nvl(wpts.sched_finish_date, blts.sched_finish_date) wp_finish_date
,nvl(wpt.outline_level, blt.outline_level)-1 outline_level
,wpa.act_start_date act_start_date
,wpa.act_finish_date act_finish_date
from
itguser.wp_tasks wpt full join itguser.wp_tasks blt on wpt.task_id=blt.business_uid
left join itguser.wp_task_actuals wpa on wpa.actuals_id=wpt.task_actuals_id
left join itguser.pm_work_plans wp on wp.work_plan_id=wpt.work_plan_id
left join itguser.pm_work_plans bl on bl.work_plan_id=blt.work_plan_id
left join itguser.wp_task_info wpti on wpti.task_info_id=wpt.task_info_id
left join itguser.wp_task_info blti on blti.task_info_id=blt.task_info_id
left join itguser.wp_task_schedule wpts on wpts.task_schedule_id=wpt.task_schedule_id
left join itguser.wp_task_schedule blts on blts.task_schedule_id=blt.task_schedule_id
where
bl.is_active_flag='Y' and bl.entity_type='BASE_LINE' and bl.project_id=31777

This query show planned dates from BL and WP and ather inf
Good Luck
//Add this to "OnDomLoad" event