Summary

In this chapter, we have covered the techniques used to create a dimensional data model using a relational data source. We have covered the creation of dimensions, including dimensions with multiple hierarchies, measures, and scope relationships.

By using the techniques in this chapter, we can produce a Framework model that we can use with IBM Cognos Analysis Studio. We can also use the Framework model with Query Studio and Studio.

In the next chapter, we will look at enhancing our model by creating the business and presentation layers, which we will later publish for use by our report authors.

Get IBM Cognos 10 Framework Manager 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.