If you are referring to setting up multiple instances of PWA, you might consider the following ‘Lesson Learned’ – Plan for at least 3 different instances setup something like below, right out of the gate (I wish I had originally planned our’s this way):
PWA_Dev – Development Environment
PWA_T – Training Environment
PWA_P – Production Environment
Each is independant of the other, and you dont have to ‘filter’ testing (development) and training projects out of the production Excel, SSRS, DA or SBIDS reports, and the Production instance is ‘cleaner’ without any development or testing data ‘polluting’ the end-use datasets
Good Luck, if you need any more suggestions, just ask…
I am currently working on a formal ‘Lessons Learned’ for our deployment effort for Project Server 2007, so this discussion helps (forces) me to think about how I would do things differently next time
