I agree. The main misconception, I think, is that a CASE statement behaves differently when used in an ORDER BY clause. It doesn't.

If you're confused by any of this, first read sknox's first post above. Understanding that makes all of the mysteries go away.

Here's a tip if it's still not clear....

Trick question, since it's not an acronym at all.

Come to think of it, it could be an acronym if you pronounced it "spee" or "spy" or something like that.

Nice article.

When Jeff said, "even though the DateGroup looks like a date, it really doesn't mean anything," he was fibbing a bit, probably to keep unnecessary detail out of the...

I don't think a bug is causing this. It might be one of:

1. Whatever you're using to browse the dimension is looking at an old copy. Try hitting...

Assuming MOLAP all the way, you need to process the dimension to have it pick up changes in the underlying dimension table. Then you should be able to process...