MDX Puzzle - 04 Feb 2000

If you have a set of members defined as the following:

CREATE SET \[Sales\].\[97Quarters\] AS
'\{ \[1997\].Children \}'

how can you write an MDX query that reverses the order of this set?

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.