Name

Most Frequently Called Countries

Feature Area

Analytics

Description

The user views a list of the countries most frequently called.

Preconditions

The user has successfully enrolled and authenticated in Oracle Self-Service E-Billing.

Primary User

Administrator, manager, and subscriber; CSR administrator and user.

Triggers

• The user clicks the Analytics tab, and then clicks the Top X Reports subtab. A report list appears and the user selects the hyperlink for Most Frequently Called Countries.
• The user selects Most Frequently Called Countries from the Top X Report drop-down list.

Prompts

Report Selection Criteria

Period Range (Default: Current period.)

• The user selects a start and end reporting period.

Number of Results:

• Default: 10
• The user can select the number of resulting report query rows to view from the following preconfigured values: 10, 25, 50, or 100.

Drop-down List:

• Highest Spending Services
• Most Expensive Calls
• Longest Calls
• Most Frequently Called Numbers
• Most Frequently Called Destinations
• Most Frequently Called Countries (Default)

Page Tabs

• Report (Active)
• Batch Request

Active Hyperlinks (Breadcrumbs)

• Analytics. Displays the list of Standard reports.
• Top X Reports. Displays the list of Top X reports.

Report Content

Page Title: Most Frequently Called Countries

Header:

• Report Details
• Number of items

Columns:

• Country (With a hyperlink to the Most Frequently Called Country by Service Number report)
• Number of Calls (sorted highest to lowest)
• Volume
• Total Charges.

Total Row:

• Total (literal)
• Number of Calls
• Total charges

Business Rules

• The current hierarchical position is used for reporting criteria.
• The current bill period (single period) is the default range.

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 there are 600 or more result set lines in the CSV file.

• All report detail table columns are sortable and display in descending order (highest to lowest); you can change the default sort order to ascending.

Rules

• Drill-down links are for the country selected.
• Oracle Self-Service E-Billing calculates the total number of calls made to a country and returns the number of results selected.
• If the report result set is less than the number of results selected, then the available data set displays.
• If there are ties in the total number of calls to a country, then Oracle Self-Service E-Billing returns service agreements from lowest to highest until it equals the total number requested (10, 25 50, or 100).
• The user can submit a batch request for this report.