Chapter Summary
| To | Do this |
|---|
| Add a comment to an MDX query | Enter double slash characters (//) before the comment. |
| Include all the members of the Product Name level on the column axis | Use the clause [Product Name].Members ON COLUMNS. |
| Put sets of members on two axes | Use both ON COLUMNS and ON ROWS in a query. |
| Create a set from explicit members | Enclose the list of members separated by commas, between opening braces ({) and closing braces (}). |
| Create a set consisting of all possible combinations of two sets | Use the CrossJoin function with the two sets as arguments. |
| Calculate the average of all members of the State level of the State dimension | Use the expression Avg([State].[State].Members). |
| Calculate an aggregation by using each measure’s aggregation function | Use the Aggregate function. |
| Calculate the cumulative total restarting with each new member of the Calendar Year level | Use the expression Sum(PeriodsToDate([Calendar Year])). |
| Calculate a numeric value of the Price member property of the current member of the Product dimension | Use the expression CDbl([Product].Properties(“Price”)). |
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.
