Application Guide for Oracle Self-Service E-Billing (Business Edition) > Top X Reports >

Most Frequently Called Destinations


The user can use this use case to view a report showing a list of the most frequently called destinations. Table 58 lists and describes the use case functions.

Table 58. Most Frequently Called Destinations
Function
Description

Name

Most Frequently Called Destinations

Feature Area

Analytics

Description

The user views a list of the destinations 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 Destinations.
  • The user selects Most Frequently Called Destinations 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 (Default)
  • 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: Most Frequently Called Destinations

Header:

  • Report Details
  • Number of items

Columns:

  • Destination (With a hyperlink to the Most Frequently Called Destination by Service Number report)
  • Country
  • 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 destination selected.
  • Oracle Self-Service E-Billing calculates the total number of calls made to a destination 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 destination, 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.

Main Path for Using Most Frequently Called Destinations

The following path describes the Most Frequently Called Destinations use case:

  1. The user selects the Most Frequently Called Destinations report from the List of Top X Reports or from the drop-down list of reports.
  2. Oracle Self-Service E-Billing displays the top ten records of the Most Frequently Called Destinations report for the current period and hierarchy position.

Alternate Paths for Most Frequently Called Destinations

Alternate paths can occur in this use case.

The User Specifies Query Parameters
  1. The user enters start and ending report dates or selects a new number of results.
  2. Oracle Self-Service E-Billing retrieves the report data for the selected criteria and user hierarchy position and displays the Most Frequently Called Destinations report.
The User Selects the Download Action (CSV or XML)

Oracle Self-Service E-Billing downloads a report in the selected format.

The User Selects the Printer-Friendly Action

Oracle Self-Service E-Billing displays the print page.

Exceptions for Most Frequently Called Destinations

An exception can occur in this use case.

The User Encounters an Error

Oracle Self-Service E-Billing invokes the error message use case.

Application Guide for Oracle Self-Service E-Billing (Business Edition) Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.