1 About BRM Reports

This chapter provides an overview of Oracle Communications Billing and Revenue Management (BRM) Reports implemented with Oracle Business Intelligence (BI) Publisher.

Introducing BRM Reports

BRM Reports is a set of report templates that you can use to track customer activity and billing. These templates are designed to be used with a BRM database and BI Publisher.

Before using BRM Reports, you should be familiar with basic BRM terms and concepts. For more information, see BRM Concepts.

You can run the reports from any Windows computer that has access to your BRM database.

You can display and print report results in tabular text format, a chart, or both. You can also save reports to disk, convert reports to Portable Document Format (PDF) or Rich Text Format (RTF), and display reports on HTML Web pages, all with BI Publisher. BI Publisher also supports XML data format.

Figure 1-1 shows the output for an AR Summary report:

About the BRM Reports Packages

The BRM reports are distributed in the following packages:

  • BRM base reports include reports about accounts receivables, credit card usage, general ledger, and tax calculation. See "BRM Base Reports".

  • Brand Manager reports show data for only one brand. See "Reporting by Brand".

    Important:

    Brand Manager is an optional feature that requires a separate license.

  • Content Manager reports support Content Manager, an optional component that allows you to bill customers for content offered by content providers and to remit content providers for content purchased. You use these reports to show content usage, charges incurred for content usage, and the amount to remit to content providers for content purchased. See "Content Manager Reports".

    Important:

    Content Manager is an optional feature that requires a separate license.

  • MultiDB Manager reports retrieve and display A/R data from more than one BRM database schema in the same report. See "Running Reports against Multiple Schemas".

    Important:

    Multischema capabilities are optional features that require a separate license.

  • Number Manager reports support Number Manager. You use this report to track number inventory and information relating to tracking telephone numbers. See "Number Manager Reports".

    Important:

    Number Manager is an optional feature that requires a separate license.

  • Revenue Assurance Rating Summary reports support Revenue Assurance Manager. You use them to track revenue assurance data collected by auditing billing utilities and Pipeline Manager.

  • SIM Manager reports support SIM (Subscriber Identity Module) Manager. You use these reports to track the status of SIM cards you have ordered and the state of SIM cards currently in inventory. See "SIM Manager Reports".

    Important:

    BRM SIM Manager is an optional feature that requires a separate license.

  • Suspense Manager reports support the standard recycling and Suspense Manager features. You use them to track suspended call records, processed by Suspense Manager for a specific time period, and those with a status of written-off, for each brand.

  • Roaming Manager reports support TAP (Transfer Account Procedure) Roaming Manager reports that are implemented with Oracle Business Intelligence (BI) Publisher. These reports enable roaming partners that have not implemented Near Real Time Roaming Data Exchange (NRTRDE) to exchange high-usage roaming information with each other. See "Roaming Manager Reports".

  • Wireless access service reports support GPRS Manager. You use them to track usage and error information for your General Packet Radio Service (GPRS) services. See "Wireless Reports".

    Important:

    GPRS Manager is an optional feature that requires a separate license.

  • Collections Manager reports support Collections Manager, which you use to manage in-house debt collections. See "Collections Manager Reports".

    Important:

    Collections Manager is an optional feature that requires a separate license.

  • SMS Settlement reports support SMS (Short Message Service) settlement. You use them to track the aggregated information about SMS messages exchanged between home network and other networks.

    Important:

    SMS Settlement Reports is an optional feature that requires a separate license.

  • Voucher inventory management reports support Voucher Manager. You use them to track what vouchers are in the system. See "Voucher Inventory Management Report".

    Important:

    Voucher Manager is an optional feature that requires a separate license.

  • Voucher device management reports support Voucher Manager. You use them to track the contents and attributes of a voucher. See "Voucher Device Management Report".

    Important:

    Voucher Manager is an optional feature that requires a separate license.

About Customizing BRM Reports

Each report template includes a set of parameters that determines what data is extracted from the BRM database and how that data is displayed in the report output. To tailor the output for your needs, you specify values for the parameters when you run reports.

In addition, if you have BI Publisher design privileges and structured query language (SQL) experience, you can customize the report templates. For example:

  • You can change the values in parameter lists, and you can add parameters to or delete them from the templates.

  • You can convert dates, decrypt credit card numbers, and localize report input and output.

  • You can produce reports that show data for a specific brand.

  • You can automatically list output from several BRM database schemas in one report.

For more information about customizing BRM reports, see the following topics: