The first four settings in the table are cache and prefetch oriented. To understand these settings before changing them, you must read BI Model Repository Grants Script.
Key | Type | Default | Value |
---|---|---|---|
CacheResultsWithCalcEntities | DWORD | 1 | Specifies whether to cache the results for MDX queries that contain calculated members. Valid values are: 0 – Disable result caching for queries that contain calculated members. 1 – Enable result caching for queries that contain calculated members. |
MaxCellCacheSize | DWORD | 100 | Approximately specifies the maximum size of the measure cell cache in MB. To disable cell cache, set value to 0. |
MaxMetadataCacheSize | DWORD | 1000000 | Specifies the maximum size of the dimension member metadata cache. The quantity specified is the maximum number of members to keep in cache between MDX queries. To disable cache, set value to 0. |
PrefetchLevelSize | DWORD | 20000 | Teradata OLAP Connector always attempts to prefetch all dimension members in a level. If the level size exceeds this value, the level does not prefetch. To disable prefetching, set the value to 0. |
MaxMeasuresForPrefetch | DWORD | 20 | The maximum number of measures to prefetch. To disable prefetching, set the value to 0. |
MaxCachedCalculatedSetSize | DWORD | 10000 | Specifies the maximum number of members in a calculated set. If the set exceeds this size, the set is not cached. |
QueryResultCacheCount | DWORD | 10 | The number of MDX Query results to cache. To disable the cache, set the value to 0. |
UseQueryResultCache | DWORD | 0 | Specifies whether to cache MDX query results. Valid values are: 0 – Disable caching 1 – Enable caching |
SqlQueryTimeout | DWORD | ODBC driver default | Specifies the amount of time, in seconds, an SQL query should wait before returning to the application. |