6-2199-3eBook.book Page 187 Wednesday, March 1, 2006 5:05 PM Chapter 8: Using MDX 187 The Parent function works best when you use it in combination with a user hierarchy. This function returns the member that is the parent of the current member of the spec- ified hierarchy. 5. Select "Percent" in the Format String drop-down list, and select Reseller Sales Amount in the Non-Empty Behavior drop-down list. 6. Deploy the project, open the browser after deployment is finished, and then click Reconnect. 7. Drag Product Percent of Parent into the grid, drag Category off of rows and drop it any- where in the metadata pane, and then drag the Product Category hierarchy as rows. 8. In the grid, expand Bikes. The grid looks like this: Compare the measures Category Percent of Total to Product Percent of Parent at the Cat- egory and Subcategory levels. At the category level, the two
Share
