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

Adding Custom Translations to the W_LOCALIZED_STRING_G Table

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

When you add custom objects to the metadata and choose to externalize these objects (by right-clicking the object and checking the Externalize Display Name option), the Oracle BI Server looks for the translations (including those for the native language) in the W_LOCALIZED_STRING_G table.

If you do not externalize the display names, you do not need to perform the following procedures.

NOTE:  The custom Presentation layer objects show up only in the native language of the metadata (the language in which you added these new objects).

Adding String Translations for Analytics Metadata

The following procedure describes how to add string translations for Oracle Business Intelligence metadata to the W_LOCALIZED_STRING_G table. This task occurs in any database administration tool, and in the Oracle BI Administration Tool.

To add string translations for Analytics metadata

1. Open a database administration tool and connect to your data warehouse database.
2. Query for the table named W_LOCALIZED_STRING_G and add a new record to the table.
3. Obtain the Message Key from the Oracle BI Administration Tool as follows:
   • In the Oracle BI Administration Tool, right-click on the new Presentation layer metadata object and select Properties from the menu.
   • The Message key is displayed in the dialog box under Custom Display Name. The Message key is the part that starts with CN_.

     For example, double-click the Pipeline catalog folder in the Presentation layer. The Custom Display name is Valueof(NQ_SESSION.CN_Pipeline). CN_Pipeline is the Message Key.

4. Enter your deployment language in the new record.
5. Enter the Message Type required (for example, Metadata, FINS_Metadata).
6. Select the Message Level AnalyticsNew, then do the following:
   • In the Message Text column, add the translation of the object.
   • Check the flags (set to Yes) for the Translate and Active columns.
   • Set the Error Message # column to 0.
7. Enter the required Message Facility (for example, HMF, FIN).
8. Repeat Step 3 through Step 7 for each new metadata object string.
9. Exit the database administration tool, then restart the Oracle BI Server.