OBIEE 12c to OAS Migration

 Hi All,

I have migrated successfully few projects from BI 12c to OAS 6.4. If  anyone wants help then please reach Me!

Cheers!

Bose

Searching a log files in Linux

 Being a Developer and Administrator, It is our everyday duty to analyze log files of bi server, scheduler, presentation or nodemanager log. 

When logs are growing, it is difficult to identify and track it. For e.g: When hundred Agents are scheduled, it is creating 200 files everyday with .log and .err files in scheduler log location. 

When you want to search yesterday or today or 10 days before with the particular agent log file, the following syntax will help you to bring up the files.

[logs]$ find . -iname "Agent-111-*" -atime -2 -type f -ls

The above syntax will list out all the files starts with Agent id 111 before 2 days.

Customize the syntax based on your need.

Cheers!

Bose 

Exporting and Importing BAR file OBIEE 12.2.1.4.x

We have an utility to export OBIEE Catalog, RPD, security model and all other relevant objects to be exported into a .bar file and the same could be imported if we have to migrate to any other environment or as a backup. Please follow the below steps for the same.

Upto 12.2.1.3, We have export_service_instance and import_service_instance command but 12.2.1.4 those commands are deprecated and introduced exportarchive and importarchive.

Exporting BAR File in OBIEE 12c:

 ***********************************************************

1. Make sure that the below environment variables are set:

BI_PRODUCT_HOME=$ORACLE_HOME/bi
ORACLE_HOME=/obiee12c (where OBIEE installed)
DOMAIN_HOME=/obiee12c/user_projects/domains (Where domain is located)

2. Run the below command with exportarchive.sh

Syntax:

[DOMAIN_HOME]/bitools/bin/exportarchive.sh ssi <Bar file name>.bar encryptionpassword=<password>

Example:

[DOMAIN_HOME]/bitools/bin/exporarchive.sh ssi /obiee12c/backup/obitest.bar encryptionpassword='Admin123'

Note: 

Encryption password is optional. If you are chosen with password, you have to use the same while importing

Importing BAR File in OBIEE 12c:

 ***********************************************************

The import_bar.sh |. cmd command is deprecated in OBI 12.2.1.4. 

With 12.2.1.4, use the importarchive.sh (Linux) | importarchive.cmd (for windows) command.

You may use the -h switch for syntax

[DOMAIN_HOME]/bi/bitools/bin/importarchive.sh -h

USAGE : <service instance key> <location of bar file to import> [nodatamodel] [nocontent] [noauthorization] [nodatasets] [nosearch] [noaction] [encryptionpassword=<encryption password for connections>]
 Description         : Import bar as a service instance
 Mandatory Arguments : service instance key and location of bar file
 Optional Arguments  : exclude list of values:nodatamodel nocontent                        noauthorization nodatasets nosearch
  nodatamodel        : Do not import RPD metadata content
  nocontent          : Do not import WEBCAT metadata content
  noauthorization    : Do not import JAZN metadata content
  nodatasets         : Do not import DSS metadata content
  nosearch           : Do not import Search metadata content
  noaction           : Do not import Action metadata content
  encryptionpassword : Encryption password for connections if any 

Syntax:

./importarchive.sh ssi /obiee12c/backup/obitest.bar                  encryptionpassword=<password>                                        

Example:                                                            ./importarchive.sh ssi /obiee12c/backup/obitest.bar encryptionpassword=Admin123

Cheers!

Bose

Log files Location/directory in OBIEE 12c / OAS

OBIEE 12c Log Locations:

First We should know our fusion middleware home or oracle BI Home directory location and then search in the relevant folder/directory for logs.

• AdminServer logs – <FMW_HOME>/user_projects/domains/bi/servers/AdminServer/logs
• bi_server1 logs – <FMW_HOME>/user_projects/domains/bi/servers/bi_server1/logs
• Presentation Server logs – <FMW_HOME>/user_projects/domains/bi/servers/obips1/logs
• JavaHost logs – <FMW_HOME>/user_projects/domains/bi/servers/obijh1/logs
• Cluster Components logs – <FMW_HOME>/user_projects/domains/bi/servers/obiccs1/logs
• Scheduler Server logs – <FMW_HOME>/user_projects/domains/bi/servers/obisch1/logs

If it is 2 Node Servers, then 

Presentation Server logs 2nd Node – <FMW_HOME>/user_projects/domains/bi/servers/obips2/logs

Scheduler Server logs For 2nd Node– <FMW_HOME>/user_projects/domains/bi/servers/obisch2/logs

OBIEE 11g Locations:

• Upgrade logs – Middleware\Oracle_BI1\upgrade\logs
• Admin Server logs – <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\logs
• Managed Server logs – <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs
• BI Server logs – <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
• Presentation Server logs – <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

Cheers!

Bose

OBIEE 12c Client Tool step by step installation

Here is the steps on how to download and Install OBIEE 12c client tool installaton.

Download Link: 

https://www.oracle.com/in/middleware/technologies/business-intelligence-v12214-downloads.html

Go to Oracle Business Intelligence Developer Client Tool (12.2.1.4.0) section and download the client tool.

once Downloaded, Copy into a new folder and unarchive/unzip  the zip file.

Step1: 

Double click on the 'setup_bi_client-12.2.1.4.0-win64' file and the installation window will open

Step2:

Oracle Universal Installer Window will open. Just Click 'Next'

Step3:

Check the default selected folder is good to install or create your folder and select the folder here to install and click 'Next'

Step4:

The actual installation starts here. Just Click 'install' to install OBIEE Client 12c. 

Note: If you want to save the details, you could click and save the responsible file.

Step5: 

Installation will progress and completes the client tool installation. Just click 'Next'

Step6:

Click 'Finish' to complete the installation.

To Verify the client is installed in windows machine whether correctly or not, verify below

Start -> Programs ->  Oracle Business Intelligence Client.

Happy Blogging!

Cheers!

Bose

Automated Cache purging in OBIEE 12c

In this post We are going to create a shell script which will purge all the cache in OBIEE. This file could  be scheduled in a cronjob OR added in informatica or ODI to run everyday once all the loads are completed or Run manually whenever you would like to run.

Step1: Create purgecache.txt file like below

Purgecache.txt
call SAPurgeAllcache()

Step2: Create a shell script to call the above file and clear the purge.

****************************************************************************************

#purgeCache12c file is created for clearing BI 12c cache#

#File Name - purgecache.sh

#!/bin/bash

#OBIEE12c Home Location

export MW_HOME=/OBIEE12c

#Location of the Purgecache script file

export SCRIPT_PATH=/OBIEE12c/scripts/purgeCache

# Timestamp for Log file creation

TIME_STAMP=`date '+%Y%m%d_%H%M'`

#Log File directory and filename creation

export LOG_FILE=$SCRIPT_PATH/purgecache_${TIME_STAMP}.log

#Mail Group that you want to send (Optional)

MAIL_LIST="#bisupport@oracle.com"

#Command to clear BI Server Cache

$MW_HOME/user_projects/domains/bi/bitools/bin/nqcmd.sh -d AnalyticsWeb -u weblogic -p weblogicpwd -s $SCRIPT_PATH/purgecache.txt -o $LOG_FILE;

# Finding Purge cache Line Count for Cache Clear success or Fail

line_cnt=`cat $SCRIPT_PATH/purgecache.txt|wc -l`

SUCCESS_FLG=`grep -E 'Operation SAPurgeAllCache succeeded' $LOG_FILE|wc -l`;

if [ $SUCCESS_FLG = $line_cnt ]

then

        echo "Cache Cleared Successfully " >> $LOG_FILE

        echo `hostname` >> $LOG_FILE

        mailx -s "Cache Clearance Successful on `hostname`" $MAIL_LIST < $LOG_FILE

else

        echo "Cache clearance Failed" >> $LOG_FILE

        mailx -s "Cache Clearance Failed on `hostname`" $MAIL_LIST << EOT

        GCWUAT Cache clearance Failed, please verify

EOT

fi

#Command to Delete the log files which is older than 5 days

find $SCRIPT_PATH/ -name "*.log" -type f -mtime +2 -exec rm -rf {} \;

**************************************************************************************

Note:

MW_HOME environment variable value should be updated based on you BI 12c environment.

You can test this script file by running manually once in your environment by the below command.

./purgecache.sh

Happy Blogging!

Bose

OBIEE 12c Lift and Shift

When we are doing the lift and shift of OBIEE 12c, We would be copying the entire OBIEE 12c installed directory to the new server. 

When we are doing this change, We have to complete prerequisite check first and then we have to update the hostname and IP Address of the new server in the following locations in OBIEE 12c files.

Following are the file locations and file names for two Node clustered Servers:

Node1

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server3/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server5/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis1/data/nodemanager

Update IP address of the new server in nodemanager.properties file in below location

/OBIEE12C/user_projects/domains/bi/nodemanager

Update IP address of the new server in  config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config

Update IP address of the new server in admin.conf  file in below location

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs1

Update IP address of the new server in wsm-ccw-config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Node2:

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server4/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server6/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis2/data/nodemanager

Update the IP address in nodemanager.properties file in the following location.

/OBIEE12C/user_projects/domains/bi/nodemanager

Update the IP address in config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config

Update the IP address in  admin.conf file in the following location.

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs2

Update the IP address in wsm-ccw-config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Cheers!

Bose

OBIEE 12c (12.2.1.4.0) is Awailable for Download

OBIEE 12c (12.2.1.4.0) Download Link:

https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/default-4441820.html

OBIEE 12c (12.2.1.3.0) Download link:

https://www.oracle.com/technetwork/middleware/bi/downloads/default-3852322.html

OBIEE 12c Tutorials:

If would like to learn on creating BI Dashboards and RPD, then the following link will help us to learn.

https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/index.html

Cheers!

Bose

Creating Impersonated User in OBIEE 12c

Here is the steps to create Impersonate Users:

Precheck:
Please create the user in console to which you want to apply impersonator 

Step1:

• From the Weblogic Domain menu, select Security.
• Click Application Policies.

Step2:

• Click Application Policies.
• Click Create to display the Create Application Grant page.

Step3:

• In the Permissions section, click + Add .
• Select Resource Types
• Select oracle.bi.user from the Resource Type list.
• Click Continue to display the Add Permission dialog.
• Enter an asterisk (*) in the Resource Name field and click Next

Step4:

• Select impersonate in the Permission Actions section.
• Click Select.

Step5:

• Now add a new grantee.
• In the Grantee section click + Add to display the Add Principal dialog.

Step6:

• We can choose to grant the newly created permission to either an application role or a user. In this example, we choose a user.
• Select User from the drop-down list.

Step7:

   Here I have selected the user BIImpersonatorUser that I have created in console. 

Cheers!
Bose

Go URL with Parameters Example in OBIEE 12c (12.2.1.3.0)

This post will give the example on Go URL.

From OBIEE 12.2.1.3.0, Lightweight SSO is enabled. So we have to disable it first to work with Go URL. To Know and Disabling the Lightweight SSO, Refer Here

By default, you can add up to 100 parameters to the URL. However, you can adjust the number of parameters by modifying the Prompts/MaxPromptedURLParams setting in instanceconfig.xml.

&Action=Navigate

&P0=n  where n is the number of columns you wish to filter, currently 1 - 6.

&P1=op  where op is one of the following operators.

Operator	Meaning
eq	Equal to or in.
neq	Not equal to or not in.
lt	Less than.
gt	Greater than.
ge	Greater than or equal to.
le	Less than or equal to.
bwith	Begins with.
ewith	Ends with.
cany	Contains any (of the values in &P3).
call	Contains all (of the values in &P3).
like	You need to type %25 in place of the usual % wildcard. See the examples that follow.
top	&P3 contains 1+n, where n is the number of top items to display.
bottom	&P3 contains 1+n, where n is the number of bottom items to display.
bet	Between (&P3 must have two values).
null	Is null (&P3 must be 0 or omitted).
nnul	Is not null (&P3 must be 0 or omitted).
&P2=ttt.ccc	In this parameter, ttt is the table name and ccc is the column name. If the table or column contains spaces, it must be quoted with double-quotes. Spaces should be escaped as %20, for example, Measures."Dollar%20Sales".

Example:
http://localhost:9502/analytics/saw.dll?Go&Path=%2fshared%2fTest%2fAnalysis%2fSales&Options=rmf&Action=Navigate&P0=2&P1=eq&P2=%22Operating%20Unit%22.%22Operating%20Unit%20Name%22&P3=CAL&P4=eq&P5=Time.Year&P6=2+2016+2017

Decoding the above example:
It has Action=Navigate
P0=2 which means has 2 columns for parameters
p1=eq means Equal operator applied
P2=Opearting Unit Name column from Operating Unit Table
P3=Value of the P2. (example here is CAL)
P4=eq is another equal operator for another columns
P5=Year column from Time Table
P6=2+2016+2017 means Year has two values which 2016 and 2017

SQL Issued By BI is like:

WHERE ( ("Time"."Year" IN ('2016', '2017')) AND  ("Operating Unit"."Operating Unit Name" = 'CAL')) FETCH FIRST 65001 ROWS ONLY

Complete Oracle Reference Guide - Click Here

Cheers!
Bose

Go URL in OBIEE 12c

Problem:

When we are trying to use Go URL functionality, It always comes to login page.

Why is it happening?

With 12c, 12.2.1.2+ A new feature called Light Weight SSO has been introduced. 

When this feature is enabled, using "NQUser"/"NQPassword" in the URL is not possible or supported.
 
Lightweight SSO is implemented by default in new installations of Oracle BI EE release 12.2.1.3.0

Solution:

Disabling the Lightweight SSO will help us to overcome this issue and Report/Dashboard with Go URL will just fine without going to login page.

Steps to Disable Lightweight SSO:

Step1:

Stop all the BI Services. Go to the link to know Stop and Start BI 12c Services

Step2: 

After stopping the BI Services, Go to the following path and execute WLST offline

[ORACLE_BI_HOME]/oracle_common/common/bin/wlst.sh

execute the 'disableBISingleSignOn' command to disable.

wls:/offline> disableBISingleSignOn('/path to your domain')

e.g: 

wls:/offline> disableBISingleSignOn('$ORACLE_BI_HOME/user_projects/domains/bi')

Step3:

Now Start all the BI Services using ./start.sh (Linux) or Start.cmd (Windows) and check with the Go URL. 

Cheers!

Bose