|
Application Guide for Oracle Self-Service E-Billing (Consumer Edition) > Top X Reporting Use Cases >
Most Frequently Called Country by Service Agreement
The user can use this use case to view a report showing a list of service agreements for the most frequently called country. Table 45 lists and describes the use case functions.
Table 45. Most Frequently Called Country by Service Agreement
|
|
Name |
Most Frequently Called Country by Service Agreement |
Feature Area |
Analytics |
Description |
The user views a list of service agreements associated with the most frequently called country. |
Preconditions |
The user has successfully enrolled and authenticated in Oracle Self-Service E-Billing. |
Primary User |
Administrator, manager, and subscriber; CSR administrator and user. |
Trigger |
The user clicks a country hyperlink on the Most Frequently Called Countries report. |
Page Tabs |
Report (Active) |
Active Hyperlinks (Breadcrumbs) |
- Analytics. Displays the list of Standard reports.
- Top X Reports. Displays the list of Top X reports.
- Most Frequently Called Countries. Displays the Most Frequently Called Countries report.
|
Report Content |
Page Title:
- Most Frequently Called Country by Service Agreement
Paging Elements (If needed)
- Page X of Total
- Paging arrow buttons
Header:
- Report Details
- Number of items
Columns:
- Country
- Service Number (With a hyperlink to the Most Frequently Called Country by Service Number Details report)
- Number of Calls (sorted highest to lowest)
- Volume
- Total Charges.
Total Row:
- Total (Literal)
- Number of Calls
- Volume
- Total charges
|
Business Rules |
The period range selected on the Most Frequently Called Countries report applies on this drill-down report. |
Standard Features |
- Printer-friendly view
- Download CSV or XML
|
Configuration Points |
- Report Threshold Value for Batch Mode. Determines the number of result set lines above which a report must process in batch mode instead of as an online download. You can set values for each type of download file:
- CSV. The maximum number of output lines.
- XML. A percentage of the CSV threshold value (Default is 20%).
For example, if the CSV report threshold is set to 3,000 result set lines, then an XML threshold value set at 20% must process in batch mode when it has 600 or more result set lines.
- All report detail table columns are sortable (except for the country column) and display in descending order (highest to lowest); you can change the default sort order to ascending.
|
Functions |
Drill-down links are for the country and the selected service agreement. |
Main Path for Viewing the Most Frequently Called Country by Service Agreement
The main path to view the Most Frequently Called Country by Service Agreement report is as follows: The user clicks the Country hyperlink on the Most Frequently Called Countries report. Oracle Self-Service E-Billing retrieves the report data and displays a tabular report for the selected country. Alternate Paths for Viewing the Most Frequently Called Country by Service Agreement
Alternate paths can occur in this use case. The user clicks the Download action (CSV or XML)
Oracle Self-Service E-Billing downloads a report in the selected format. The user clicks the Printer Friendly action
Oracle Self-Service E-Billing displays the print page. Exceptions for Most Frequently Called Country by Service Agreement
An exception can occur in this use case. The user encounters a system error
Oracle Self-Service E-Billing invokes the error message use case.
| 
