Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MDX - Combining members of the same dimension
Your solution gives a separate column for each month and year value, which isn't what I'm looking for (apologies for the vague wording of the original question). I actually want there to be a column called 'Year', containing rows of year values, and a separate column called 'Month' containing... -
MDX - Combining members of the same dimension
How do you combine members of the same dimension, such that each member will appear in a separate column? For example, in order to display Year and Month in separate columns. The CrossJoin() function does not allow you to combine members of the same dimension, and the Union() function merges...
