1. System Administrator's Guide
  2. Working with Reports

7 Working with Reports

Oracle Communications Unified Inventory Management (UIM) supports Oracle Analytics Server, which is the reporting standard for UIM. Through a downloadable patch, UIM provides sample reports that you can run in Oracle Analytics Server.

Installing and Configuring Oracle Analytics Server

The following sections provide information on installing and configuring Oracle Analytics Server.

This chapter assumes you are familiar with Oracle Analytics Server and its documentation, which is available on the Oracle documentation website:

https://docs.oracle.com/en/middleware/bi/analytics-server/index.html

Installing Oracle Analytics Server

Oracle Analytics Server is not part of UIM Installer. To use Oracle Analytics Server for UIM reporting, you must install it manually. See UIM Compatibility Matrix for information about which versions of Oracle Analytics Server work with this release of UIM.

To install Oracle Analytics Server, follow the instructions in Installing and Configuring Oracle Analytics Server, located here:

https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/installing-product-software.html

Configuring Oracle Analytics Server

After you have successfully installed Oracle Analytics Server, you need to configure it by performing the following tasks:
Getting Started

To get started with configuring Oracle Analytics Server, do the following:

  1. Start the Oracle Analytics Server WebLogic server by following the instructions in Oracle Analytics Server documentation located here:

    https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/start-and-stop-your-system.html

  2. Ensure you have privileges to log in to Oracle Analytics Server as an administrator.

Adding a Data Source and Establishing a Database Connection

To run reports against UIM data using Oracle Analytics Server, you must add UIM as a data source to Oracle Analytics Server and establish a database connection to UIM.

To add a data source and establish a database connection:

  1. Log in to Oracle Analytics Server as an administrator.

  2. Follow the instructions for creating data sources in Administering Oracle Analytics Publisher in Oracle Analytics Server:

    https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/set-data-sources.html

Adding Users

To provide users with view access, Oracle Analytics Server offers several security options.

To add a user and a role, and assign the role to the user:

  1. Log in to Oracle Analytics Server as an administrator.

  2. Determine the security model option to use from the administrator's overview. Follow the instructions for granting permissions in Administering Oracle Analytics Publisher in Oracle Analytics Server, located here:

    https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/configure-users-roles-and-data-access.html

Downloading and Installing the Sample Reports

This section provides information on downloading and installing the UIM sample reports, which are described later in this chapter.

Downloading the Sample Reports

The UIM sample reports are delivered in a separate ZIP file (OASSampleReports.zip), which you can download from the UIM software on the Oracle Software Delivery Cloud:

https://edelivery.oracle.com

Installing the Sample Reports

You can install the sample reports by using one of the following methods:

Copying the ZIP file to the Oracle Analytics Server Repository

To install the sample reports by copying the ZIP file to the Oracle Analytics Server repository:

  1. If you have not already done so, download the sample reports.

    See "Downloading the Sample Reports" for more information.

  2. Open the tempDir/OASSampleReports.zip file.

  3. Extract the OASSampleReports folder to the OAS_HOME/repository/Reports directory.

  4. Log in to Oracle Analytics Server.

  5. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  6. Expand Shared Folders, and select the BIPubReports folder.

    The sample reports are located in the BIPubReports folder.

  7. Change the data model file to point it to the data source you created earlier.

    See "Changing the Data Model Source" for instructions.

Note:

Regarding the Oracle Analytics Server Catalog, files in Shared Folders are accessible to other users, while files in My Folder are user-specific and are not accessible to other users.

Uploading the Sample Reports from within Oracle Analytics Server

To install the sample reports by uploading them from within Oracle Analytics Server:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. Select Shared Folder.

  4. Create a new folder named BIPubReports under Shared Folder.

  5. Select the BIPubReports folder.

  6. Create a new folder named Data Models under BIPubReports.

  7. Select the BIPubReports folder.

  8. Click the Upload Resource icon.

    The Upload dialog box appears.

  9. Click Browse.

    The Choose File to Upload window appears.

  10. Navigate to tempDir/BIPubReports.

  11. Select an XDOZ file and click Open. (These are the report files.)

    The Upload dialog box appears.

  12. Click Upload.

  13. Repeat steps 7 through 12 to upload each XDOZ file.

  14. Select the Data Models folder.

  15. Click the Upload Resource icon.

    The Upload dialog box appears.

  16. Click Browse.

    The Choose File to Upload window appears.

  17. Navigate to tempDir/BIPubReports/Data Models.

  18. Select an XDMZ file and click Open. (These are the data model files.)

    The Upload dialog box appears.

  19. Click Upload.

  20. Repeat steps 14 through 19 to upload each XDMZ file.

    The sample reports are located in the BIPubReports folder.

  21. Change the data model file to point it to the data source you created earlier.

    See "Changing the Data Model Source" for instructions.

Understanding the Sample Reports

This section describes the following sample reports:

See "Running the Sample Reports" for information on how to run the sample reports that are described in the following sections.

Connectivity Report

This report lists available channelized connectivities based on the location provided. Also, based on the selected connectivity, the report shows Channelized Connectivity, its riders, capacity consumed by riders, and the service and party associated with the rider.

When running this report, you select a location or locations from the Location list. The Connectivity list is then populated with channelized connectivities that are present at the selected locations. You can then select a connectivity from the Connectivity list to view its riders.

Connectivity Activation Report for Project Activity

Note:

Within the Oracle Analytics Server Catalog, this report name is listed as Project Activation Report. However, when the report runs, the title of the report is Connectivity Activation Report.

This report provides the activation details to provision the connectivity that has been redesigned as part of a Project Activity that may involve Grooming, Rehoming, Insert Node, or Remove Node operation. This report contains various sections that provide necessary information to provision the changes in the network that have been planned in the inventory project.

You can select project, activity, and impacted connectivity from the respective lists to view Connectivity Activation for a project Activity. Current version and previous versions will be populated automatically.

  • General Information

    This section provides the details about the connectivity and the corresponding Project and Activity that is making changes in the connectivity.

  • Cross-Connect

    This section provides the details of the cross connects needs to be activated or deactivated in the devices to provision the connectivity.

  • Jumper

    This section provides the details of the jumpers needs to be created or removed by the field engineer in the devices to provision the connectivity.

  • Reference

    This section provides the design details the connectivity before and after the completion of the Project Activity. This section is not directly used in the provisioning but rather serves as a reference to see the end to end design of the connectivity and understand what has changed in the project Activity.

When running this report, you select project, activity, and impacted connectivity. Current version and previous versions are automatically populated.

Customer Service Resource Allocation Report

This report shows all services and allocated resources for a particular customer. You select a customer name to initiate the report.

When running the report, you select a customer name.

Customer Services Supported by Logical Device Report

This report shows all services and associated customers for a particular logical device such as router. This report is designed for service impact analysis based on a specific logical device.

When running the report, you select a logical device.

Device Utilization Report

This report shows the capacity consumed for logical devices. It shows logical devices, assigned device interface specifications, and utilization of the device interfaces for a given location or logical device.

When running the report, you enter a location or a device ID, or both.

IPv4 Utilization Report

This report shows all IPv4 networks, subnets, and hosts, and the respective utilization, for a particular IP address domain.

When running the report, you select an IP address domain name.

IPv6 Utilization Report

This report shows all IPv6 networks, subnets, and hosts, and the respective utilization, for a particular IP address domain.

When running the report, you select an IP address domain name.

Pipe Capacity by Terminating Place Report

This report shows pipe capacity information based on the terminating place.

When running the report, you select a terminating place to see all the pipes and their capacity for that place.

Services In Progress Report

This report shows all service instances for a particular service specification where a service configuration is in progress.

When running the report, you select a service specification to show the services in progress.

Telephone Number Reports

A set of predefined utilization reports shows the numbers of telephone numbers within a pre-defined range. These reports can be used to determine which telephone numbers are assigned and which are still available for consumption. In addition, this view provides categorization based on the consumer, such as reservation, assignment, or condition. Below is a description of each report:

  • Utilization Report by 1K Block

    This report shows the number of assigned, reserved, and available telephone numbers for a block of 1,000 numbers. The report also shows the utilization percentage.

    When running the report, you select the telephone number specification to view utilization for the blocks created using that specification.

  • Utilization Report by 10K Block

    This report shows the number of assigned, reserved, and available telephone numbers for a block of 10,000 numbers. The report also shows the utilization percentage.

    When running the report, you select the telephone number specification to view utilization for the blocks created using that specification.

  • Utilization Report for 1K/10K Block by Category

    This report shows the assignment status, reservation type, and condition type for telephone numbers within a block of 1,000 or 10,000.

    When running the report, you select the block to view utilization of the numbers in that block.

  • Utilization Report by Category for Toll Free Numbers

    This report shows the assignment status, reservation type and condition type for toll free numbers.

Running the Sample Reports

To run the sample reports:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. If this is the first time you are running the sample reports, edit the data model to point to a data source. For instructions on how to do this, see "Changing the Data Model Source".

    Note:

    For generating IPv6 sample reports, you must run the BIPubReports\functions.txt file in the database of the UIM data source.

  4. Expand Shared Folders, and select the BIPubReports folder.

  5. Click the Open link for the report you want to run.

    Depending on the report you opened, a list or lists from which to select data appears.

  6. Select data from the list or lists that are present for the report you are running.

  7. Click Apply to apply your data selections and run the report.

    The report appears.

Modifying Existing Sample Reports

You can modify the existing sample reports by:

Any reports you create by modifying the existing sample reports can be run in the same manner as the sample reports. See "Running the Sample Reports" for more information.

Editing Existing Sample Reports

To edit an existing sample report:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. Expand Shared Folders, and select the BIPubReports folder.

  4. Click the Edit link for the report you want to edit.

  5. Edit the report format.

    For detailed information on editing the report format, click the Help icon on this page.

  6. Click the Save icon.

Changing the Data Model Source

To change the Data Model Source:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. Expand Shared Folders.

  4. Expand BIPubReports, and select the Data Models folder.

  5. Click the Edit link for the data model you want to edit.

  6. Click Data Model.

    The Properties page for the selected data model appears.

  7. From the Default Data Source list, select a different data source.

  8. Expand Data Model, and select Data Sets.

  9. Select a data set.

    The Diagram tab for the selected data set appears.

  10. Click the View Actions list menu located in right corner of the data set.

  11. From the View Actions menu, select Edit Data Set.

    The Edit Data Set dialog box appears.

  12. Change Data Source.

  13. Close the Edit Data Set dialog box.

  14. Click the Save icon.

Setting Default Parameter Values

To set default parameter values:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. Expand Shared Folders.

  4. Expand BIPubReports, and select the Data Models folder.

  5. Click the Edit link for the data model you want to edit.

  6. Expand Data Model, and select Parameters.

  7. Select a parameter.

  8. Set or change the value in the Default Value field.

  9. Click the Save icon.

Creating New Reports

You can create a new data model to create a new report. To view example queries when creating new reports, see "Viewing Example Queries".

To create a new report:

  1. Understand the data model entities you intend to use in your custom report.

  2. Log in to Oracle Analytics Server.

  3. In the upper right corner of the Home page, click the New icon, and select Data Model.

    The Properties page for the new data model appears.

  4. From the Default Data Source list, select a data source.

  5. Expand Data Model and select Data Sets.

    The Diagram tab for the selected data set appears.

  6. Click the New Data Set list menu and select SQL Query.

    The New Data Set - SQL dialog box opens.

  7. Do one of the following:

    • Click Query Builder, select the appropriate tables, and build the query to populate the SQL Query field.

    • Copy and paste a pre-written query directly into the SQL Query field.

  8. Click OK to close the New Data Set - SQL dialog box.

  9. Click the Save icon to save the data set.

  10. Click the View Data tab located next to the Save icon.

  11. From the Number of rows to return list, select the number of rows to return.

  12. Click View.

  13. Select Save as Sample Data to save the data.

    The Diagram tab for the new data set appears.

  14. In the upper right corner of the page, click the New icon, then select Report, then select the Using Existing Data Model link.

    The Create Report window appears.

  15. Select the data model and choose Guide Me and then click Next.

  16. Select Page Options as Portrait and Layout as table and then click Next.

  17. From the Available Columns on the left side, select the columns that you want to appear in your report and click Next.

  18. Click Finish and save the report.

  19. To edit the report, click on the Actions icon located in the right corner of the report and select Edit Report.

  20. On the Edit tab, use the listed components to create data tables, bar charts, and so on..

  21. On the Page Layout tab, format your report by specifying portrait or landscape, headers and footers, and so on.

  22. Click the Save icon.

Any custom reports you create can be run in the same manner as the sample reports. See "Running the Sample Reports" for more information.

Viewing Example Queries

You can view the queries from any of the sample reports to use an example to follow when creating custom reports.

To view example queries:

  1. Log in to Oracle Analytics Server.

  2. In the upper right corner of the Home page, click the Catalog link.

    The Catalog appears.

  3. Expand Shared Folders.

  4. Expand BIPubReports, and select the Data Models folder.

  5. Click the Edit link for the applicable data model.

  6. Expand Data Model, and select Data Sets.

  7. Select a data set.

    The Diagram tab for the selected data set appears.

  8. Click the View Actions list menu located in right corner of the data set.

  9. From the View Actions menu, select Edit Data Set.

    The Edit Data Set dialog box appears, showing the query.

Troubleshooting Oracle Analytics Server

Refer to the Oracle Analytics Server forum for troubleshooting information:

https://community.oracle.com/tech/developers/categories/oracle-analytics-server