Bill_Pearson - Monday, February 14, 2011 10:37 AM
I suppose I'll get flamed for this idea!
Once again I'm wondering why MDX doesn't borrow as much as possible from ANSI SQL. In this case, the ORDER BY clause. Imagine you could do this:
SELECT
[Measures].[Reseller Sales Amount] OVER(AXIS 0) as rsa,
[Geography].[Geography].[State-Province].[Alabama].CHILDREN OVER(AXIS 1) AS alabama,
[Geography].[Geography].[State-Province].[Mississippi].CHILDREN OVER(AXIS 1) AS miss
FROM AdventureWorks
WHERE <something> IS NOT NULL
ORDER BY alabama, miss, rsa DESC
No braces, no functions. Just SQL with some extra elements. That kind of thing would flatten the learning curve a bit, I think.
Alas! The ship has sailed.