Databases Reference
In-Depth Information
Figure 9-49
You can verify the AggregateFunction property of the measures that are ex-
pected to be changed by the selections in the semi-additive behavior en-
hancement through the Business Intelligence Wizard. You learned the semi-
to see the results of LastNonEmpty and AverageOfChildrence semi-additive
aggregate functions deploy the sample Adventure Works DW database and
browse the measures in the Exchange Rate in the Cube Browser along with
the Date.Fiscal hierarchy and DestinationCurrency.DestinationCurrency hier-
archy as shown in
Figure 9-50
. You can see the value for the members in the
Date.Fiscal hierarchy are calculated based on the aggregate functions
LastNonEmpty (for End of Day Rate measure) and AverageOfChildren (for
AverageRate measure) applied to their children.
Search WWH ::
Custom Search