Database Reference
In-Depth Information
Figure 11-16.
Browsing the cube measures
With our first look, the values are readily apparent. For example, the Fact Sales count indicates that there are
21 rows in the Fact Sales table (Figure
11-16
). The Sales Quantity measure indicates that the grand quantity of sales
is 493. But, the Author Order measure is showing that there are 34 “somethings”—but this is nonsensical data.
As it turns out, Author Order indicates the order in which each author appears on a title's cover—first,
second, or third. Because the default behavior of a measure summarizes the values, the grand total of the sum
of 1, 2, and 3 for all the rows in the Author Order is apparently 34. Now that we see this value, we know that the
Author Order requires configuring before it is useful.
Similarly, the Fact Titles Authors Count indicates that there are 25 rows in the FactTitlesAuthors table. At
first this may seem somewhat useless, but when combined with a specific title or a specific author, we can tell
how many titles are associated with the authors using this measure. So, this measure also needs to be configured
before it is useful.
Review the Dimensions
Next, let's add some dimension values to get a clearer picture of our measures. Drag the title into the viewing
pane. Figure
11-17
shows an example of the results.
Figure 11-17.
Adding the titles attribute to the report
