07/جمادى الأولى/1433 04:19 م
We have two different divisions in our company that require separate instances of PWA. We do, however, we share some resources between the two divisions. Is there any way to do capacity planning between the two PWAs without having to purchase a third party tool?
Thank you for any suggestions
07/جمادى الأولى/1433 06:32 م
As far as I know, there is no out of the box way to manage resources automatically between two separate instances.
One "Manual" way I can think of is to balance the Maximum units of availability for the resource between both the instance. This will help your PM's in planning so that they do not over allocate the resource(s).
For monitoring purposes, you could build a report that will query both Reporting Databases and give you data as to what they are assigned in each of the instance.
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com
07/جمادى الأولى/1433 06:33 م
You're probably looking at a two step process to get this done.
1) As the two PWA instances store data in separate database, your first step will be to combine these two data sources into one. You could accomplish this with a SQL Server Integration Services (SSIS) package that writes this data to a new table/DB.
2) If you're interested in having that overall capacity timephased, you will probably need to build a custom OLAP cube in SQL Analysis Services (SSAS) which uses the data you have combined in the first step.
After you've done this, you're ready to design some reports in Excel using data from your new OLAP cube. However, one thing to pay close attention to is duplicate capacities. You will have to come up with a mechanism to identify resources that are available in both PWA instances and ensure that their overall capacity (across PWA instances) is accurate.
I hope this will get you going in the right direction... There might be other ways to get this done, but this would be my preferred approach.
- تم وضع علامة كإجابة بواسطة Daren (DJ) Johnson 17/جمادى الأولى/1433 01:03 م
07/جمادى الأولى/1433 11:27 م
Are you using Project Server 2010? Have you studied the possibility of using a single instance and use the functionality "Departments" to handle your functional units?
10/جمادى الأولى/1433 01:02 م
Agreed with jpussacq, just need to add one more thing, apart from Departments we have RBS as well that will handle your scenario.
10/جمادى الأولى/1433 01:09 مThank you for the ideas. Unfortunately, with the type of contracts we have, we are legally bound to have data segregated data. I will need to explore options like Prasanna and shelldor23 mention above.
10/جمادى الأولى/1433 03:45 م
17/جمادى الأولى/1433 01:03 م
We've pulled the information from both instances of PWA into Excel using PowerPivot and custom SQL statements. Having the timephased information in pivot table format will allow us to accomplish the resource planning we were hoping for. Thanks for the ideas!