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

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!