Amount Filteration based on Current Month,Quarter And Year

• raghavag7

  SSC Veteran

  Points: 203

  More actions

  October 23, 2014 at 11:05 pm

  #397555

  i want amount filteration based on

  Current Year,

  Current Quarter,

  Current Month And

  Last Quarter to Current Quarter Growth.

  Here am using mdx query level am trying ,i dont have any hirarechy in date dimension

  could you pls help anyone.

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  October 24, 2014 at 12:39 am

  #1754536

  Developing a Time Dimension with SQL Server 2008 R2 Analysis Services

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP