29 Using Active Reports

Active Reports provide a flash based interactive report that allows you to save data in an HTML file which can then be used for offline viewing or e-mailing to your peers. Active Reports is not related to either the existing Enterprise Manager Information Publisher reports or BI publisher. The Flash player is a plug-in from Adobe that is required to view flash swf files. You must install the plug-in to view the Active Reports.

The following features are available as part of Active Reports:

• Save or Mail reports

  This feature is common to all active reports embedded in Enterprise Manager. You can click the Save button so that it can be viewed later. Clicking the Save button shows the platform-specific Save dialog box, and allows you to save the HTML file. Clicking the Mail button displays a dialog box where you can fill in the recipients or any message which will be included in the email. The report will be sent as an attachment of the mail.

  The reports that display when you initiate Save look similar to those that are generated by Enterprise Manager but differ in the following ways:

  • Active Reports provide language drop-down menus that allow you to change to a different language

  • Active Reports display no hyperlinks to other Enterprise Manager pages

  • Active Reports display no menu items to other online Enterprise Manager pages

• Show Active Report for SQL Details

  The SQL detail Active Report displays the data in the SQL details report. The Active Report shows similar content as the existing SQL Details report in Enterprise Manager.

• Report for SQL Performance Analyzer (SPA) Report

  The Flex SPA report page is similar to the existing SPA Report but provides a clearer and more interactive interface. The overall report page includes three tabs, one on global statistics, one on SQL statement count, and one using a scatter plot chart or a tree map to display the impact on SQL statements in detail.

For more information about using active reports, see the following sections:

• Using Active Reports to Mail a Report

• Using Active Reports to Save a Report

• Generating an Active Report from the SQL Details Page

• Generating an Active Report from the SQL Performance Analyzer (SPA) Page

Using Active Reports to Mail a Report

To mail an Active Report, follow these steps:

1. Navigate to the Enterprise Manager page displaying an Active Report Mail button and click Mail.

   The Active Reports Mail dialog box appears.

2. In the Active Reports Mail dialog box, enter your email address in the From field and then enter the addresses of the person or persons to whom you want to send the report in the To field. For multiple addresses, separate each address with a semi-colon (;). You can also enter a message in the Message field that describes the report and any other information you want to convey.

3. Click Send to send the email with the attached report.

To successfully send mail, you must set up the email server information. If the server information is not set, the dialog box will prompt you to configure the server and provide instructions on how to complete the task. To complete this information manually, you can navigate to the Enterprise Manager Setup link and click Notification Methods to fill in the mail server information.

Using Active Reports to Save a Report

To save an Active Report, follow these steps:

1. Navigate to the Enterprise Manager page displaying an Active Report Save button and click Save.

   The Save dialog box displays.

2. In the Active Reports Save dialog box, enter the location on your system where you would like to save the HTML report.

3. Click Save to save the report.

   Note:

   The Save feature in Active Reports is different from the Save As function on your browser. The browser saves all the files required to render the page to your local file system. In most cases this will not allow you to see the report in the original form. The Active Reports save feature will save the file in HTML only. All the required files, such as the javascript and swf files used to render the report are hosted remotely on the Oracle Technology Network (OTN).

   Note that the report that displays when you initiate Save appears similar to those that are generated by Enterprise Manager but differ in the following ways:

   • Active Reports provide a language drop-down menu that allows you to switch to a different language

   • Active Reports display no hyperlinks to other Enterprise Manager pages

   • Active Reports display no menu items to other online Enterprise Manager pages

Generating an Active Report from the SQL Details Page

To generate an Active Report from the SQL Details page, follow these steps:

1. Navigate to the SQL Details page and click the Show Active Report button.

   The Save dialog box displays.

2. In the Active Reports Save dialog box, enter the location on your system where you would like to save the HTML report.

3. Click Save to save the report.

   The generated Active Report displays similar contents as the existing SQL Details page in Enterprise Manager.

   Note:

   The Save feature in Active Reports is different from the Save As function on your browser. The browser saves all the files required to render the page to your local file system. In most cases this will not allow you to see the report in the original form. The Active Reports save feature will save the file in HTML only. All the required files, such as the javascript and swf files used to render the report are hosted remotely on the Oracle Technology Network (OTN).

   Note that the report that displays when you initiate Save appears similar to those that are generated by Enterprise Manager but differ in the following ways:

   • The Active Reports report provides a language drop-down menu that allows you to switch to a different language

   • Active Reports display no hyperlinks to other Enterprise Manager pages

   • Active Reports display no menu items to other online Enterprise Manager pages

Generating an Active Report from the SQL Performance Analyzer (SPA) Page

To generate an Active Report from the SQL Performance Analyzer (SPA) page, follow these steps:

1. Navigate to the SQL Performance Analyzer page and click the Show Active Report button.

   The Save dialog box displays.

2. In the Active Reports Save dialog box, enter the location on your system where you would like to save the HTML report.

3. Click Save to save the report.

   The Flex SPA report page is similar to the existing SPA page in Enterprise Manager, however it uses features in Flex to provide a clear and more interactive display. The overall report page includes three tabs; one on global statistics, one on SQL statement count, and one using a scatter plot chart or a tree map to display the impact on SQL statements in detail.

   Note:

   The Save feature in Active Reports is different from the Save As function on your browser. The browser saves all the files required to render the page to your local file system. In most cases this will not allow you to see the report in the original form. The Active Reports save feature will save the file in HTML only. All the required files, such as the Javascript and SWF files used to render the report are hosted remotely on the Oracle Technology Network (OTN).

   Note that the report that displays when you initiate Save appears similar to those that are generated by Enterprise Manager but differ in the following ways:

   • The Active Reports report provides a language drop-down menu that allows you to switch to a different language

   • Active Reports display no hyperlinks to other Enterprise Manager pages

   • Active Reports display no menu items to other online Enterprise Manager pages