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

Externalizing Metadata Strings

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

Metadata Strings are loaded by the Oracle BI Server from a database table. In the case of Oracle Business Intelligence applications, this table is W_LOCALIZED_STRING_G in the data warehouse. The initialization block Externalize Metadata Strings loads the strings for the Server. It is recommended that you run a test to make sure that this initialization block runs successfully. An example of the translation table is shown in Table 101.

By default, the Oracle Business Intelligence repository is configured to run in English only. To deploy in any other language, you must externalize the metadata strings, as described in the following procedure.

To externalize metadata strings in the Oracle Business Intelligence repository

1. Stop the Oracle BI Server.
2. Open OracleBIAnalyticsApps.rpd using the Oracle BI Administration Tool in offline mode.
3. Select the entire Presentation layer and right-click the mouse to display the menu.
   • From the pop-up menu, select Externalize Display Names. (A check mark appears next to this option the next time you right-click on the Presentation layer.)
   • Unselect the Presentation layer.

     NOTE:  When Externalize Display Names is checked, all metadata strings are read from the W_LOCALIZED_STRING_G table in the data warehouse.

4. In the Physical layer, select the Externalized Metadata Strings database icon. Expand the tree.
5. Double-click Internal System Connection Pool.

   In the Connection Pool window General tab, the field Data source name should point to the data warehouse.

6. Click OK and exit the Oracle BI Administration Tool.
7. Restart the Oracle BI Server.