The following is an excerpt from our Business Intelligence with Microsoft Project Server 2010 course. Enjoy!
From PWA navigation to the Business Intelligence Center à Sample Reports à English (United States)
Expose the contextual menu for the Simple Projects List à Edit in Microsoft Excel
If presented with a security warning, click the Enable Content button
Excel launches and the report generates
We are going to add a field to this report that is not currently part of its ODC file. Perform the following:
Select the Data Ribbon à Connections
If the Connections button is disabled, be sure to place cursor focus somewhere on the report.
Highlight the existing connection and click the Properties button.