Siebel Analytics Installation and Configuration Guide > Internationalization Considerations Regarding Siebel Analytics > Process of Maintaining Translation Tables for Siebel Analytics >

Adding Custom Translations to S_MSG Table

When you add custom objects to the metadata and choose to externalize these objects (by right-clicking on 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:  However, 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 Lists of Values for Siebel Analytics

The S_MSG table can be populated using Siebel Tools. Before populating the S_MSG table, you must add a list of values (LOV) for Siebel Analytics (this is a one-time task).

To add LOV values for Siebel Analytics

  1. Open Siebel Tools and connect to your 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. Add a record with the following values.
    Value Name
    Value Entry
    Type:
    MESSAGE_LEVEL
    Display Value:
    AnalyticsNew
    Language-independent Code:
    AnalyticsNew
    Active:
    check mark
    Language Name:
    [Choose your deployment language]
    Description:
    Analytics Metadata Strings

    All other fields should be default.

  5. Add one more record, depending on your deployment, with the following values.
    • Financial Services applications only
      Value Name
      Value Entry
      Type:
      MESSAGE_LEVEL
      Display Value:
      FINS_Metadata
      Language-independent Code:
      FINS_Metadata
      Active:
      check mark
      Language Name:
      [Choose your deployment language]
      Description:
      Analytics Financial Services Metadata Strings
    • All other applications
      Value Name
      Value Entry
      Type:
      MESSAGE_LEVEL
      Display Value:
      Metadata
      Language-independent Code:
      Metadata
      Active:
      check mark
      Language Name:
      [Choose your deployment language]
      Description:
      Analytics Metadata Strings

Adding String Translations For Siebel Analytics Metadata

The following procedure adds string translations for Siebel Analytics metadata to the S_MSG table.

To add string translations for Siebel Analytics metadata

  1. Navigate to Screens Menu > System Administration > Strings.
  2. Right-click and select New Record from the menu to add a new record.
  3. Obtain the Message Key from the Siebel Analytics Administration Tool.

    To get the message key, 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 on 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. Choose the Message type—Metadata or FINS_Metadata, depending on which one was added in Step 5 of To add LOV values for Siebel Analytics.
  6. Select AnalyticsNew Message Level.
  7. In the Message Text column, add the translation of the object.
  8. Translate & Active Flags should be on.
  9. Error Message # is 0.
  10. Set the Message Facility to SIA if you are using the Siebel Financial Services application. Otherwise, set it to HORZ.
  11. Repeat Steps 2-10 for each new metadata object string.
  12. Restart the Siebel Analytics Server.

 Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A 
 Published: 11 March 2004