MDX query to get Patient Count measure aggregation for last 36 month from Year End

• dk98681

  SSC-Addicted

  Points: 497

  More actions

  February 19, 2017 at 4:06 pm

  #318873

  How can I write an MDX query to get Patient Count measure aggregation for last 36 month from Year End.

  I am using SSAS on SQL Server 2014. My cube is named BR. I have a Patient Count Dimension and Accounting Date dimension.  Accounting Date has members year, month, quarter and properties Current Period and Year End Period.

  CREATE MEMBER CURRENTCUBE.[Measures].[Year End Period]
   AS [Accounting Date].[Accounting Date].Properties( "Year End Period" ), 
  VISIBLE = 1; 

  Following query gives  DEC - 2017. 

   SELECT NON EMPTY { [Measures].[Year End Period] } ON COLUMNS FROM [BR] 

  How can I utilize this to get patient count for last 36 months from this period?

  Thanks in advance for you help.