We covered so far all the steps to rename project schedule in MS Project Server. The Business Intelligence (BI) Center reports out of SSAS OLAP Cube will show the old and new project name. It is best to select both project names for accurate EPM reporting.
Let’s look Project Web Access (PWA) > Business Intelligence (BI) timesheet reports.
As an example let’s pick one of the timesheet template. Go to PWA > Project BI Center > Templates Library on left> English (United States) folder > Server Name – OLAP Database Name folder > OlapTimesheet.xltx
The path of that file is something like this:
Click on the OlapTimesheet.xltx template file to open it in Microsoft Excel. First save the file to the root of your Template library using save option or to a place where you like to organize Project BI Reports. I saved it to following location
With Excel report still open, now choose the fields from the PivotTable Fields list on the right side. Create a timesheet report that will have Timesheet Project List in it.
|Project Web Access – BI Center Excel Report – Choose PivotTable Fields
Filter the project list and select only the project name. You will notice only the old project.
|Project Web Access – BI Center Excel Report – EPM Timesheet Report before project renamed
Close the OLAP Excel Report file.
Now enter hours under a different timesheet period and submit. Later process the PWA OLAP cube manually from Server Settings > OLAP Database Management. Highlight your OLAP Database name row (don’t click on cube name), then click on Build Now icon above. Once the cube builds successfully, launch your timesheet report again from the place where you saved it. Apply the filter on the project name and expand the row data. You will now notice the old and new project names there.
|Project Web Access – BI Center Excel Report – EPM Timesheet Report after project renamed
Here the linkto the sample cached excel report from the BI Center.
You can see renaming a project might look like a quick thing to do. But it requires careful steps to update name at different places. You miss a major step and you will see your users complaining about different issues:
- I don’t see my project anymore
- My timesheet hours are lost
- I can’t get my project SharePoint site
- List goes on….
A better communication plan for the change and doing this change at non-peak hours is the recommended approach.
That finishes last part of this series. We covered the following topics in this series.