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: 

PPM Budget Extract

Highlighted
Vsalian
Regular Collector

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
Collector

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
Regular Collector

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
Regular Collector

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
Super Collector

Re: PPM Budget Extract

See attachment; you can use and modify it

:)
//Add this to "OnDomLoad" event