Name

Highest Spending Services

Feature Area

Analytics

Description

The user views a report showing which service agreements have the highest total charges, independent of usage type.

Primary User

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

Trigger

• The user clicks the Analytics tab, and then clicks the Top X Reports subtab. A report list appears and the user clicks the hyperlink for Highest Spending Services.
• The user selects Highest Spending Services 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 (Default)
• Most Expensive Calls
• Longest Calls
• Most Frequently Called Numbers
• Most Frequently Called Destinations
• Most Frequently Called Countries

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:

• Highest Spending Services

Header:

• Report Details
• Number of items

Columns:

• Service Number (With a hyperlink to the Highest Spending Services by Service Agreement report).
• Name
• Account Number
• Total Charges. Sorted highest to lowest, with a hyperlink on the letter T to the Service Billing Trend report for the service agreement.

Total Row:

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

Business Rules

The current bill period range (single period) is used as the default criteria.

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 and display in descending order (highest to lowest); you can change the default sort order to ascending.

Functions

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