Installing the Oracle BI Publisher Report Packages
The Oracle Utilities Network Management System product configuration has a packaged version of Web Switching and Work Agenda reports that may be used to email, preview, and print switching sheets, safety documents, Miscellaneous Log, and Work Agenda call reports. The package is delivered in the nms_configuration.zip file, which extracts to the following folders:
• $NMS_CONFIG/jconfig/ops/bi_publisher/WebSwitching
• $NMS_CONFIG/jconfig/ops/bi_publisher/WebSwitchingImpactedCustomers
• $NMS_CONFIG/jconfig/ops/bi_publisher/WorkAgenda
Each folder contains files that must be uploaded to the BI Publisher Catalog. The next set of steps will guide you through this process.
Installation
When configuring BI Publisher for multiple environments, the CES_PARAMETER WEB_bipub.reportFolder will need to have a unique setting on each of the NMS environments.
Installation Steps
1. Log into BI Publisher (http://<BIP server name>:9704/xmlpserver/) as the Administrator from a browser that has access to the WebSwitching and/or WorkAgenda folder that was extracted from the nms_configuration.zip file. The WebSwitching or WorkAgenda folder can be copied from their default installation directory to a PC of your choice.
2. Set up a database connection by going to the Oracle BI Publisher Administration page, navigating to the JDBC Connection page under the Data Sources section, and then click Add Data Source.
3. In the Name field, enter <reportFolder> (i.e., the value of the WEB_bipub.reportFolder parameter).
4. Set the Driver Type to Oracle 9i/10g/11g.
5. Set the Database Driver Class to oracle.jdbc.OracleDriver.
6. Set the Connection string to:
jdbc:oracle:thin:@<your machine>:1521:<the ORACLE_SID>
jdbc:oracle:thin:@<your machine>:1521:<the ORACLE_SID>
7. Set the username and password to match your Oracle Utilities Network Management System database login values.
8. Click Test Connection and verify that it is properly configured.
9. Click Apply.
10. The following steps are needed when using BI Publisher 12c:
If the Administration Superuser has not been specified in BI Publisher, then the following steps will need to be completed before reports can be uploaded into the BI Publisher environment.
• Select the Administration button at the top of the page.
• Select the Security Configuration link.
• Click Enable Local Superuser.
• Enter the user and password you are logging in as to do the report uploads and alterations.
• Restart BI Publisher to apply the changes.
Complete the following steps for uploading the report files.
11. From the BI Publisher Catalog page, select Shared Folders from the folders tree.
12. On top of the folders section, click the New drop down and select Folder from the list.
13. In the Folder Name field, enter <reportFolder> (i.e., the value of the WEB_bipub.reportFolder parameter).
14. Click Create. The new <reportFolder> folder will be added to the Folders list. You may have to click the toolbar Refresh button to update the Folders list.
15. Select the <reportFolder> folder in the Folders list.
16. In the Tasks section on the bottom left of the page, click Upload.
17. Browse to the WebSwitching report package folder that was extracted from the nms_configuration.zip file and upload the WebSwitching.xdrz archive.
Note: When replacing existing reports, select the Overwrite existing report option followed by the Upload button.
18. Select the Shared Folders/<reportFolder>/WebSwitching folder in the Folders list.
19. To the right of the Folders list on the Catalog page, select the Edit link for the NMS Data Model item.
20. Select Properties at the top of the Data Model tree.
21. Change the ‘Default Data Source’ from WebSwitching to the data source you created in step 3. The data source should have the same name as your <reportFolder> parameter.
22. Click the save button at the top right to save your changes.
23. Select the Catalog link at the top of the Catalog page to navigate back to the package view.
24. To the right of the Folders list on the Catalog page, select the Edit link for the Templates item. From the toolbar, change the data model to the newly modified NMS Data Model. You do this by selecting the Select Data Model button (
) found on the toolbar. From the Select Data Model dialog, select the NMS Data Model entry from the Shared Folders/<reportFolder>/WebSwitching folder and click Open.
) found on the toolbar. From the Select Data Model dialog, select the NMS Data Model entry from the Shared Folders/<reportFolder>/WebSwitching folder and click Open.25. Repeat steps 15-24, replacing WebSwitching with WorkAgenda.
26. Repeat steps 15-24, replacing WebSwitching with WebSwitchingImpactedCustomers.
You should now be able to preview and print reports from the Web Switching and Work Agenda applications. If you have made any changes to the WEB_bipub CES_PARAMETERS parameters, then a restart of WebLogic will be required before the reports can be used by NMS.