Registry Settings - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities

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.

Teradata OLAP Connector Registry Settings 
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.