There are several ways to view a report, including your dashboard and UI search.
- If you have saved the report to a dashboard, open the dashboard to view the report.
- You can add the report to a dashboard. Open the dashboard and click Add Report, then choose the report from the list.
- Add the report to your custom reports.
- Some reports are listed in categories in the Reports lifecycle.
- Some reports are listed under the lifecycle to which they are most relevant.
- You can use the user interface (UI) search function to find a report that is in a lifecycle or in a dashboard. On the banner, choose User Interface from the drop-down list next to the Search box. Enter the name of the report into the Search box. Results begin to appear after you type a few characters. Choose the report from the list of results.
After upgrading from pre-v10.6 to v10.6 and higher: If you had multiple reports based on the same query, upon upgrade there is one query for every report whose name is the same as the report in the pre-upgrade version.
|Edit the query for this report (Using the Query-Report Builder).|
|Opens a new Query-report page with a copy of the report, except for the name. Modify and save as relevant. See Using the Query-Report Builder.|
|Opens the Data Mart Configuration dialog. For more information, see Data Mart.|
|Ad-hoc process for run once now|
|Opens the report in a new window.|
|Modifying the report display|
|Configure report columns: add or remove columns.|
|Configure runtime parameters. A run-time parameter provides a value to be used in a query condition. There is a default set of run-time parameters for all query-reports, and any number of run-time parameters can be defined in the query-report. (Modifying the runtime parameters)|
|Add to favorites|
|Stops generation of a report (relevant for reports that take a longer time to generate)|
|Refresh the report. See Refreshing reports|
You can hide columns from view. Click the columns icon and clear the check boxes for the columns that you want to hide.
You can sort report data by the contents of any column. Click the title of the column on which you want to sort. To reverse the order, click the title again. Sorting is always performed on the actual data values, ignoring any aliases that are defined.
Graphical reports can be customized by clicking the Customize Chart icon. The choices include converting the data to a line chart, changing the X-axis and Y-axis orientation, converting the report to a pie chart or a stacked column chart.
When viewing reports that display Oracle information, occasionally the ? question mark character is used to inform the viewer that the login information was not available. Again when viewing reports that display Oracle information, the appearance of the number -1 signifies that an unknown number of records are affected. All Oracle sessions are recorded, even with missed logins.
The OS user does not appear in reports if a Linux system or a Windows system using remote connections did not send the OS user with the login packet. For Linux local connections, UID chain can be used to identify the user. See which systems support UID chains in S-TAP support matrix.
- Reports present data in batches of 1000 items. Each page contains the number of rows defined in
the lower right corner. The page numbers under the report show the page within the batch. Page
through the batch using the page numbers. Proceed to the next batch with Next
batch. You can move forward in the batches. Run the query again to view earlier batches.
Note: If you sort the report, either by clicking a column name or by setting the sort order in the query-report itself, you only see one batch.
- Clicking Refresh reruns the query.