Teradata OLAP Connector attempts to minimize the number of Teradata Database retrievals used to satisfy member metadata requests by prefetching members. When a request is made for a single member or for the children of a member, all members on that level are retrieved and cached. The maximum size of a level that is subject to prefetching can be configured using the PrefetchLevelSize registry key. This value defaults to 20,000 members. To disable member prefetching, set the value to 0.
Teradata OLAP Connector also attempts to prefetch measures with a SUM aggregator. The MaxMeasuresForPrefetch registry key specifies the maximum number of measures to prefetch. This value defaults to 20. When the number of measures in the cube exceeds this value, Teradata OLAP Connector retrieves the first N measures where N is the value specified in the registry. Setting the registry value to 0 disables measure prefetching.