Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Metadata for Analytics Applications >

Externalizing Financial Services Metadata Translation Strings

The Financial Services applications use a different set of translation strings from other Siebel operational applications.

You must externalize the metadata strings in the Analytics repository.

To externalize metadata strings in the Analytics repository

1. Open the OracleBIAnalyticsApps.rpd using the Oracle BI Administration Tool.
2. Select the entire presentation layer and right-click the mouse to display the menu.
3. Choose Display Names.

   With this configuration, all metadata strings are read from an external Siebel operational application database, specifically from the table W_LOCALIZED_STRING_G.

4. Make sure that the connection pool Externalized Metadata Strings points to the Siebel operational application database and is working correctly.
5. Go to the Manage Variables menu and locate the initialization block External Metadata Strings.

   Double-click on the initialization block to open the Edit window.

6. In the Initialization SQL area, change the SQL:

   from

     select MSG_NUM, MSG_TEXT
     from VALUEOF(OLAP_TBO).W_LOCALIZED_STRING_G
        where MSG_TYPE = 'Metadata' and
        LANG_ID = decode('VALUEOF(NQ_SESSION.WEBLANGUAGE)'... [more]

   to

     select MSG_NUM, MSG_TEXT
     from VALUEOF(OLAP_TBO).W_LOCALIZED_STRING_G
        where MSG_TYPE = 'FINS_Metadata' and
        LANG_ID = decode('VALUEOF(NQ_SESSION.WEBLANGUAGE)'... [more]

   Click OK to commit the changes and save the repository.

7. Restart the Oracle BI Server.