Results 1 to 2 of 2

Thread: Sort MDX Query

  1. #1
    Join Date
    Feb 2005

    Unanswered: Sort MDX Query

    Trying to get data from result of MDX query in dec order:

    iLoopFrom = cst.Axes(1).Positions.Count - 1
    iLoopTo = 0
    iLoopStep = -1

    im using these lines to read the data from bottom to top but what exactly does Position.Count do? and is the -1 there because the result has headers??


  2. #2
    Join Date
    Feb 2005
    I'm trying to sort the result of a query (MDX on a cube). I have tried using the Order funtion as follows:
    Order (X.[Accounting Date].Children, ASC)}) ON ROWS

    x being the connection result of query!

    but it comes up with error:

    Cannot use parentheses when calling a Sub

    what am i doing wrong???

Posting Permissions

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