September 30th, 2015 | 11:18
Filtering of your pivot is accomplished by the Slicer Expression with either a Where or %Filter clause. A single measure is part of the Slicer Expression.
September 30th, 2015 | 7:59
The column expression defines what dimensions and measures appear on the columns of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
September 30th, 2015 | 5:54
The row expression defines what dimensions and measures appear on the rows of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
September 30th, 2015 | 10:02
Using the MDX Query window of Analyzer, the syntax of MDX can be viewed. This is a great way to become comfortable with writing your own MDX queries.