Oracle Business Intelligence Infrastructure Installation and Configuration Guide > NQSConfig.INI File Reference >

MDX Member Name Cache Section Parameters in the Configuration File


This is a cache subsystem that maps between a unique name and the captions of members of all SAP/BW cubes in the repository.

ENABLE

This parameter indicates if the feature is enabled or not.

The default it is NO because this only applies to SAP/BW cubes.

DATA_STORAGE_PATH

The path to the location where the cache will be persisted. The applies only to a single location.

The number at the end of the entry indicates the capacity of the storage. When the feature is enabled, the string "<full directory path>" needs to be replaced with a valid path.

Example: DATA_STORAGE_PATH = "C:\OracleBI\server\Data\Temp\Cache" 500 MB ;

MAX_SIZE_PER_USER

Maximum disk space allowed for each user

Example: MAX_SIZE_PER_USER = 100 MB ;

MAX_MEMBER_PER_LEVEL

Maximum number of members in a level will be able to be persisted to disk.

Example: MAX_MEMBER_PER_LEVEL = 1000 ;

MAX_CACHE_SIZE

Maximum size for each individual cache entry size.

Example: MAX_CACHE_SIZE = 100 MB ;

Oracle Business Intelligence Infrastructure Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.