So we have a collection of dimensions, and a pile of data in our database. The question is—now what? To get value from our data and the work we’ve done so far, we need to assemble the dimensions into a cube. That’s what we’re going to do in this chapter. In addition to building a cube from our dimensions, we’ll also look into calculated measures (deriving additional values from existing values), partitions (dividing data to ease management), and a deeper dive into aggregations and their design.
KeywordsProduct Category Fact Data Analysis Service Measure Group Fact Table
Unable to display preview. Download preview PDF.