Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 4. Data modeling: End to end 171

are performed. The structures for these staging tables are also included

within the model supplied as part of the pack.

Figure 4-62 One of the star schemas included in the Customer Insight Pack

Under the OLAP objects directory of our model, we see the cube “Individual

Cust Dynamics Cube” is defined and ready for either testing within Design

Studio or deployment to the InfoSphere Administration Console.

172 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

7. Using the Browse Members option of the click menu, we can test and view

this OLAP model as shown in Figure 4-63.

Figure 4-63 Viewing OLAP Model components within Design Studio

Finally, within the Cognos directory we have a number of example reports and

dashboards that can be loaded into both Cognos Framework and the IBM

Cognos BI server as starting reports by which to present the data contained

within our database.

In summary and as demonstrated, the InfoSphere Warehouse Packs contain all

the assets needed to help support the development process of creating a Data

Warehouse environment specific to a customer’s requirements.