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
- Open the OracleBIAnalyticsApps.rpd using the Oracle BI Administration Tool.
- Select the entire presentation layer and right-click the mouse to display the menu.
- 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.
- Make sure that the connection pool Externalized Metadata Strings points to the Siebel operational application database and is working correctly.
- 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.
- 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.
- Restart the Oracle BI Server.
|