Databases Reference
In-Depth Information
Adding Intelligence to the Cube
Similar to adding intelligence to Dimensions that you learned in
Chapter 8
you
can add intelligence to the Cube.
Figure 9-48
shows the various enhance-
ments that can be done to a Cube using the Business Intelligence Wizard. You
have learned most of these enhancements in earlier chapters. In this chapter
you will learn the enhancements to define and understand semi-additive beha-
vior as well as defining currency conversion whenever fact data needs to be
converted to appropriate local currency.
Figure 9-48
Semi-Additive Measures
Semi-additive measures are measures whose data is not aggregated as sum
or count to over the various levels on a hierarchy. The semi-additive aggregate
functions for measures are ByAccount, AverageOfChildren, FirstChild,
LastChild, FirstNonEmpty, LastNonEmpty and None. For example, assume
you have a Time hierarchy and the measure Sales value to be rolled up aver-
age of the sales of it's children. Assume the levels in the Time hierarchy are
Year, Half Year, Quarters, Months and Date. If you have a member Quarter 1
Search WWH ::
Custom Search