You can configure Teradata OLAP Connector to cache MDX query results, which provides the advantage of instant turnaround time for previously executed queries. For BI clients such as Excel which often re-execute the same query again (drill down and then collapse back up), this improves the query execution time.
MDX query result caching is configured through the following Windows Registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Teradata\Client\15.10\Teradata OLAP Connector\RuntimeSettings
If a 32-bit Teradata OLAP Connector is installed on a 64-bit OS, the registry key is defined as:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Teradata\Client\15.10\Teradata OLAP Connector\RuntimeSettings
The following values in the registry key are used to configure MDX query result caching:
- UseQueryResultCache specifies whether to use MDX query result caching.
- QueryResultCacheCount specifies the number of query results to cache.
- CacheResultsWithCalcEntities specifies whether results for MDX queries containing calculated members should be cached.