Bookshelf v7.5.2: Setting System Preferences and Using Exception Reports

This section describes how to configure the System Preferences to optimize the Extraction-Transform-Load process.

The System Preferences contain settings that are customized to your installation. Many preferences have default values, but all preferences should be checked to make sure they are correct for your installation.

Navigate to the System Preferences view (Site Map > Application
Administration > System Preferences). There are many System Preferences covering many products. Table 4 lists the preferences for Siebel Analytics.

Table 4. System Preferences for Siebel Analytics
Preference Name	Comments
ETL Alignment Version	Set this to N if you want to make changes to existing alignment. Set this to Y if you want to create a new alignment version. These preferences are used by Life Sciences to control loading of changes in assignment rules in Siebel Assignment Manager. Note that configuration of the ETL Alignment flag is different for the Siebel ePharma 6.3 to 7.5 Analytics Bridge. See Using ETL Alignment Version System Preferences.
ETL Analysis End	When extracting data from the data sources, this is the ending date range to include. Make sure it follows the format specified in the ETL Date Format preference. Suggestion: to extract the most current information, set this to a date in the future, such as December 31, 2055 (20551231).
ETL Analysis Start	When extracting data from the data sources, this is the earliest date range to include. Make sure it follows the format specified in the ETL Date Format preference.
ETL Base Exchange Currency	Set the base currency to which all the financial amounts will be converted.
ETL Date Format	Set the format to be used for representing dates. The typical format is: YYYYMMDD.
ETL Default Continent	Set the default continent, such as North America.
ETL Default Country	Set the default country, such as USA.
ETL Default Currency	Set the currency that will be used in the Siebel Transaction Database, such as USD for US Dollars, if the currency for an amount is not specified.
ETL Default Language	Set the default language, such as ENU for English.
ETL LOV Maximum Value	Leave this as 9999999999 unless you have a special need to reduce this maximum.
ETL LOV Minimum Value	This is 0 (zero) unless you have a special need to increase this minimum.
ETL Unknown Exchange Rate	Set the exchange rate to be used for unknown currencies. Typically this is set to 1.
Siebel Web Engine Server	Set this to the URL of your Siebel Web Server Engine. Example: `http://www.siebel.com`.
SqlStyle	Identify the RDBMS used for the OLAP. Enter either DB2, Microsoft SQL Server, or Oracle.
SubSqlStyle	For DB2 installations only, specify: DB2UWO.