Oracle Advanced Support Platform enables you to generate reports about service level agreements (SLAs), if you have been granted the appropriate privileges.
To create an SLA report:
Log in to Oracle Advanced Support Platform.
The Oracle Advanced Support Platform page appears.
Click Advanced Monitoring.
The Advanced Monitoring page appears.
From the Reports menu, select (Create) Report.
The Create Report page appears.
From the Report Type list, select SLA.
In the Report Title box, enter a name for the SLA report.
From the Access Type list, select the type of access to the report.
From the Customer list, select the customer organization associated with the report.
In the Description box, optionally provide a description of the report.
From the Queries list, select one or more queries you want to use to build the report; then click Add to move the query to the Selected Queries window.
To add report parameters that the user must complete when running the report:
Under Report Parameters, click Add.
The Add Parameter window appears.
Select the parameter type, enter the name, and title to be displayed to the user.
Click ADD.
To edit a selected query:
From the Selected Queries window, select a query, then click Set parameters. The parameter settings for the selected query appear under Query Parameters.
In the Title box, change the name of the query if required.
Under Group Settings, from the Can group fields list, select the fields that you want to group, then click Add.
Under Fields Settings, you can do the following:
Select Hide this field if you want to omit a specific field from the report.
From the Subtotal function list, select the aggregation value to display as a subtotal within the report for the specific field, such as number of rows (COUNT ROW) or number of unique values within a column (COUNT UNIQUE VALUE.)
From the Filters list, select an operator to filter the results, such as between to display results between two defined points.
Under Render Settings, select how you want to represent the report.
The system uses the queries you selected to create the report and display a tabular or graphical representation of the query data retrieved from the Reporting database.