Reporting from many projects from the EPS

Member for

21 years 8 months

It is not unusual to have hundreds of schedules in a government agency portfolio. If so, the program manager will be receiving hundreds of updates every month, each with a Data Date of their own, in some cases a few will not be received on time, but the manager will still be in need to report what is available. 

Loading the latest update we know as Consolidation of Subprojects, it is done at a single click of the mouse.

00

This is a procedure many program managers must perform very frequently. Your software is different but I suspect there must be an easy way to automatically upload the latest update for each project schedule.

If your software depends on pre-defined Financial Periods you might have some issues with the cost reports when the Projects Data Date and/or Performance Periods are different. It is possible that some submitted schedules might use weekly performance periods while other might use monthly performance periods or any other.

Good Luck, Rafael

Member for

20 years 6 months

Brian,

Use a Global Activity Code to tag the required activities in each project. Then using the Project Codes, Open all the projects you have filtered at once., and then filter based on the Global Activity Code. 

Member for

7 years 10 months

Santosh's suggestion to use Select ENTERPRISE>PROJECT CODES takes care of part of my question. It is still necessary to ensure that the current version of the schedule for each project is tagged as master/working/current (which makes sense).

One further question is whether it is possible to filter out one or more milestone activities from inside each schedule, e.g. Occupancy milestone, commissioning milestone or substantial completion etc. 

Member for

20 years 6 months

Brian, just like you can create Activity codes to assign to activities, you can create Project Codes to assign to projects. Select ENTERPRISE>PROJECT CODES from the menu. These can also be hierarchical.

You can then Filter, or Group by these codes rather than using the EPS structure.

Member for

19 years

Yes, why not? If the information are requires on the report. You can tailor to suit your report as per report requirement and what suits for the stakeholders.

Member for

7 years 10 months

more clarification: would like to bring the data (data date, start date end date and last scheduled date) from the newest project in every EPS node. 

 

Member for

19 years

.

Member for

19 years

You can filter by data date or date added, which ever is your preference to suit your requirements.

Member for

7 years 10 months

Thanks to further clarify.

If one project has many schedules (wekly updates, What if's etc) in the EPS node how can we filter for the latest or most relevant schedule in each EPS to include.

Member for

19 years

Under the Project module, you can create a Project layout (grouping, sorting, filter, date,progress, etc) and produce the report. You may need to run the Tools -> Summarize to get the progress % shown.