General Section

###############################################################################
#
#  General Section
#
#  Contains general server default parameters, including localization
#  and internationalization, temporary space and memory allocation,
#  and other default parameters used to determine how data is returned
#  from the server to a client.
#
###############################################################################

[ GENERAL ]

// Localization/Internationalization parameters.
LOCALE = "English-usa";
SORT_ORDER_LOCALE = "English-usa";
SORT_TYPE = "binary";

// Case sensitivity should be set to match the remote
// target database.
CASE_SENSITIVE_CHARACTER_COMPARISON = OFF ;
// SQLServer65 sorts nulls first, whereas Oracle sorts
// nulls last. This ini file property should conform to
// that of the remote target database, if there is a
// single remote database. Otherwise, choose the order
// that matches the predominant database (i.e. on the
// basis of data volume, frequency of access, sort
// performance, network bandwidth).
NULL_VALUES_SORT_FIRST = OFF;


DATE_TIME_DISPLAY_FORMAT = "yyyy/mm/dd hh:mi:ss" ;
DATE_DISPLAY_FORMAT = "yyyy/mm/dd" ;
TIME_DISPLAY_FORMAT = "hh:mi:ss" ;


// Temporary space, memory, and resource allocation
// parameters.
// You may use KB, MB for memory size.

WORK_DIRECTORY_PATHS = "C:\OracleBIData\tmp";
SORT_MEMORY_SIZE = 4 MB ;
SORT_BUFFER_INCREMENT_SIZE = 256 KB ;
VIRTUAL_TABLE_PAGE_SIZE = 128 KB ;


// Analytics Server will return all month and day names as three
// letter abbreviations (e.g., "Jan", "Feb", "Sat", "Sun").
// To use complete names, set the following values to YES.
USE_LONG_MONTH_NAMES = NO;
USE_LONG_DAY_NAMES = NO;

UPPERCASE_USERNAME_FOR_INITBLOCK = NO ;   // default is no

// Aggregate Persistence defaults
// The prefix must be between 1 and 8 characters long
// and should not have any special characters ('_' is allowed).

AGGREGATE_PREFIX = "SA_" ;


###############################################################################