Databases Reference
In-Depth Information
In the properties for an attribute you will see a property called
CustomRollupColumn, as shown in
Figure 8-6
. This property
needs to be set to the relational column that has the MDX ex-
pression for custom rollup formula. The MDX expression specified
in this property gets evaluated on the cells when the value's cor-
responding members of the hierarchy are being retrieved in the
query.
Figure 8-6
7.
The sample AdventureWorksDW relational database provides a column
with custom rollups for the Account dimension. Right-click the DimAccount
table in the DSV of the dimension DimAccount and select Explore Data.
You will see the data in the relational table as shown in
Figure 8-7
. The
relational column CustomMembers contains the MDX expression for cus-
tom rollup. In the AdventureWorksDW relational sample there is an MDX
expression defined for an Account, which has AccountKey = 98 as shown
Search WWH ::
Custom Search