Creating Dimensions

Abstract

This is possibly the most important chapter in the book. Although measures are what we’re after, dimensions are the framework on which we’ll build our cubes. Dimension names give us the nomenclature we’ll use to break down our data, attributes will give us additional information about the members, and the members themselves provide the semantic points against which our measure data will be arrayed. Finally, well-designed dimension and attribute relationships will ensure the scalability of our cube solutions.