Project and Portfolio Management Practitioners Forum
cancel

Scenario Comparison Query

Highlighted
garylynch
New Member.

Scenario Comparison Query

Anyone have a query to duplicate the data in a scenario comparison?

3 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Scenario Comparison Query

Can you be more specific to which data?

garylynch
New Member.

Re: Scenario Comparison Query

sure...  when you do a scenario compare and you get that data with these columns headings:

Name
Phase
Business Unit
Projected Cost
Projected Benefit
Total Resources (person months)
Score
Scenario 1
Scenario 2
Scenario 3

You an export it to excel at that point...  We are looking for the query that generates that screen... 

Erik Cole
Acclaimed Contributor.

Re: Scenario Comparison Query

Have a look at kpfm_scenario_contents_pfm_v and kpfm_scenario_contents_v tables...joined together they give you that grid.