Install Dashboards Component

This page describes the installation process for the Oracle Utilities Analytics Warehouse (OUAW) Dashboards component.

Prerequisites

Before you begin installing the OUAW Dashboards component, verify the following:

  • Ensure that the Oracle Analytics Cloud (OAC) is provisioned and running.

See Perform Pre-Installation Steps for OUAW for more information.

Download OUAW ETL Component

  1. Download Oracle Utilities Analytics Warehouse v25.10.0.0 PaaS Multiplatform zip from edelivery to your local system from where you can access OAC Analytics URL.

  2. After unzipping the package, you will get these folders:
    • ETL Component
    • AdminTool Component
    • Dashboard Component
    The Dashboard Component folder contains all the Dashboard Installation files and these folders:
    • catalog
    • rpd
    • WriteBackTemplates

Deploy the Web Catalog

  1. Log in to the Oracle Analytics Cloud Analytics URL: https://<OAC URL>/ui/analytics.

  2. Click Catalog.


    Select the Catalog tab.

  3. Select Admin View and select the Show Hidden Items checkbox.


    Select Admin View then Show Hidden Items.

  4. Under the Catalog Root folder, select Shared Folders and navigate to Unarchive.

    Click Browse, search for Catalog File and click OK.


    Search for the Catalog file.

    Note:

    Repeat the steps for each Catalog file except for Spatial Metadata.Catalog.

  5. To deploy Spatial Metadata.Catalog, select System Folders and navigate to Unarchive.

    Click Browse, search for Catalog File and click OK.


    Search for the Spatial Metadata catalog.

  6. Verify all the deployed catalogs in the Dashboard tab.


    Verify deploy catalogs in the Dashboard tab.

Apply Dashboard Single Fix

  1. Download OUAW 25.10.0.0.0 PaaS Single Fix (Patch 38976085) from My Oracle Support and unzip it.

  2. Copy the Dashboard Component folder to your system. You will get four catalogs in the Catalog folder.
    • Credit & Collections Analytics.Catalog
    • Customer Analytics.Catalog
    • Meter Data Analytics.Catalog
    • Revenue Analytics.Catalog

  3. Log in Oracle Analytics Cloud Analytics and navigate to Catalog.

  4. Select the existing uploaded Credit & Collections Analytics, Customer Analytics, Meter Data Analytics, and Revenue Analytics catalogs and click Delete.


    Select and delete existing uploaded analytics catalogs.

  5. Click OK to confirm deletion of the selected catalogs.

  6. Deploy the Single Fix catalogs by performing the steps from Deploy the Web Catalog.

Deploy the Repository (RPD) File

Create Connections in OAC

  1. Log in to the Oracle Analytics Cloud Data Visualization URL: https://<OAC URL>/ui/dv.

  2. Click Create then Connection.


    Create a connection.

  3. Set the Select Connection Type.

    Field Name and Description Value

    Oracle Autonomous Data Warehouse

    For ADB (Target database)
    Oracle Database For Source database

  4. Provide the Connection details to create the DWREAD user then click Save.

    Field Name and Description Value

    Connection Name

    DWREAD
    Connect Using Basic
    Encryption Type Mutual TLS
    Client Credentials Select ADB Wallet zip file from your local system
    Username DWREAD
    Password <DWREAD Password>
    Service Name Select ADB service name
    System Connection Select this checkbox
    Authentication Select "Always use these credentials"

    Example


    DWREAD Connection Details Example

  5. Provide the Connection details to create the DWUSER user then click Save.

    Field Name and Description Value

    Connection Name

    DWUSER
    Connect Using Basic
    Encryption Type Mutual TLS
    Client Credentials Select ADB Wallet zip file from your local system
    Username DWUSER
    Password <DWUSER Password>
    Service Name Select ADB service name
    System Connection Select this checkbox
    Authentication Select "Always use these credentials"

    Note:

    Create connection for CISUSER user for MDM Source with connection type Oracle Database.

  6. Select the Connections tab to view all the created connections.


    View all created connections.


    View all created connections.

  7. Find the Object IDs for each connection by navigating to OAC DV Console > DATA > Connections > Select the Connection > inspect and right click Object ID then click Copy.


    Find and copy Object ID of each connection.

Deploy RPD

  1. Take the Utilities Business Analytics RPD file (UtilitiesBusinessAnalytics.rpd) backup from the OUAW PaaS Dashboards component, rpd folder.

  2. Install the latest Oracle Analytics Client Tools from Oracle Technology Network and install it on the Windows machine.

  3. Click Start > Programs > Oracle Analytics Client Tools > Model Administration Tool.

  4. Click File > Open > Offline... to open the RPD in offline mode.

  5. Provide the RPD password. The default password is “oracle123”.

  6. In the Oracle BI Administration Tool, go to the Physical pane and expand the tree.

    The tool shows three sections in parallel columns: Presentation, Business Model and Mapping, and Physical, in that order.

  7. Double-click Init Block Connection Pool and enter the following:

    Field Name and Description Value

    Data source name

    Give any name
    Username DWREAD
    Password DWREAD User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'DWREAD'


    Enter the Init Block Connection Pool details.

  8. Double-click Init Block Pool - MDM and enter the following (only for Oracle Utilities Meter Data Management):

    Field Name and Description Value

    Data source name

    MDM database name
    Username CISUSER
    Password CISUSER User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'CISUSER'

  9. Double-click Materialized Views Connection and enter the following:

    Field Name and Description Value

    Data source name

    Give any name
    Username DWREAD
    Password DWREAD User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'DWREAD'

  10. Double-click MDM Database Connection and enter the following (only for Oracle Utilities Meter Data Management):

    Field Name and Description Value

    Data source name

    Give any name
    Username CISUSER
    Password CISUSER User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'CISUSER'

  11. Double-click NMS Replication Tables and enter the following (only for Oracle Utilities Network Management System):

    Field Name and Description Value

    Data source name

    Give any name
    Username DWREAD
    Password DWREAD User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'DWREAD'

    Note:

    If the replication schema name is different, then rename it to the actual value.


    Enter the NMS Replication Tables details.

  12. Double-click ODIDEV Connection and enter the following:

    Field Name and Description Value

    Data source name

    Give any name
    Username DWREAD
    Password DWREAD User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'DWUSER'

  13. Double-click Oracle Data Warehouse OUBI Database Connection and enter the following:

    Field Name and Description Value

    Data source name

    Give any name
    Username DWREAD
    Password DWREAD User password
    Use Data Connection Select this checkbox
    Object ID 'system'.'DWREAD'
  14. Click File and then click Save the changes. Click Yes when you see the prompt "Do you wish to check global consistency?" Ignore any warnings that appear after the consistency check is complete.

  15. Log in to Oracle Analytics Cloud Data Visualization URL and navigate to Console > Snapshots.


    Log in to Snapshots.


    Log in to Snapshots.

  16. Under More Actions, select Replace Data Model.


    Select Replace Data Model option.

  17. Upload the RPD file, provide "oracle123" as the password and click Replace then OK.


    Upload RPD file to replace data model.

Deploy Writeback Templates

  1. Log in to OCI Oracle Analytics Cloud Data Visualization URL : https://<OAC URL>/ui/dv.

  2. Navigate to Console and select Advanced System Settings.


    Select the Advanced System Settings option.

  3. Add the contents of Writeback_Templates.xml found under the WriteBackTemplates folder which is unzipped from Oracle Utilities Analytics Warehouse v25.10.0.0 PaaS Multiplatform zip to the Writeback Template XML block and wait for few second and Property will be updated automatically.


    Add writeback template contents.

    Note:

    • The writeback feature is applicable only for Base Field Maintenance & Custom Field Maintenance dashboards which updates/inserts/deletes the records from DWADM.B1_MD_FLD table.
    • Any updates which are to be performed from Configuration Dashboard, that is to update the data in DWADM.B1_CONFIGURATION table could be performed directly from database.

Enable the Autocomplete Feature in Oracle Analytics Cloud

  1. Log in to the Oracle Analytics Cloud Analytics URL: https://<OAC URL>/ui/analytics.

  2. Click the User profile icon in the top right section of the page.
  3. From the drop-down menu, select My Account.

  4. On the Preferences tab, set Prompt AutoComplete to ON.

  5. Click OK.


Enable Autocomplete Feature

Enable WriteBack

  1. Log in to the Oracle Analytics Cloud Analytics URL: https://<OAC URL>/ui/analytics.

  2. Click the Profile icon in the top right corner of the screen and click Administration then Manage Privileges.


    Select the Manage Privileges option.

  3. In the Manage Privileges area, in the Write Back > Write Back to Database row, click Authenticated User. In the dialog box that displays, click the menu in the Permissions column and select Granted from the drop-down menu then click OK.


    Manage Writeback to Database Privileges

  4. Restart OAC from the OCI Console.


    Restart Oracle Analytics Cloud.