IBM Cognos Dynamic Cubes

10 IBM Cognos Dynamic Cubes

2.1 Dynamic cubes in the IBM Cognos environment

Dynamic cubes are in-memory OLAP containers that reside within a DQM server. Dynamic

cubes are sourced from a star or snowflake data warehouse, stored in a relational database

that is contained in any one of the supported relational databases. Figure 2-1 shows multiple

computing nodes that host Cognos report and DQM servers, which support a dynamic cube

that accesses a relational data warehouse.

Figure 2-1 A high level representation of the Cognos Dynamic Cubes architecture

Dynamic cubes are modeled in the IBM Cognos Cube Designer. After modeling is complete,

cube models are then published to the IBM Cognos Content Manager (CM) as a Cognos

Dynamic Cubes data source. From within the IBM Cognos Administration console, an

administrator can assign a dynamic cube to one or more dispatchers and configure the

properties of the cube on each dispatcher, for example, defining the amount of space that is

allotted for in-memory aggregates.

After a cube is assigned to a dispatcher and configured, it can be started, at which time the

DQM server loads the cube model from CM and loads all dimensional members into its

member cache. Then at this time, it is made available for processing of reports and analyses.