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.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.