Table 27. Default Siebel Analytics Configuration File Settings
|
|
|
Other Valid Values (if not binary) or Notes |
Repository |
Star [UNIX] |
ORA_Northwind.rpd |
|
Star [Windows] |
demo1.rpd |
|
Cache |
ENABLE |
NO |
|
DATA_STORAGE_PATHS [UNIX] |
"$INSTALLDIR/SiebelAnalyticsData/Cache" |
Cache size is 500 MB |
DATA_STORAGE_PATHS [Windows] |
"$INSTALLDIR\SiebelAnalyticsData\Temp\Cache" |
Cache size is 256 MB |
METADATA_FILE [UNIX] |
"$INSTALLDIR/SiebelAnalyticsData/Cache/MetaData" |
|
METADATA_FILE [Windows] |
"$INSTALLDIR\SiebelAnalyticsData\Temp\Cache\Metadata" |
|
REPLACE_ALGORITHM |
LRU |
|
BUFFER_POOL_SIZE |
1 MB |
|
MAX_ROWS_PER_CACHE_ ENTRY |
100000 |
0 is unlimited size. |
MAX_CACHE_ENTRY_SIZE |
1 MB |
|
MAX_CACHE_ENTRIES |
1000 |
|
POPULATE_AGGREGATE_ ROLLUP_HITS |
NO |
|
METADATA_BACKUP_ FREQUENCY_MINUTES |
1440 |
If periodic metadata backups are not done, use 0. |
General |
LOCALE |
"english-usa" |
Chinese-simplified, Chinese-traditional, Czech, Danish, Dutch, Finnish, French, German, Italian, Japanese, Korean, Portuguese, Portuguese-Brazilian, Spanish, Swedish |
SORT_ORDER_LOCALE |
"english-usa" |
SORT_TYPE |
"binary" |
|
CASE_SENSITIVE_ CHARACTER_COMPARISON |
OFF |
Must match the remote target database. |
NULL_VALUES_SORT_ FIRST |
OFF |
- SQL Server sorts nulls first.
- Oracle sorts nulls last.
|
DATE_TIME_DISPLAY_ FORMAT |
"yyyy/mm/dd hh:mi:ss" |
|
DATE_DISPLAY_FORMAT |
"yyyy/mm/dd" |
|
TIME_DISPLAY_FORMAT |
"hh:mi:ss" |
|
WORK_DIRECTORY_PATHS [UNIX] |
"$INSTALLDIR/Data/tmp" |
|
WORK_DIRECTORY_PATHS [Windows] |
"$INSTALLDIR\SiebelAnaly ticsData\Temp" |
|
SORT_MEMORY_SIZE |
4 MB |
|
SORT_BUFFER_ INCREMENT_SIZE |
256 KB |
|
VIRTUAL_TABLE_PAGE_ SIZE |
128 KB |
|
USE_LONG_MONTH_ NAMES |
NO |
|
USE_LONG_DAY_NAMES |
NO |
|
UPPERCASE_USERNAME_ FOR_INITBLOCK |
NO |
|
Security |
DEFAULT_PRIVILEGES |
READ |
NONE |
PROJECT_INACCESSIBLE_ COLUMN_AS_NULL |
NO |
For platform or Stand-Alone Analytics, the default is NO. |
MINIMUM_PASSWORD_ LENGTH |
0 |
|
AUTHENTICATION_TYPE |
NQS |
|
Server |
SERVER_NAME |
Siebel_Analytics_Server |
|
MAX_SESSION_LIMIT |
2000 |
|
MAX_REQUEST_PER_ SESSION_LIMIT |
500 |
|
SERVER_THREAD_RANGE |
40-100 |
100-100 |
SERVER_THREAD_STACK_ SIZE |
0 |
Default value of 0 assigns 1 MB per thread. |
DB_GATEWAY_THREAD_ STACK_SIZE |
0 |
Default value of 0 assigns 256 KB per thread. |
MAX_EXPANDED_ SUBQUERY_PREDICATES |
8192 |
|
MAX_QUERY_PLAN_ CACHE_ENTRIES |
1024 |
|
MAX_DRILLDOWN_INFO_ CACHE_ENTRIES |
1024 |
|
MAX_DRILLDOWN_QUERY_ CACHE_ENTRIES |
1024 |
|
INIT_BLOCK_CACHE_ ENTRIES |
20 |
|
CLIENT_MGMT_THREADS_MAX |
5 |
|
RPC_SERVICE_OR_PORT |
9703 |
|
ENABLE_DB_HINTS |
YES |
|
PREVENT_DIVIDE_BY_ ZERO |
YES |
|
Server (continued) |
CLUSTER_PARTICIPANT |
NO |
If value is YES, add the following parameters: - REPOSITORY_PUBLISHING_DIRECTORY
- REQUIRE_PUBLISHING_DIRECTORY
|
REPOSITORY_PUBLISHING_DIRECTORY |
"<dirname>" |
Use when CLUSTER_PARTICIPANT = YES |
REQUIRE_PUBLISHING_ DIRECTORY |
YES |
DISCONNECTED |
NO |
|
AUTOMATIC_RESTART |
YES |
|
Dynamic Library |
ODBC200 |
nqsdbgatewayodbc |
The dynamic libraries are categorized by the CLI they support. |
ODBC350 |
nqsdbgatewayodbc35 |
OCI7 |
nqsdbgatewayoci7 |
OCI8 |
nqsdbgatewayoci8 |
OCI8i |
nqsdbgatewayoci8i |
DB2CLI |
nqsdbgatewaydb2cli |
DB2CLI35 |
nqsdbgatewaydb2cli35 |
NQSXML |
nqsdbgatewayxml |
XMLA |
nqsdbgatewayxmla |
User Log |
USER_LOG_FILE_SIZE |
10 MB |
Logs query activity when enabled for a user. |
CODE_PAGE |
"UTF8" |
ANSI, 1252, and others. |
Usage Tracking |
ENABLE |
NO |
Collects usage statistics on each logical query submitted to the Analytics Server. |
STORAGE_DIRECTORY |
"<full directory path>" |
|
CHECKPOINT_INTERVAL_ MINUTES |
5 |
|
FILE_ROLLOVER_ INTERVAL_MINUTES |
30 |
|
CODE_PAGE |
"ANSI" |
UTF8, 1252, and others. |
DIRECT_INSERT |
YES |
Inserts data into a table. If DIRECT_INSERT is YES, then PHYSICAL_TABLE_NAME, CONNECTION_POOL, BUFFER_SIZE, BUFFER_TIME_LIMIT_ SECONDS, NUM_INSERT_THREADS and MAX_INSERTS_PER_ TRANSACTION all apply. |
PHYSICAL_TABLE_NAME |
"<Database>"."<Catalog>"."<Schema>"."<Table>" |
SQL Server databases use "<Database>"."<Catalog>"."<Schema>"."<Table>" Oracle databases use "<Database>"."<Schema>"."<Table>" |
CONNECTION_POOL |
"<Database>" ."<Connection Pool>" |
|
BUFFER_SIZE |
10 MB |
|
BUFFER_TIME_LIMIT_ SECONDS |
5 |
|
NUM_INSERT_THREADS |
5 |
|
MAX_INSERTS_PER_ TRANSACTION |
1 |
|
Optimization Flags |
STRONG_DATETIME_TYPE_CHECKING |
ON |
|
Cube Views |
DISTINCT_COUNT_ SUPPORTED |
NO |
|
STATISTICAL_FUNCTIONS_SUPPORTED |
NO |
|
USE_SCHEMA_NAME |
YES |
|
USE_SCHEMA_NAME_FROM_RPD |
YES |
|
DEFAULT_SCHEMA_NAME |
"SIEBEL" |
Name used as the table schema name, if either the repository schema name can not be determined, or if USE_SCHEMA_NAME_ FROM_RPD is set to NO. |
CUBE_VIEWS_SCHEMA_ NAME |
"SIEBEL" |
The Cube Views metadata is created under this schema. |
LOG_FAILURES |
YES |
|
LOG_SUCCESS |
NO |
|
LOG_FILE_NAME |
"\SiebelAnalytics\Log\ CubeViews.Log" |
Or other valid path. |
Cluster (found in NQCluster Confg.INI file) |
ENABLE_CONTROLLER |
NO |
Analytics Server clustering is enabled via NQSConfig.INI. |
PRIMARY_CONTROLLER |
"<machine_name>" |
DNS name of Primary Cluster Controller. |
SECONDARY_CONTROLLER |
"<machine_name>" |
Secondary Cluster Controller; must be distinct from PRIMARY_CONTROLLER. |
SERVERS |
"<analytics_server_ name01>" |
<analytics_server_name02> List up to 16 unique Siebel Analytics Server machines. |
MASTER_SERVER |
"<analytics_server_name>" |
DNS of the Analytics Server machine holding master copies of repositories. NOTE: Must be in SERVERS list.
|
Cluster (continued) |
SERVER_POLL_SECONDS |
5 |
Polling frequency: Analytics Server to Cluster Controller. |
CONTROLLER_POLL_ SECONDS |
5 |
Polling frequency: Cluster Controller to Cluster Controller. |
CLIENT_SERVER_PORT |
9703 |
Outfacing port for ODBC connections on the Analytics servers (called RCP_SERVICE_OR_PORT in the NQSConfig.INI file). Replaces SERVER_PORT. NOTE: Not registered with IANA; must be verified.
|
CLIENT_CONTROLLER_ PORT |
9706 |
Outfacing port for clustered ODBC connections on the Cluster Controllers. Replaces CONTROLLER_PORT. NOTE: Not registered with IANA; must be verified.
|
MONITOR_CONTROLLER_ PORT |
9700 |
TCP/UDP port for intracluster communication with clustered Analytics Servers. NOTE: Not registered with IANA; must be verified.
|
MONITOR_SERVER_PORT |
9701 |
SERVER_MANAGER_PORT |
9702 |
Port used by the Server Manager. NOTE: Needed only on UNIX.
|