InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:54:11 GMT20http://www.sqlservercentral.com/Forums/Topic1063692-2861-1.aspxAnother quite good lesson:[url=Another quite good lesson: http://www.learn-with-video-tutorials.com/mdx-video-tutorial-free]http://www.learn-with-video-tutorials.com/mdx-video-tutorial-free[/url]Fri, 17 Aug 2012 01:47:37 GMTarturm_007http://www.sqlservercentral.com/Forums/Topic1063692-2861-1.aspxI get this error for the below code:Query (11, 7) Parser: The syntax for 'ORDER' is incorrect.[code="other"]-- SMDX003-004 Simple Use of Order() function across columns, -- sort descending(respecting hierarchies) SELECT NONEMPTY ORDER( {[Geography].[Geography].[State-Province].[Alabama].CHILDREN, [Geography].[Geography].[State-Province].[Mississippi].CHILDREN}, [Measures].[Reseller Sales Amount], DESC ) ON AXIS(0), {[Measures].[Reseller Sales Amount]} ON AXIS(1)FROM [Adventure Works][/code]What's wrong with the syntax?TIA,RobTue, 18 Oct 2011 12:27:22 GMTrgtfthttp://www.sqlservercentral.com/Forums/Topic1063692-2861-1.aspxI'm going to leave this right here, even though I think it might just get answered in the next Stairway article.In the example from STEP 3, how could I sort by Resellers Sales Amount DESC without the State_Province natural heirarchy breaking it up into what to me is two separate sorGed lists. I want to see Resellers Sales Amount in DESC order with out grouping by state.Great article so far. It's giving me the kick start to MDX that I needed (I wanted to learn MDX but didn't know where to start).EDIT: Just as I thought. BASC and BDESC will do this and are explained in the next StepJeff.Mon, 29 Aug 2011 15:07:55 GMTjeff122877http://www.sqlservercentral.com/Forums/Topic1063692-2861-1.aspxItem 3 code mismatch: {[Geography].[Geography].[State-Province].[Alabama].CHILDREN, [Geography].[Geography].[State-Province].[Alabama].CHILDREN}s/b Alabama, MississippiThu, 03 Mar 2011 13:54:01 GMTRoland Brownhttp://www.sqlservercentral.com/Forums/Topic1063692-2861-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/Maintaining+cube+hierarchies/72255/"> Stairway to MDX - STEP 3: The Order() Function</A>[/B]Mon, 14 Feb 2011 10:37:11 GMTBill_Pearson