Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2005
    Posts
    41

    Unanswered: MDX query ORDER (was "syntax error")

    " ORDER ( [Accounting Date].[Account Week].Members , DESC ) ON ROWS "

    what is wrong with this line???

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    1. the BY keyword is missing
    2. the database/table/column names appear mixed up
    3. the comma shouldn't be there
    4. the parentheses shouldn't be there
    5. the ON ROWS shouldn't be there
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2005
    Posts
    41
    im using MDX not sql yeah???

    any ideas for my date sorting query


    THANKS 4 REPLYIN!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what's MDX?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2005
    Posts
    41
    when using cubes in analysis manager????

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yeah, sorry, i had never heard of it, but a quick search on google showed some interesting results

    for example, i don't see an ORDER clause

    http://msdn.microsoft.com/library/en...asics_0v7d.asp
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2005
    Posts
    41
    thanks mate...
    order is introduced when you wnat to sort teh result!!!

    Thanks enyway!!! : )

  8. #8
    Join Date
    Feb 2005
    Posts
    41

    MDX query

    I am creating a OLAP system, where a result table row is a time property. They have options of year, quarter, month or week.

    It is all working fine, and actually creates the MDX query depending on the users choice of time property!!! problem is if they choose month or week, the result is in no order.... I want the system to display the results in order eg week 1 - week 52


    any ideas????

  9. #9
    Join Date
    Feb 2005
    Posts
    41

    Mdx

    I am creating a system, where the result table has a row with time in it The user has the option of seeing the data on year, quarter, month or week.

    It is all working fine, and actually creates the MDX query depending on the users choice is of teh above!!! problem is if they choose month or week, the result is in no order.... I want the system to display the results in order eg week 1 - week 52


    any ideas????

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    [ moderator note: merging this thread with your other one that is essentially the same question ]
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •