Databases Reference
In-Depth Information
Figure 8-8
Deploy the project to the Analysis Services instance. To make sure the custom rol-
lup column MDX expression is correctly evaluated for the Average Unit Price ac-
count, go to the Cube Browser and browse the Accounts dimension and the meas-
ure Amount from the Fact Finance measure group. You will see the value for Aver-
age Unit Price is now calculated using the MDX expression as shown in
Figure
8-9
. Using a calculator you can easily verify that the value for Average Unit Price
is equal to the value of Net Sales divided by the Units.
Search WWH ::
Custom Search