Siebel Analytics Applications Installation and Administration Guide > Localizing Siebel Analytics Deployments > Process of Maintaining Translation Tables for Analytics >

Adding Custom Translations to S_MSG Table

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

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 Siebel Analytics Server looks for the translations (including those for the native language) in the S_MSG 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).

The tasks for adding custom translations to S_MSG table require the use of Siebel Tools.

• Adding Lists of Values for Analytics Metadata
• Adding String Translations for Analytics Metadata

Adding Lists of Values for Analytics Metadata

The S_MSG table can be populated with translated message strings. Before populating the S_MSG table, you must use Siebel Tools to add lists of values (LOV) for Siebel Analytics (this is a one-time task).

To add LOV values for Siebel Analytics metadata

1. Open Siebel Tools and connect to your operational database.
2. Navigate to the Screens Menu > System Administration > List of Values.
3. Right-click and select New Record from the pop-up menu.
4. Depending on your deployment, add a Message Type record with the values shown in the following table.

   NOTE:  As shown in the following table, the values are different for Financial Services and other Siebel operational applications.

   Value Name	Enter (Financial Services Only)	Enter (Other Applications)
   Type	MESSAGE_TYPE	MESSAGE_TYPE
   Display Value	FINS_Metadata	Metadata
   Description	Analytics Financial Services Metadata Strings	Analytics Metadata Strings
   Language-Independent Code	FINS_Metadata	Metadata
   Active	Y [check mark]	Y [check mark]
   Language Name	[Choose deployment language]	[Choose deployment language]

   All other fields should accept the default settings.

5. Depending on your deployment, add a Message Facility record with the values shown in the following table.

   NOTE:  As shown in the following table, the values are different for Financial Services and other Siebel operational applications.

   Value Name	Enter (Siebel Financial Services Applications Only)	Enter (Other Applications)
   Type	MESSAGE_FACILITY	MESSAGE_FACILITY
   Display Value	FIN	HMF
   Description	Financial Services Message Facility	Analytics Message Facility
   Language-Independent Code	FIN	HMF
   Active	Y [check mark]	Y [check mark]
   Language Name	[Choose deployment language]	[Choose deployment language]

   All other fields should accept the default settings.

6. Add a Message Level record with the values shown in the following table.

   Value Name	Enter
   Type	MESSAGE_LEVEL
   Display Value	AnalyticsNew
   Description	Diagnostic Message for server side programs
   Language-Independent Code	AnalyticsNew
   Active	Y [check mark]
   Language Name	[Choose deployment language]

Adding String Translations for Analytics Metadata

The following procedure describes how to add string translations for Siebel Analytics metadata to the S_MSG table. This task occurs in Siebel Tools and in the Server Administration Tool.

To add string translations for Siebel Analytics metadata

1. Open Siebel Tools and connect to your database.
2. Navigate to Screens Menu > System Administration > Strings.

   Right-click and select New Record from the menu to add a new record.

3. Obtain the Message Key from the Server Administration Tool as follows:
   • In the Server 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. Select your deployment language.
5. Select the Message Type, depending on which one was added in Step 4 of the procedure in Adding Lists of Values for Analytics Metadata.

   Application	Display Value	Description
   Siebel Operational Applications	Metadata	Analytics Metadata Strings
   Siebel Financial Services	FINS_Metadata	Analytics Financial Services Metadata Strings

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. Select the Message Facility, depending on which one was added in Step 5 of the procedure in Adding Lists of Values for Analytics Metadata.

   Application	Display Value	Description
   Siebel Operational Applications	HMF	Analytics Message Facility
   Siebel Financial Services	FIN	Financial Services Message Facility

8. Repeat Step 3 through Step 7 for each new metadata object string.
9. Exit Siebel Tools, the Server Administration Tool, and restart the Siebel Analytics Server.