This chapter describes how to customize Oracle Communications Billing and Revenue Management (BRM) report templates to generate reports for only one brand.
For information on using brands in BRM, see "About Branding" in BRM Managing Customers.
For general information on how to run reports, see "Running BRM Reports".
Important:
To customize the structured query language (SQL) queries used to select the report data from the BRM database, you should have SQL experience and be familiar with the BRM database schema.
To customize queries in Oracle Business Intelligence (BI) Publisher, you must have design privileges.
If you host Internet services for other companies, you can display data related to only one brand in your BRM reports. To do this, follow these general procedures:
To configure BI Publisher to support reporting by brand and view the reports, perform the following tasks:
To create a brand user, do the following:
Log in to BI Publisher as Administrator, by following the instructions in "Accessing BI Publisher".
Click the Admin tab.
Under Security Center, click the Users link.
Click the Create User button.
Enter the brand user name in the Username field.
Enter the password in the Password field.
Click the Apply button.
Click the Assign Roles icon for the user.
Select Administrator from the Available Roles, and click the Move button.
Click the Apply button.
Click the Roles and Permissions tab.
Click the Create Role button.
Enter the brand user name that you created earlier, in the Name field.
Enter the description in the Description field.
Click the Add Folders icon for the role.
Select the desired folders from the Available Folders list, and click the Move button.
Click the Apply button.
Click the Add Data Sources icon for the role.
Select BRM_DATA_SOURCE from the Available Data Sources under the Database Connections section, and click the Move button.
Click the Apply button.
Click the Add Roles icon for the role.
Select BI Publisher Administrator from the Available Roles, and click the Move button.
Click the Apply button.
Click the Sign Out link.
To view brand-specific versions of BRM reports:
Log in to BI Publisher as a brand-specific user.
Click the Reports tab.
Click the BRM Reports link under Shared Folders.
Click the Branding Reports link.
Click the View link under the report you want to view.
Enter the required parameters.
Click the View button.
The BRM Reports package includes brand-configured versions of the following BRM base reports:
Historic Sessions by Session Length brand report
This report is a brand-specific version of the "Historic Sessions by Session Length Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Branding Reports\UsageTimeHistoricB\UsageTimeHistoricB.xdo
General Ledger Summary brand report
This report is a brand-specific version of the "General Ledger Summary Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Branding Reports\GLSummaryB\GLSummaryB.xdo
General Ledger Detail brand report
This report is a brand-specific version of the "General Ledger Detail Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Branding Reports\GLDetailB\GLDetailB.xdo
New Account Lifetime brand report
This report is a brand-specific version of the "New Account Lifetime Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Branding Reports\NewLifetimeB\NewLifetimeB.xdo
Closed Account Lifetime brand report
This report is a brand-specific version of the "Closed Account Lifetime Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Branding Reports\ClosedLifetimeB\ClosedLifetimeB.xdo