MDX Basic query

• Lord Slaagh

  SSCertifiable

  Points: 5741

  More actions

  May 14, 2014 at 12:51 pm

  #148394

  Hello,

  I am trying to get a good understanding of how to write MDX. I have been using SSAS for a few years, but I never had to write MDX queries. So based on the following example this looks like a pivot to me. Also, the ON ROWS part of this query is a Tuple set because there is more than one tuple? A tuple is simple a slice of data correct?

  SELECT

  { [Measures].[Sales Amount],

  [Measures].[Tax Amount] } ON COLUMNS,

  { [Date].[Fiscal].[Fiscal Year].&[2002],

  [Date].[Fiscal].[Fiscal Year].&[2003] } ON ROWS

  FROM [Adventure Works]

  WHERE ( [Sales Territory].[Southwest] )

  The are no problems, only solutions. --John Lennon

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 23, 2014 at 4:07 am

  #1716000

  http://msdn.microsoft.com/en-us/library/ms145514.aspx

  http://technet.microsoft.com/en-us/library/aa216769%28v=sql.80%29.aspx

  🙂

  ---

  I'm on LinkedIn