Siebel Analytics Installation and Configuration Guide > Siebel Industry Applications Analytics Metadata > About Siebel Industry Applications Analytics Metadata >

Siebel eFinance Analytics

Before using Siebel eFinance Analytics, Siebel eHealthcare Analytics, and Siebel eInsurance Analytics objects, you must update the Logical Table sources in the Siebel Analytics Repository file. These Logical sources must be deactivated in order for Siebel eFinance Analytics, Siebel eHealthcare Analytics, and Siebel eInsurance Analytics reports to point to the right logical model and retrieve the correct data. Do this by deactivating the W_ASSET_F source for the logical table FACTS in the core subject area.

To update Logical Table sources for eFinance Analytics

  1. Shut down Siebel Analytics Server.
  2. Launch Siebel Analytics Administration Tool and open Siebel Analytics Repository (SiebelAnalytics.rpd).
  3. Go to Business Model and Mapping window (the logical layer window) and double-click Core to open it.
  4. Scroll down to the Fact-Asset logical table and open the Sources folder.
  5. Scroll down to W_ASSET_F in the list of logical table sources, right-click it and select Properties.
  6. Click the General tab in the Properties window.

    Make sure the Active check box is checked. If it is not, check it.

  7. Click on OK, save the repository, and restart Siebel Analytics Server.

Financial Services Translation Strings

The Financial Services applications use a different set of translation strings from other Siebel eBusiness 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 Analytics 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.
  6. Double-click on the initialization block to open the Edit window.
  7. 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]

  8. Click OK to commit the changes and save the repository.
  9. Restart the Siebel Analytics Server.

 Siebel Analytics Installation and Configuration Guide
 Published: 09 September 2004