Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide >
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |