Bookshelf Home | Contents | Index | PDF     

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

Group Spending Trend

This report tracks monthly summary charge information over a user-defined reporting period for a selected group in a group hierarchy. The Group Spending Trend report analyzes trends and identifies anomalies. Table 48 lists and describes the use case functions.

Table 48. Group Spending Trend Report
Function
Description

Name

Group Spending Trend Report

Trigger
  • Report List
  • Drill-down: Group Spending Trend Report (from a higher level in the hierarchy)
  • Drill-down: Group Spending Report
  • Report Drop-down

Chart

Default Chart Type: Bar (user might select another type):

  • X axis: Reporting Period
  • Y axis: User defined value

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.

Main Path for Configuring Group Spending Trend

The following path describes the Configuring Group Spending Trend use case:

1 The user selects the report from the List of Billing Reports.
  1. Oracle Self-Service E-Billing determines query parameters based on report context or defaults.
  2. Oracle Self-Service E-Billing returns:
    • Bar Chart
    • Summary tabular report

Alternate Paths for Configuring Group Spending Trend

Alternate paths can occur in this use case.

The user selects the Month Total Value link

The Month Total Value link drills into Group Spending report for the month that corresponds to the selected row.

Result set returns more than 20 Chart Bars

The user receives a message that the chart was suppressed because of this condition.

The user selects the Printer Friendly action

Oracle Self-Service E-Billing removes graphics and navigation and displays a printer friendly view.

The user selects the Download action (CSV or XML)

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

Exceptions for Configuring Group Spending Trend

None.

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