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

• DATABASE
• BYPASS_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.