Viewing reports

There are several ways to view a report, including your dashboard and UI search.

You can view a report in several ways:
  • 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.

The following choices (icons) give access to editing and configuring the report:
Edit Edit the query for this report (Using the Query-Report Builder).
Copy 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.
Data Mart Builder Opens the Data Mart Configuration dialog. For more information, see Data Mart.
Ad-hoc process for Run Once Now Ad-hoc process for run once now
Open in new window Opens the report in a new window.
display options Modifying the report display
Configure report columns Configure report columns: add or remove columns.
Configure runtime parameters 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 Add to favorites
stop Stops generation of a report (relevant for reports that take a longer time to generate)
Refresh 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.

You can print a report while you are viewing it. Click Export > Full printable report to open a printable copy of the report in a new tab. Click the printer icon on the new tab to print the report. You can also print a report by exporting it to a PDF file and printing the PDF file.
Note: For an instance where the PDF text is too small to read, the PDF report has a physical limit on how much it can expand horizontally given how wide the page is. Since each line of the PDF report has to fit on one line, the typeface size changes to fit the data, and may force a very small typeface size in order to display all the data.

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.

Viewing Big Data Intelligence reports has a few differences.
  • 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 Refresh reruns the query.