Chapter Summary
| To | Do this |
|---|---|
| Return an empty value from an MDX expression | Use the keyword Null. |
| Calculate the ancestor of the current product at the Category level | Use the expression Ancestor(Product.CurrentMember, Category). |
| Test for an empty cell | Use the IsEmpty function. |
| Make a choice based on a conditional expression | Use the IIF function. |
| Display the value of a member property named Test for the current member of the Product dimension | Use the expression Product.CurrentMember.Properties(“Test”). |
| Convert an expression from a string to a number | Use the CDbl function from VBA. |
| Retrieve the value from a specific cell in a cube | Create a tuple, with one member from each dimension separated by commas and enclosed in parentheses. |
| Reference the Sales Units value for ... |
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.
