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!

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!

OBIEE 12.2.1.2.0 is available

Oracle Business Intelligence 12.2.1.2.0 is available now for download.

You can download it from this link.
Documentation is available on this link.

It's available as usual for Windows, Linux, Solaris on Sparc, Solaris on x86, IBM AIX and HP UX Itanium platforms.