
30 IBM Cognos Dynamic Cubes
2.3.3 Member cache
The hierarchies defined in a cube model are all loaded into memory when the cube starts.
After all hierarchies are loaded, the following actions occur simultaneously:
The cube state is changed to available and it is able to respond to metadata and data
queries.
If a cube has a startup trigger defined, it is executed.
If a cube has in-memory aggregates defined, and space allotted for them, the queries to
retrieve the data are executed.
Members of each hierarchy are retrieved by running a SQL statement to retrieve all of the
attributes for all levels within a hierarchy, including multilingual proper ...