May 2013
Intermediate to advanced
186 pages
3h 45m
English
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.
Read now
Unlock full access