My Oracle Support Banner

Quick reference to Oracle Utilities Analytics (OUA) 2.7.0.1. Customers to upgrade from Oracle Business Intelligence Enterprise 12c to Oracle Analytics Server on Linux (Doc ID 2677251.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and later
Linux x86-64

Details

 **Examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:
OUA - Oracle Utilities Analytics
OBIEE - Oracle Business Intelligence Enterprise Edition
OAS - Oracle Analytics Server

 

Applies To

Oracle Utilities Analytics (OUA) 2.7.0.1 customers.

Purpose

This document describes, with reference to the Oracle Analytics Server (OAS) documentation, the steps to upgrade the OBIEE 12.2.1.4 technology, used with OUA 2.7.0.1, to OAS 5.5.0

Prerequisites

Upgrading from Oracle Business Intelligence to Oracle Analytics Server 5.5.0 requires careful preparation, planning, and testing. Please read the Migrating and Upgrading to Oracle Analytics Server document, in its entirety, before starting the exercise.

Upgrade Paths

OUA 2.7.0.1 customers have perform their OBIEE 12.2.1.4 upgrade to OAS in-place or via a fresh install.

In place upgrade to OAS

This option involves upgrading the existing OBIEE installation in the OUA environment. This would retain all of their configuration settings and OBIEE artifacts as-is.

 

Upgrade to OAS via fresh install

              This option involves setting up the OAS installation separate from the existing OBIEE installation. This will come in handy if customers cannot afford downtimes in their existing OUA environment. This option would require that the configuration settings, from the OBIEE environment to be redone in OAS. It also requires migrating BI metadata artifacts from OBIEE to OAS.

 The steps for each upgrade path are described below.

 

 

Actions

 

In Place upgrade to OAS

  1. Follow the instructions on how to upgrade from OBIEE 12.2.1.4 to OAS on Linux as described in the OAS document Migrating and Upgrading to Oracle Analytics Server
  2. OUA utilizes the OBIEE Write Back template functionality to enable users to update some configurations and make some label related changes back to the database. The UI screens for these are available as part of the OUA Administration dashboards. Write Back template is an xml file which takes user inputs and writes it directly to the database using SQL commands. They are stored $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages in the directory. Identify the below Write Back template files in the older location $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages

 

  1. Base_Field_Update_Template.xml
  2. Configuration_Update_Template.xml
  3. Custom_Field_Delete_Template.xml
  4. Custom_Field_Insert_Template.xml
  5. Custom_Field_Update_Template.xml
  6. ETL_Job_Control_Update_Template.xml
  7. Map_Profile_Update_Template.xml

 

The location to store the Write Back template files in OAS is different from OBIEE.  Therefore copy the template files to the OAS location at $DOMAIN_HOME/bi/bifoundation/web/msgdb /l_en/custommessages/. Restart the OAS services once the above write back templates are deployed.

 

Upgrade to OAS via fresh install

  1. Follow the instructions on Installing and Configuring Oracle Analytics Server
  2. After installing and configuring OAS, migrate the BI Application Archive (BAR File) from OBIEE to OAS. BAR files are the compressed archive file that contains a cohesive set of BI metadata artifacts (data model, content model, and authorization model). For more information on BAR files, refer BAR file. Follow the instructions to export and import BAR file in OAS.
  3. To complete the installation of the OUA dashboard components in OAS it is necessary to configure MapViewer and enabling Write Back. Follow the instructions in the OUA 2.7.0.1 Installation Guide, Chapter 4: Installing Oracle Utilities Analytics - Initial Installation, the section on Installing Oracle Utilities Analytics Dashboards Component :  

a.    Section Configuring and Deploying the MapViewer
b.    Section Updating MapViewer Configuration
c.    Section Enabling WriteBack

4. OUA utilizes the OBIEE Write Back template functionality to enable users to update some configurations and make some label related changes back to the database. The UI screens for these are available as part of the OUA Administration dashboards. Write Back template is an xml file which takes user inputs and writes it directly to the database using SQL commands. They are stored $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages in the directory. Identify the below Write Back template files in the older location $DOMAIN_HOME/ bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages

  1. Base_Field_Update_Template.xml
  2. Configuration_Update_Template.xml
  3. Custom_Field_Delete_Template.xml
  4. Custom_Field_Insert_Template.xml
  5. Custom_Field_Update_Template.xml
  6. ETL_Job_Control_Update_Template.xml
  7. Map_Profile_Update_Template.xml

 

The location to store the write Back template files in OAS is different from OBIEE.  Therefore copy the template files to the OAS location at $DOMAIN_HOME/bi/bifoundation/web/msgdb /l_en/custommessages/. Restart the OAS services once the above write back templates are deployed.

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Applies To
 Purpose
 Prerequisites
 Upgrade Paths
Actions
 In Place upgrade to OAS
 Upgrade to OAS via fresh install
Contacts

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.