X

The Oracle BI Application Blogs provides the latest and tips and tricks on Oracle BI Applications Product (OBIA)

BICS Lift and Shift of BIAPPS Content

Authors: Anand Sadaiyan, Swathi Singamareddygari

Table of Contents

Disclaimer

Section 1: RPD Lift and shift

Section 2: Application Roles Lift and shift

Section 3: Webcat Lift and shift

Section 4: Using RDC to connect to ON-PREM oracle database

Section 4 .1: Troubleshooting BI Cloud Service RDC

Section 5: Limitations


Disclaimer

This document does not replace the Oracle Business Intelligence Cloud Service Documentation Library or other Cloud Services documents. This document serves as a supplement for doing Lift and Shift of BIAPPS Content to BICS. This document is written based on the BI cloud version 16.3.6.0.0. GUI screenshots shown in the document might differ from the actual Interfaces

 

Section 1: RPD Lift and shift:

Note: It is always a good practice to take a snapshot of the Current environment in BICS, before doing Lift and Shift. So that in any case, if any issue happens, we can restore to the previous working version. 

Overview:

Administrators can upload data models built with Oracle BI Enterprise Edition to Oracle BI Cloud Service. After uploading a data model file (.rpd) to the cloud, content authors can build reports in the usual way. Any modifications to the uploaded RPD should be done in the Local environment.No modifications are allowed in the BICS. Provisioned RPD can be obtained from Compute environment 

For ex. /u01/app/oracle/middleware/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository
in the compute node.

Modify Database as a Service listener.ora to use SID as Service :

If you chose an Oracle 12c Database as a Service, for the Database as a Service connection to work with BI Cloud Service you must add the following line to Database as a Service listener.ora configuration (where “listener” is the name of your listener) and restart the TNS listener: USE_SID_AS_SERVICE_LISTENER=on

More information can be found here.

Steps to be followed for RPD Lift and shift:

1. Login to the BICS environment

2. Navigate to console from the home page and click on snapshots and models.

3. Replace the BICS data model with ON-PREM RPD using “Replace Data model” option and provide the Password for ON-PREM RPD.

 

 

4. Verify the Uploaded RPD by Navigating to Analyses. By clicking “Create Analysis”, all the available Subject Areas are displayed.

5. For more details on RPD LIFT on Shift please refer to Uploading an On-Premises Data Model to Oracle BI Cloud Service

Section 2: Application Roles Lift and shift:

Steps to be followed for uploading the App roles:

1. From the BICS home page navigate to console and click on snapshots and models.
2. Upload the delivered Application Roles bar file by clicking on Upload Snapshot

3. Choose the delivered “obia_bics.bar” file and choose the password as “Admin123”

4. For more details on uploading a snapshot refer Uploading snapshots .

5. Select the uploaded snapshot and click on restore button (check only application roles) to restore the snapshot for application roles.

6. For more details on restoring a snapshot refer Restoring snapshots .

7. Verify the imported application roles which are available under “Users and Roles”-> “Application Roles”.

Section 3: Webcat Lift and shift:

Administrators can upload content from another Oracle BI Cloud Service or Oracle BI Enterprise Edition 11.1.1.9.0 or later. On a high level, following activities will be performed

Replace /shared to /company_shared in webcat available in the compute node.

1) Archive and UnArchive to a temp folder in BICS environment

2) From Temp folder, move the content to Company Shared.

In Compute node

1. Zip the webcat available in the compute node (Ex. OBIEE_HOME/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog) and copy to different path.

2. Unzip the webcat file in the compute node.

3. Invoke the catalog manger by using the command ./runcat.sh which is available in the path : OBIEE_HOME/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager)

4. Then catalog manager will get opened

5. Now open the unzipped webcat through this catalog manager in offline mode.

6. Expand the tree structure in the left pane.

7. Select shared and click on “XML search and replace” available under Tools.

8. In the “XML Search/Replace” window give “/shared” in the old text and “/company_shared” in the new text as shown below and click ok.

9. After replacing, Items changed window will be shown as below.

10. Archive the shared folder by selecting the shared folder and clicking File -> Archive.

 

11. Once archiving is done login to the BICS instance and follow the steps given below

BICS Environment

1. Login to BICS Environment

2. Navigate to catalog from home page

3. Under “company shared” create a temporary folder. In the example below, we have used “temp”, it can be any name of your choice.

4. Expand company shared and select temp folder created in step 3.

5. Select Un-archive option available in the Tasks pane and browse to the archive file created in the step 6.

 

6. Once archiving is done navigate to “temp\Shared Folders” and select any functional area folder like “Human Capital management” and click on copy available in the Tasks section.

7. Now select Company Shared folder and click on paste.

8. We can observe that Human Capital Management folder will get copied under Company shared.

9. Repeat Steps 6 and 7 to copy all the folders to Company shared folder.

10. Click on dashboard menu then we will be able to see all the dashboards 

11. Click on any dashboard and check for results.

 

 

Section 4: Using RDC to connect to ON-PREM oracle database:

Overview :

The Oracle BI Applications use Variables/Initialization Blocks which require a connection to source OLTP (i.e. E-Business Suite, PSFT) databases in order to execute SQL queries, in order to achieve this in the Cloud deployment we will use a new BI Cloud Service feature Remote Data Connector (RDC).

 

Perform the following steps:

 

1. Download Oracle BI Cloud Service Remote Data Connector.

2. Deploy the RDC in ON-PREM weblogic server follow the installation and configuration steps in the Configuring the Remote Data Connector (RDC) for BI Cloud Service (BICS)

3. Create a data source pointing to ON-PREM OLTP db in weblogic server.

4. Copy the Public Key from BICS and paste in WLS “<domain_home>/webcenter/rdc_keys/obi-remotedataconnector”

5. Use 12C BI Admin tool, “Load Java Datasources” and provide the On-Prem WLS Connection details and test the connectivity.

6. Modify the OLTP connection in the RPD to use JDBC (JNDI). Able to see JDBC (JNDI) interface only when step 7 followed and the connection is successful.

 

Section 4 .1: Troubleshooting BI Cloud Service RDC

 

For the latest troubleshooting information please consult the BICS RDC team.

Oracle BI Administration tool Errors

Unable to see "JDBC (JNDI)" in Oracle BI Administration tool 12c, after loading Java datasources.

Close the Oracle BI Administration tool and re-open it. Do not open the Repository in the Administration tool. Load the Java Datasources first, then open the Repository.

"Load Java Datasources" fails OR "401--Unauthorized" when visiting /obiee/javads?status

Check the URL. Make sure that the WebLogic username and password is correct. Disable RDC's Metadata security by running the following in the same shell as the one starting WebLogic:

Linux: export DISABLE_RDC_METADATA_SECURITY=1

Windows: set DISABLE_RDC_METADATA_SECURITY=1

Unable to import tables/check number of rows in Oracle BI Administration tool. Getting "401--Unauthorized" error when trying to do so.

RDC is not designed to allow access through Oracle BI Administration tool. This is for security reasons. The Repository should be created without using RDC (connecting directly via ODBC, or by other means), then Connection Type should be switched to "JDBC (JNDI)". Make sure you switch to the "Miscellaneous" tab after switching to "JDBC (JNDI)" connection type. After these changes the Repository is ready for uploading to BICS.

BI Cloud Service Errors

Query fails with "401--Unauthorized error":

1. Make sure you have copied public key obtained from BI Cloud Service to $DOMAIN_HOME/rdc_keys/<deployment_name>/oracle_bics_rdc.pem

· Here $DOMAIN_HOME is WebLogic's Domain Home. <deployment_name> is generally name of the WAR file without the ".war" extension. For example, if you deployed obi-remotedataconnector.war, deployment name by default is obi-remotedataconnector.

2. Another issue could be that you didn't visit the "Miscellaneous" tab after switching the connection to JDBC (JNDI). Open the Oracle BI Administration tool, switch to miscellaneous tab of the connection pool, and then press OK. Here "Use SQL over HTTP" should be "true". 

Query fails with "Unknown Call Interface JDBC (JNDI)":

1. Make sure you don't have other Connection Pools that also use JDBC (JNDI), but pointing to incorrect URL. All JDBC (JNDI) connections should be through valid URLs.

2. Also, before uploading the Repository, user should switch to the Miscellaneous tab in each JDBC (JNDI) connection pool within Oracle BI Administration tool and then save. The best way to check if everything is good is to follow the steps below: 

a. open the Repository (if already open, close and reopen)
b. right click on the connection pool 
c. "Copy"  Paste in a notepad window
d. Each Connection Pool having JDBC (JNDI) type should have 'use.sql.over.http'='true' in the PROPERTIES section within the text that was copied.

3. A known bug prevents JDBC (JNDI) connections from going through when using a non-working URL in the Repository. This happens even if the Repository is updated with the correct URL later. Make sure you have the correct, working URL before uploading the Repository.

Section 5: Limitations

  1. Webcat lift and shift doesn’t carry forward the webcat permissions. It will be available in the upcoming releases.
  2. Multi Currency is not supported in the Current version and it will be available in the upcoming releases
  3. Following features which are used in BIAPPS are not supported in BICS environment
    a. Condition

    b. Group
    c. KPI
    d. KPI Watchlist
    e. List Format

    f. Segment
    g. Scorecard

Name

Path

Signature

Specific Period Condition

/shared/Customer Relationship Management/Service/Role Dashboards
Content/Service Executive/Common Reports/Specific Period Condition

Condition

Trailing Days Condition

/shared/Customer Relationship Management/Service/Role Dashboards
Content/Service Executive/Common Reports/Trailing Days Condition

Condition

All Groups

/shared/Human Capital Management/_filters/Human Resources -
Workforce Deployment/Role Dashboards/All Groups

Group

Below Top Performance

/shared/Human Capital Management/_filters/Human Resources -
Workforce Deployment/Role Dashboards/Below Top Performance

Group

Global

/shared/Human Capital Management/_filters/Human Resources -
Workforce Deployment/Role Dashboards/Global

Group

Top Performers

/shared/Human Capital Management/_filters/Human Resources -
Workforce Deployment/Role Dashboards/Top Performers

Group

Average Negotiation Cycle Time

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Average
Negotiation Cycle Time

KPI

Fulfilled Requisition Lines past expected date

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Fulfilled
Requisition Lines past expected date

KPI

Late Receipts

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Late
Receipts

KPI

Processed Requisition Lines past expected date

/shared/Procurement/Procurement Scorecard/KPIs/Customer/Processed
Requisition Lines past expected date

KPI

Procurement Cycle Time

/shared/Procurement/Procurement
Scorecard/KPIs/Customer/Procurement Cycle Time

KPI

Unfulfilled Requisition Lines past expected date

/shared/Procurement/Procurement
Scorecard/KPIs/Customer/Unfulfilled Requisition Lines past expected date

KPI

Off-Contract Spend

/shared/Procurement/Procurement
Scorecard/KPIs/Financial/Off-Contract Spend

KPI

Perfect invoices

/shared/Procurement/Procurement Scorecard/KPIs/Financial/Perfect
invoices

KPI

Realized Cost Savings

/shared/Procurement/Procurement
Scorecard/KPIs/Financial/Realized Cost Savings

KPI

Invoice Automation

/shared/Procurement/Procurement Scorecard/KPIs/Operations/Invoice
Automation

KPI

Manual Requisition Lines Rate

/shared/Procurement/Procurement Scorecard/KPIs/Operations/Manual
Requisition Lines Rate

KPI

PO Transactions per Buyer

/shared/Procurement/Procurement Scorecard/KPIs/Operations/PO
Transactions per Buyer

KPI

Processed Negotiation Lines

/shared/Procurement/Procurement
Scorecard/KPIs/Operations/Processed Negotiation Lines

KPI

# of Suppliers per Category

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/# of
Suppliers per Category

KPI

% of Spend By Diversified Suppliers

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/% of
Spend By Diversified Suppliers

KPI

On-Time Delivery performance

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/On-Time
Delivery performance

KPI

Quality Performance

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/Quality
Performance

KPI

Returns

/shared/Procurement/Procurement Scorecard/KPIs/Supplier/Returns

KPI

Exact Match Rate

/shared/Supply Chain Management/Analytic Library/Embedded
Content/Logistics/KPIs/Exact Match Rate

KPI

Hit/Miss Accuracy

/shared/Supply Chain Management/Analytic Library/Embedded
Content/Logistics/KPIs/Hit\/Miss Accuracy

KPI

Inventory Value

/shared/Supply Chain Management/Analytic Library/Embedded
Content/Logistics/KPIs/Inventory Value

KPI

Average Change Order Approval Time

/shared/Supply Chain Management/Analytic Library/Embedded
Content/PIM/KPIs/Average Change Order Approval Time

KPI

Average Change Order Cycle Time

/shared/Supply Chain Management/Analytic Library/Embedded
Content/PIM/KPIs/Average Change Order Cycle Time

KPI

Average New Item Creation Approval Time

/shared/Supply Chain Management/Analytic Library/Embedded
Content/PIM/KPIs/Average New Item Creation Approval Time

KPI

Average New Item Creation Cycle Time

/shared/Supply Chain Management/Analytic Library/Embedded
Content/PIM/KPIs/Average New Item Creation Cycle Time

KPI

Percentage of Shared Categories

/shared/Supply Chain Management/Analytic Library/Embedded
Content/PIM/KPIs/Percentage of Shared Categories

KPI

List Export - Contacts Example

/shared/Marketing/Segmentation/List Formats/Siebel List
Formats/List Export - Contacts Example

List Export

Suspect Sync Segment

/shared/Marketing/Segmentation/Segments/Suspect Sync Segment

Segment

Automate Invoice Processing

/shared/Procurement/Procurement Scorecard/Automate Invoice
Processing

Scorecard Initiative

Consolidate Supplier Base

/shared/Procurement/Procurement Scorecard/Consolidate Supplier
Base

Scorecard Initiative

Develop and Implement New policies to support Contract
compliance

/shared/Procurement/Procurement Scorecard/Develop and Implement
New policies to support Contract compliance

Scorecard Initiative

Establish and Monitor SLAs

/shared/Procurement/Procurement Scorecard/Establish and Monitor
SLAs

Scorecard Initiative

Implement Internet Supplier Portal

/shared/Procurement/Procurement Scorecard/Implement Internet
Supplier Portal

Scorecard Initiative

Implement Self Service Procurement Application

/shared/Procurement/Procurement Scorecard/Implement Self Service
Procurement Application

Scorecard Initiative

Implement Spend Analytics

/shared/Procurement/Procurement Scorecard/Implement Spend
Analytics

Scorecard Initiative

Initiatives

/shared/Procurement/Procurement Scorecard/Initiatives

Scorecard Initiative

Monitor Performance and provide regular feedback on quarterly
basis

/shared/Procurement/Procurement Scorecard/Monitor Performance
and provide regular feedback on quarterly basis

Scorecard Initiative

Monitor Spend and Savings on Monthly Basis

/shared/Procurement/Procurement Scorecard/Monitor Spend and
Savings on Monthly Basis

Scorecard Initiative

Monitor Spend by Diversified Suppliers on monthly basis

/shared/Procurement/Procurement Scorecard/Monitor Spend by
Diversified Suppliers on monthly basis

Scorecard Initiative

Reward high performing employees

/shared/Procurement/Procurement Scorecard/Reward high performing
employees

Scorecard Initiative

Vision

/shared/Procurement/Procurement Scorecard/Vision

Scorecard Vision

 

All blogs related to BIAPPS on PAAS

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.