Anyone have a query to duplicate the data in a scenario comparison?
Can you be more specific to which data?
sure... when you do a scenario compare and you get that data with these columns headings:
NamePhaseBusiness UnitProjected CostProjected BenefitTotal Resources (person months)ScoreScenario 1Scenario 2Scenario 3
You an export it to excel at that point... We are looking for the query that generates that screen...
Have a look at kpfm_scenario_contents_pfm_v and kpfm_scenario_contents_v tables...joined together they give you that grid.