Name

Highest Spending Services by Service Agreement

Feature Area

Analytics

Description

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

Primary User

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

Trigger

The user clicks a service number hyperlink on the Highest Spending Services report.

Prompts

None

Page Tabs

Report (Active)

Active Hyperlinks (Breadcrumbs)

• Analytics. Displays the list of Standard reports.
• Top X Reports. Displays the list of Top X reports.
• Highest Spending Services. Displays the Highest Spending Services report.

Report Content

Page Title: Highest Spending Services by Service Agreement

Paging Elements (If needed):

• Page X of Total
• Paging arrow buttons

Header:

• Report Details
• Number of items

Columns:

• Service Number
• Name
• Account Number
• Date
• Time
• Usage Type
• Volume
• Total Charges (Sorted highest to lowest)

Total Row:

• Total (literal)
• Total charges

Business Rules

The current hierarchical position and current bill period range (single period) selected on the Highest Spending Services Report apply 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 there are 600 or more result set lines in the CSV file.

• All report detail table columns are sortable (except for service number, name, and account columns) and display in descending order (highest to lowest); you can change the default sort order to ascending.

Note

This report uses paging elements if the number of results exceeds the threshold set for the page view.