Oracle^® Business Intelligence Applications Installation and Configuration Guide > Localizing Oracle Business Intelligence Deployments > Process of Maintaining Translation Tables for Oracle BI >

Upgrading Oracle Business Intelligence Seed Data for Non-English Locales

This topic is part of the Process of Maintaining Translation Tables for Oracle BI.

If Oracle Business Intelligence data in your deployment is to be viewed in a language other than English, you must also import Locale seed data into a data warehouse table called W_LOCALISED_STRING_G. This data allows the Analytics applications metadata to be viewed in non-English languages. Because this seed data is normally part of the Siebel operational application suite, you would have loaded part of this data when you installed the Siebel operational application. The additional task described in Importing Locale Seed Data Into The Translation Table (W_LOCALIZED_STRING_G) updates the seed data and makes it current for the Oracle Business Intelligence Applications. This process must be performed once for each language in which your data is to be viewed.

During the Oracle Business Intelligence installation, a folder named $INSTALLDIR\SeedData was created, which contains a sub folder for each language. Within each language sub folder is a .dat file (the data to be imported) and an .inp file (the WHERE clause governing the import).

Importing Locale Seed Data Into The Translation Table (W_LOCALIZED_STRING_G)

If the primary language being used is not English, you may have to import additional locale seed data (depending on the number of languages you use) as shown in the following procedure.

NOTE:  This procedure can be performed only by a BI Administrator.

To import Locale seed data into the Translation Table (W_LOCALIZED_STRING_G)

1. Open a command window and navigate to $INSTALLDIR\SeedData\bin folder.
2. Run the import command in step 3 after replacing the connection parameters shown in the following table with the values appropriate to your database environment.

   Import parameters:
   UserName
   Password
   ODBCDataSource
   DatabaseOwner

3. Run the import command:

   $INSTALLDIR\SeedData\bin\dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $DatabaseOwner /f $INSTALLDIR\SeedData\<XX>\analytics_seed_<XXX>.dat /w y /q 100 /h Log /x f /i $INSTALLDIR\SeedData\<XX>\metadata_upgrade_<XXX>_<DBPlatform>.inp /l metadata_upgrade_<XXX>.log

   NOTE:  Replace the XX with the Oracle Business Intelligence two-letter language code (_fr, _it) and the XXX with the Siebel Systems three-letter code (FRA, ITA).

4. When you have finished importing the Locale seed data into the Translation Table (W_LOCALIZED_STRING_G), configure database connectivity to the machine on which the Oracle BI Server resides.

   NOTE:  Unicode connectivity can be used to access databases that do not support Unicode.