Report Portal

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.

Read more...

 

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.