246 IBM Cognos Dynamic Cubes
9.1 Overview of the dynamic cube lifecycle
The main objective of customers that use Cognos Dynamics Cubes is to have cubes and
reports available to their users for actual business usage. A substantial amount of work must
be done for this availability to occur. Figure 9-1 illustrates, at a high-level, the basic Cognos
Dynamic Cubes workflow and the primary tools that are used to perform the main activities in
the cycle.
Figure 9-1 Relationships between Cognos Dynamic Cubes activities and tools
This section describes each of the workflow activities.
9.1.1 Analyze
Although the initial stage of the lifecycle is not part of the ongoing cycle, it is still an important
part of the process. It is where the architects look at their data, hardware, business
requirements, and so on, and prepare for implementing Cognos Dynamic Cubes. In this
stage, architects do the following tasks:
򐂰 Determine business requirements
򐂰 Design the database physical model
򐂰 Acquire the appropriate hardware
򐂰 Install and configure Cognos Dynamic Cubes
9.1.2 Model
The objective of this stage is to design and create a functional dynamic cube by using IBM
Cognos Cube Designer. A system analyst determines the high-level business requirements; a
modeler creates a dynamic cube to satisfy those requirements. In this stage, a modeler can
do the following tasks:
򐂰 Create measures, dimensions, and hierarchies
򐂰 Define and model security filters and views
򐂰 Model aggregate cubes
򐂰 Publish cubes and packages

Get IBM Cognos Dynamic Cubes now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.