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 the top member of the Product dimension | Use the expression ( [Sales Units], Ancestor( Product.CurrentMember, Product.[(All)] ) ). |
| Reference the Sales Units value for the previous time period | Use the expression ( [Sales Units], Time.CurrentMember.PrevMember ). |
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.
