© Copyright IBM Corp. 2012. All rights reserved. 59
Chapter 4. Modeling dynamic cubes
This chapter describes how to use the IBM Cognos Cube Designer to design and deploy
dynamic cubes, how to model cube dimensions, and how to validate and analyze the models
you create. Also included is information about troubleshooting the models and creating a
sample cube.
This chapter contains the following sections:
4.1, “Introduction to IBM Cognos Cube Designer” on page 60
4.2, “Working with Cognos Cube Designer” on page 60
4.3, “Modeling dimensions” on page 70
4.4, “Calculated members” on page 78
4.5, “Modeling time dimensions for relative time” on page 78
4.6, “Slowly changing dimensions” on page 79
4.7, “Role-playing dimensions” on page 82
4.8, “Multi-grain fact scenarios” on page 84
4.9, “Aggregate cubes” on page 85
4.10, “Validation” on page 90
4.11, “Deploying dynamic cubes for reporting and analysis” on page 91
4.12, “Troubleshooting” on page 92
4.13, “Creating a sample cube model by using GOSLDW” on page 95
4
Get IBM Cognos Dynamic Cubes now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
