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 MAY 01, 2023

Applies to:

Details

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

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