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.
KeywordsData Warehouse Attribute Relationship Client Application Analysis Service Fact Table
Unable to display preview. Download preview PDF.