Siebel Analytics 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 SiebelAnalytics.rpd using the Server Administration Tool.
2. Select the entire presentation layer and right-click the mouse to display the menu.
3. Choose Externalized Metadata Strings.

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

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(TBO).S_MSG
        where MSG_TYPE = 'Metadata' and
        LANG_ID = decode( 'VALUEOF(NQ_SESSION.LOCALE)' ... [more]

   to

     select MSG_NUM, MSG_TEXT
     from VALUEOF(TBO).S_MSG
        where MSG_TYPE = 'FINS_Metadata' and
        LANG_ID = decode( 'VALUEOF(NQ_SESSION.LOCALE)' ... [more]

   Click OK to commit the changes and save the repository.

7. Restart the Siebel Analytics Server.