Install Network Management System BI Publisher Reports

The Oracle Utilities Network Management System (NMS) BI Publisher tool can be used to generate outage reports that support metrics recommended by the Institute of Electrical and Electronics Engineers (IEEE). Follow the steps below to install the Oracle Utilities Analytics Warehouse (OUAW) NMS IEEE outage reports.

Prerequisites:

  1. Download the Oracle Utilities Analytics Warehouse NMS BI Publisher reports.zip file from edelivery.oracle.com.

  2. Make sure the BI Publisher server state is running.

To install OUAW NMS IEEE outage reports:

  1. Unzip the IEEE outage reports contained in Oracle Utilities Analytics Warehouse NMS BI Publisher reports.zip from the installation media to a temporary directory (example: TEMPDIR) on the server where Oracle BI Publisher is installed. The following directories appear after the unzip:

    • CELID

    • CEMI

    • DailyTroubleReport

    • DeviceOutageHistory

    • FeederImpactOnSystemMetrics

    • IEEE Benchmarking

    • IEEE TMED

    • IEEEIndiceCalculations

    • RecurringDeviceOutages

  2. Log in to Oracle BI Publisher (http://<BI Publisher server name>:<9502>/xmlpserver/) as an administrator from a browser that has access to the TEMPDIR folder from step 1. 
  3. Set up a database connection.
    1. Navigate to Oracle BI Publisher Administration > Data Sources > JDBC Connection.
    2. Click Add Data Source.
    3. In the Data Source Name field, enter NMS BI Publisher or a name of your choice.
    4. Set the Driver Type to Oracle 12c.
    5. Set the Database Driver Class to oracle.jdbc.OracleDriver.

    6. Set the Connection string to:

      jdbc:oracle:thin:@<yourmachine>:<Port>/<ORACLE_SID>

      7. Note: The database connection referring to OUA has to be set up here.

    7. Use the same username and password as you do to log in to the Oracle Utilities Analytics database.

      8. Note: Use the username MDADM and its respective password.

    8. Click Test Connection and verify the configuration.
    9. Click Apply.
  4. From the BI Publisher Catalog page, select Shared Folders from the folders tree. 
  5. At the top of the folders section, search the New drop-down list and select Folder.
  6. Enter NMS IEEE Reports as the folder name (or a name of your choice).
  7. Click Create. The new folder is added. You may have to click Refresh to update the Folders list.
  8. Select the NMS IEEE Reports folder in the folder list, and create another new folder within it named NMS IEEE Data Models.
  9. Select the NMS IEEE Data Models directory, and then click Upload in the Tasks section on the bottom left.
    1. Browse to the directory where the NMS IEEE BI Publisher reports exist (TEMPDIR from step 1, which contains the files listed below in the corresponding directories).
    2. Locate all of the data model files and upload them to the NMS IEEE Data Models directory. These files contain the xdmz extension and include the following:
      • CELID DataModel.xdmz
      • CEMI Data Model.xdmz
      • DailyTroubleReport.xdmz
      • DeviceOutageHistory.xdmz
      • Feeder Impact on System Metrics.xdmz
      • IEEE Benchmarking Model.xdmz
      • IEEE_TMED_Calculations.xdmz
      • IEEEIndiceCalculations.xdmz
      • RecurringDeviceOutages.xdmz 
  10. Select the NMS IEEE Reports directory and click Upload in the Tasks section.
    1. Browse to the directory where the OUA NMS IEEE BI Publisher reports exist (TEMPDIR from step 1, which contains the files listed below in the corresponding directories).
    2. Locate all of the report files and upload them to the NMS IEEE Reports directory. These files contain xdoz extension and include the following:
      • CELID DataModel.xdoz
      • CEMI Data Model.xdoz
      • DailyTroubleReport.xdoz
      • DeviceOutageHistory.xdoz
      • Feeder Impact on System Metrics.xdoz
      • IEEE Benchmarking Model.xdoz
      • IEEE_TMED_Calculations.xdoz
      • IEEEIndiceCalculations.xdoz
      • RecurringDeviceOutages.xdoz
  11. Assign the appropriate JDBC connection to the imported data models.
    1. Click Catalog.
    2. Select the NMS IEEE Data Models directory and select the CriticalCustomerOutages.xdmz data model.
    3. Click Data Model on the top left.
    4. In the Properties frame on the right, make sure that the Default Data Source points to the data source you created earlier. This defaults to NMS BI Publisher.
    5. You must perform this step for all of the data models under the NMS IEEE Data Models directory.

  12. Assign the appropriate data model to all of the NMS IEEE Reports.

    1. Click on Catalog.
    2. Select the NMS IEEE Reports directory. Click on Edit for the CriticalCustomerOutages report.
    3. Click on Search on the top left of the page.
    4. Browse and select the appropriate data model file (it will have the name of the report with an extension of xdmz).
    5. Save the current report by clicking on Save on the top right of the page.

You should now be able view the standard IEEE indices reports from BI Publisher by simply selecting the desired report from the NMS IEEE Reports directory under Catalog.

Back to Top