Project and Portfolio Management Practitioners Forum
cancel

PPM Budget Extract

Highlighted
Vsalian
Respected Contributor.

PPM Budget Extract

Is it possible to extract PPM Budgets for all the projects in to one excel sheet/workbook.
I know we can do it one by one by going into each project and then exporting.
Is there a easy way to extract all of the financials for all projects?? Any help would be appreciated.

Thanks,

V
4 REPLIES
Sangiliraja_1
Honored Contributor.

Re: PPM Budget Extract

Hi V,

It depends on what kind of data you are trying to gather from PPM.

Simple one will be creating a program and take cost analysis from there. which gives project wise total breakup.

The complex will be creating a custom portlet and extracting the portlet to excel.

Thank
Sangiliraja.P
Vsalian
Respected Contributor.

Re: PPM Budget Extract

Thanks for ur response...I m looking for something like this. See attached. I am just after Budgets nd Benefits tab. I found this on the forum... I am guessing that if this can be imported there shud be a way to export it out of PPM as well.
Is it possible?
Vibhor Dwivedi
Super Contributor.

Re: PPM Budget Extract

you can write a simple sql and fetch it from back end.

Or

You can use same sql for fetching that data through PPM report

Mikia
Trusted Contributor.

Re: PPM Budget Extract

See attachment; you can use and modify it

:)