Chapter Summary

ToDo this
Use different aggregation methods for each member of a parent-child dimensionAdd a column to the dimension table containing the codes + for addition, - for subtraction, and ~ for no aggregation. Then assign that column by using the dialog box for the Unary Operators property.
Add a custom formula to a specific member of a parent-child dimensionAdd a column to the dimension table and store in it an MDX expression. Then assign that column to the level by using the dialog box for the Custom Members property.
Enable drillthrough for a cubeIn the Cube Editor, click Drillthrough Options on the Tools menu to open the Cube Drillthrough Options dialog box. Select Enable Drillthrough.
Automatically divide members of a level into ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.