Globalization

BIA Reports are defaulted in English but are also now supported in multiple languages. For languages other than English, in order to build the database in the language specific to your BIA Reporting module then set the Component.locale.order.installedLanguage variable in Reporting\project\properties\BIApplication.properties to the the relevant language code, prior to building your database. The language codes are:

• en - English
• es - Spanish
• pt_BR - Portuguese (Brazil)
• fr- French
• ko - Korean
• it- Italian
• zh_CN - Chinese (PRC)
• zh_TW -Chinese (Taiwan)

The 3 localized property files also need to be manually updated. Located in Reporting\components\BIBuildTools\data_manager\initialdata, for each of the following sql files:

• st_initialdata.sql
• dw_initialdata.sql
• dm_initialdata.sql

change the language code (BI_PROP_VALUE) for the insert statements which contain a BIPROP_NAME = 'BI.BILOCALE'.

For example, when switching to Korean, change the code in the st_initialdata.sql file from

INSERT INTO ST_PROPERTIES (BIPROPERTYID, BICATEGORY, BIPROP_NAME,BIPROP_VALUE,BIPROP_TYPE,DEFAULTVALUE,LOCALE,LASTWRITTEN) VALUES (stpropertiesseq.nextval, 'CONFIG','BI.BILOCALE', 'en', 'STRING',NULL,'',getDateTime());

to

INSERT INTO DW_PROPERTIES (BIPROPERTYID, BICATEGORY, BIPROP_NAME,BIPROP_VALUE,BIPROP_TYPE,DEFAULTVALUE,LOCALE,LASTWRITTEN) VALUES (dwpropertiesseq.nextval, 'CONFIG','BI.BILOCALE', 'ko', 'STRING',NULL,'',getDateTime());

and make similar changes to dw_initialdata.sql and dm_initialdata.sql