34 IBM Cognos Dynamic Cubes
thought of as the primary cache of a dynamic cube, but not of virtual cubes, which do not
support aggregate caches.
If a cube is not assigned an aggregate cache, the data cache becomes the primary cache.
Otherwise, it plays a secondary role, caching the values that do not directly hit the aggregate
cache.
2.5 Using the database to evaluate set expressions
For particular MDX functions, given a sufficiently large input set, Cognos Dynamic Cubes
pushes the evaluation of the expression to the underlying database for execution. Without this
feature, those MDX functions, such as TOPCOUNT, retrieve large sets of data from the
database and perform the function in the MDX engine. The transfer of the large data sets,
which can ...