Teradata OLAP Connector has a sophisticated caching architecture to provide high performance ad hoc queries.
Dimension metadata, except members, are read in and kept permanently in RAM for the duration of the ODBO session. Each ODBO session has a unique cache, so when multiple sessions are open by the same user on the same machine, each session will have a unique cache. Dimension member metadata is kept in a transient member cache. OLAP measure cell values are cached using a Least Recently Used (LRU) mechanism.
This appendix contains descriptions of the caching mechanisms and the changeable settings.
Do not change cache settings without consulting with the Teradata Global Support Center. For the location of these settings, see Teradata OLAP Connector Registry Settings