Re: MDX ORDER Riddle
Boyan Penev recently blogged about a strange behavior which manifests when ordering two related sets thereby mentioning a thread in SSAS forum answered by Deepak Puri. I found this intriguing and decided to reply directly, but the explanation kept growing, so I finally cut everything out and put it as an article on my blog instead. After all, this way my chances of being enlisted in his blog roll should increase 8-).
Here's the problem in short. The first query works, the second doesn't. The difference? The second query has related hierarchies while the first one doesn't.
Tags: mdx