Moving OBIEE to new enviroment

 

OBI migration to new enviroment

 

Everyone has at least once had the need to migrate Oracle Business Intelligence (OBI) to a new enviroment. Whether it is a migration from test to production environment or during full server migration, procedure is the same. The OBI environment migration process is described below. All you need is just a few commands using predefined OBI scripts. With this, you will migrate whole OBI metadata to new server (Weblogic Users and Groups, Catalog, Catalog Permissions, Repository metadata etc.).

First, you need to set up variables which depends of your installation:

export BI_PRODUCT_HOME="your BI home directory ex. /omw/bi"
export ORACLE_HOME="your Oracle home directory ex. /omw"
export DOMAIN_HOME="your domain home directory ex. /omw/user_projects/domains/bi"

Export script in 12.2.1.4.0. version of OBI  is located at "/ora01/omw/user_projects/domains/bi/bitools/bin/" directory. You will need to type password for encryption. This password you will need in import procedure.

Full export command you can see below:

/ora01/omw/user_projects/domains/bi/bitools/bin/export_service_instance.sh ssi /tmp/testexp.bar

Import script in 12.2.1.4.0. version of OBI is located at "/ora01/omw/user_projects/domains/bi/bitools/bin/" directory. You must execute this script on new OBI enviroment after you have successfully copied BAR file from previous export described above.

Full importcommand you can see below:

/ora01/omw/user_projects/domains/bi/bitools/bin/importarchive.sh ssi /tmp/testexp.bar encryptionpassword=yourpassword

 
Please, restart your services on new server and check if everything is correct. It must be. :)

/omw/user_projects/domains/bi/bitools/bin/stop.sh
/omw/user_projects/domains/bi/bitools/bin/start.sh

Cheers!

Add AD (LDAP) user to Weblogic Administrator group

Add AD (LDAP) user to Weblogic Administrator group

 

If you have successfully linked OBIEE server with MS Active directory services, you may want to enable some users from IT department to manage Weblogic server or BI services via Enterprise Manager Console.

1. Login to the WebLogic console using the WebLogic administrator user (example: weblogic).
2. Go to "Security Realm" -> "myrealm" -> "Roles and Policies" tab
3. Expand Global Roles -> Roles and the click on "View Role Conditions" for "Admin" role.
4. Click on Add Condition button, select Group for "Predicate List" drop down box and click Next.
5. Enter the AD Group Name for which you want Admin privileges in WebLogic for "Group Argument Name" field and hit on Add button.
6. Click on Finish button and then in Next screen hit on Save button to save changes.
7. Logout of Admin console and log back in as one of the AD users which are part of AD group which you granted the WebLogic Admin role in the console. You should be able to log into the WebLogic console and do administration tasks.
   
   Cheers!

Very wide rows/columns when downloading dashboard to excel (OBIEE 12c)

Very wide rows/columns when downloading dashboard to excel
(OBIEE 12c)

         The problem was when you export whole dashboard or answer to excel, columns and rows goes to big (more than they have characters in it). Many of customers want to have identical data/visualization in excel file like they have in OBIEE portal are unhappy about it. Solution to resolve this problem is realy simple. Open file "xdo.cfg" (location: $OMW_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/xdo.cfg) and change parameter named 

<property name="xlsx-keep-values-in-same-column">true</property>

to 

<property name="xlsx-keep-values-in-same-column">false</property> 

After that, restart all BI services and try to export excel file. You'll see that everything in excel is same like you see in OBIEE portal.

Cheers!

Prerequisites for installing OBIEE (11g or 12c) on Linux OS (RHEL)

Prerequisites for installing OBIEE (11g or 12c) on Linux OS (RHEL)

 

       Before you start installing OBIEE 11g or OBIEE 12c it is better to have all this packages installed on your OBIEE frontend server. Some packages are required and some packages are optional, but trust me, in the future you will need it. :)
 
Best and easiest way is to install packages via YUM (on Oracle Linux). Command:

yum install lvm2 bind-utils oracle-rdbms-server-11gR2-preinstall tigervnc-server xterm mutt zip unzip sendmail-cf vim-enhanced samba-client system-config-firewall glibc.i686 libgcc_s.so.1 unix2dos iotop iptraf cifs-utils nfs-utils wget dos2unix telnet rsync expect hdparm tree pigz p7zip p7zip-plugins rlwrap postfix openmotif.i686 openmotif22.i686 libstdc++.i686 compat-libstdc++-33.x86_64 compat-libstdc++-33.i686 openmotif22-2.2.3 for x86_64 rng-tools xorg-x11-apps-y 

Do not forgate to install latest JDK. You can download latest JDK version from Oracle official site. After successfull download, locate your RPM file on file system and execute command:

rpm -ivh "rmpfile"

Cheers! ;)

Drazen

Changing date format in OBIEE 12c portal

There are many ways how to set default date format in OBIEE portal, some of those options are:

• Manually in "My Account" option window for each user
• With USERLOCALE system session variable in RPD file (Init block)

For me, best way is to change this options with little "hack". In the OBIEE installation folder locate $FMW_HOME/bi/bifoundation/web/display/localemappings.xml file. Edit it with one of preffered text editor.

In the file, find string specified below:
<when matches="*"><localeDefinition name="en-gb"/></when>

If you want that all BI users has locale definition in italian, your string must look like: 
 <when matches="*"><localeDefinition name="it-it"/></when>After changing this value, save your file and restart all BI services.

Supported locales

	Country (ISO 3166)	Language Tag
Albanian (sq)	Albania (AL)	sq-AL
Arabic (ar)	Algeria (DZ)	ar-DZ
Arabic (ar)	Bahrain (BH)	ar-BH
Arabic (ar)	Egypt (EG)	ar-EG
Arabic (ar)	Iraq (IQ)	ar-IQ
Arabic (ar)	Jordan (JO)	ar-JO
Arabic (ar)	Kuwait (KW)	ar-KW
Arabic (ar)	Lebanon (LB)	ar-LB
Arabic (ar)	Libya (LY)	ar-LY
Arabic (ar)	Morocco (MA)	ar-MA
Arabic (ar)	Oman (OM)	ar-OM
Arabic (ar)	Qatar (QA)	ar-QA
Arabic (ar)	Saudi Arabia (SA)	ar-SA
Arabic (ar)	Sudan (SD)	ar-SD
Arabic (ar)	Syria (SY)	ar-SY
Arabic (ar)	Tunisia (TN)	ar-TN
Arabic (ar)	United Arab Emirates (AE)	ar-AE
Arabic (ar)	Yemen (YE)	ar-YE
Belarusian (be)	Belarus (BY)	be-BY
Bulgarian (bg)	Bulgaria (BG)	bg-BG
Catalan (ca)	Spain (ES)	ca-ES
Chinese (zh)	China (CN)	zh-CN
Chinese (zh)	Singapore (SG)	zh-SG(*)
Chinese (zh)	Hong Kong (HK)	zh-HK
Chinese (zh)	Taiwan (TW)	zh-TW
Croatian (hr)	Croatia (HR)	hr-HR
Czech (cs)	Czech Republic (CZ)	cs-CZ
Danish (da)	Denmark (DK)	da-DK
Dutch (nl)	Belgium (BE)	nl-BE
Dutch (nl)	Netherlands (NL)	nl-NL
English (en)	Australia (AU)	en-AU
English (en)	Canada (CA)	en-CA
English (en)	India (IN)	en-IN
English (en)	Ireland (IE)	en-IE
English (en)	Malta (MT)	en-MT(*)
English (en)	New Zealand (NZ)	en-NZ
English (en)	Philippines (PH)	en-PH(*)
English (en)	Singapore (SG)	en-SG(*)
English (en)	South Africa (ZA)	en-ZA
English (en)	United Kingdom (GB)	en-GB
English (en)	United States (US)	en-US
Estonian (et)	Estonia (EE)	et-EE
Finnish (fi)	Finland (FI)	fi-FI
French (fr)	Belgium (BE)	fr-BE
French (fr)	Canada (CA)	fr-CA
French (fr)	France (FR)	fr-FR
French (fr)	Luxembourg (LU)	fr-LU
French (fr)	Switzerland (CH)	fr-CH
German (de)	Austria (AT)	de-AT
German (de)	Germany (DE)	de-DE
German (de)	Luxembourg (LU)	de-LU
German (de)	Switzerland (CH)	de-CH
Greek (el)	Cyprus (CY)	el-CY(*)
Greek (el)	Greece (GR)	el-GR
Hebrew (iw)	Israel (IL)	iw-IL
Hindi (hi)	India (IN)	hi-IN
Hungarian (hu)	Hungary (HU)	hu-HU
Icelandic (is)	Iceland (IS)	is-IS
Indonesian (in)	Indonesia (ID)	in-ID(*)
Irish (ga)	Ireland (IE)	ga-IE(*)
Italian (it)	Italy (IT)	it-IT
Italian (it)	Switzerland (CH)	it-CH
Japanese (ja)	Japan (JP)	ja-JP
Japanese (ja)	Japan (JP)	ja-JP-u-ca-japanese
Japanese (ja)	Japan (JP)	ja-JP-x-lvariant-JP
Korean (ko)	South Korea (KR)	ko-KR
Latvian (lv)	Latvia (LV)	lv-LV
Lithuanian (lt)	Lithuania (LT)	lt-LT
Macedonian (mk)	Macedonia (MK)	mk-MK
Malay (ms)	Malaysia (MY)	ms-MY(*)
Maltese (mt)	Malta (MT)	mt-MT(*)
Norwegian (no)	Norway (NO)	no-NO
Norwegian Bokmål (nb)	Norway (NO)	nb-NO
Norwegian Nynorsk (nn)	Norway (NO)	nn-NO
Norwegian (no)	Norway (NO)	no-NO-x-lvariant-NY
Polish (pl)	Poland (PL)	pl-PL
Portuguese (pt)	Brazil (BR)	pt-BR(***)
Portuguese (pt)	Portugal (PT)	pt-PT(***)
Romanian (ro)	Romania (RO)	ro-RO
Russian (ru)	Russia (RU)	ru-RU
Serbian (sr)	Bosnia and Herzegovina (BA)	sr-BA(*)
Serbian (sr)	Montenegro (ME)	sr-ME(*)
Serbian (sr)	Serbia (RS)	sr-RS(*)
Serbian (sr)	Bosnia and Herzegovina (BA)	sr-Latn-BA(**)
Serbian (sr)	Montenegro (ME)	sr-Latn-ME(**)
Serbian (sr)	Serbia (RS)	sr-Latn-RS(**)
Slovak (sk)	Slovakia (SK)	sk-SK
Slovenian (sl)	Slovenia (SI)	sl-SI
Spanish (es)	Argentina (AR)	es-AR
Spanish (es)	Bolivia (BO)	es-BO
Spanish (es)	Chile (CL)	es-CL
Spanish (es)	Colombia (CO)	es-CO
Spanish (es)	Costa Rica (CR)	es-CR
Spanish (es)	Dominican Republic (DO)	es-DO
Spanish (es)	Ecuador (EC)	es-EC
Spanish (es)	El Salvador (SV)	es-SV
Spanish (es)	Guatemala (GT)	es-GT
Spanish (es)	Honduras (HN)	es-HN
Spanish (es)	Mexico (MX)	es-MX
Spanish (es)	Nicaragua (NL)	es-NI
Spanish (es)	Panama (PA)	es-PA
Spanish (es)	Paraguay (PY)	es-PY
Spanish (es)	Peru (PE)	es-PE
Spanish (es)	Puerto Rico (PR)	es-PR
Spanish (es)	Spain (ES)	es-ES
Spanish (es)	United States (US)	es-US(*)
Spanish (es)	Uruguay (UY)	es-UY
Spanish (es)	Venezuela (VE)	es-VE
Swedish (sv)	Sweden (SE)	sv-SE
Thai (th)	Thailand (TH)	th-TH
Thai (th)	Thailand (TH)	th-TH-u-ca-buddhist
Thai (th)	Thailand (TH)	th-TH-u-ca-buddhist-nu-thai
Thai (th)	Thailand (TH)	th-TH-x-lvariant-TH
Turkish (tr)	Turkey (TR)	tr-TR
Ukrainian (uk)	Ukraine (UA)	uk-UA
Vietnamese (vi)	Vietnam (VN)	vi-VN

Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.3 is available

Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.3 has been released!


You can download it from Oracle Software Delivery Cloud or OTN. 
Documentation is available on Oracle Business Intelligence Enterprise Edition 12.2.1.3.0 link. 

Latest available Patch information for 12c, refer to OBIEE 12c: Doc ID 2070465.1

Cheers!

Character is missing on PDF export - OBIEE 12c (SOLVED)

When there are Croatian, Turkish or other "non English" language characters in a report, and you want to export report to PDF format or send it via agent in PDF formar, they go missing on PDF export.

This issue has been identified and verified as the following bugs in OBIEE 12c:

• Bug ID: 21306102
• Bug ID: 20023426
• Bug ID: 20795751

Workaround is described below. Paths shown in the example are from Linux distribution.

First you need to create directory "fonts" into path: $MW_HOME/bi/common

After that download fonts from this link and move it to folder "$ORACLE_HOME/bi/common/fonts". Restart all OBIEE services ("$MW_HOME/user_projects/domains/bi/bitools/bin/stop.sh" and "$MW_HOME/user_projects/domains/bi/bitools/bin/start.sh").

Now, you can make export to PDF and check if your special characters are present in your PDF. In mine, everything works like a charm! :)

Cheers!