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

Problem when trying to export large PDF/XLSX file from OBIEE 12

If you try to export large report in PDF / XLSX format you will get error codes: "AGEGTYVF".

Reason is thread limit that is being encountered when streaming data from the presentation server to the javahost. To implement the solution, execute the following step:

• Open with text editor "config.xml" file from location:
  $OMWHOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH
• Set value "InputStreamLimitInKB" to "0" (zero, without the quotes).
  
  <XMLP><InputStreamLimitInKB>0</InputStreamLimitInKB>     <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing></XMLP>
• Save changes and restart all BI services (including weblogic components)

0 means that this limit is deactivated. If this solves the issue and you would like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then gradually increase the parameter's value until you can export correctly.

Cheers!