Create a new Excel Report from Existing (modifying ODC), excerpt from Business Intelligence Course

Step

Action

Details

1

From PWA navigation to the Business Intelligence Center à Sample Reports à English (United States)

2

Expose the contextual menu for the Simple Projects List à Edit in Microsoft Excel

3

If presented with a security warning, click the Enable Content button

4

Excel launches and the report generates

5

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.

6

Highlight the existing connection and click the Properties button.

<img title="clip_image010" border="0" alt="clip_image010" width="398" height="271" style="background-im