SSRS-MDX parameters for Date

• kk_tech

  Default port

  Points: 1492

  More actions

  August 21, 2017 at 8:48 am

  #338805

  How to use MDX parameter for Date in WHERE clause. 
  Here is my WHERE clause in MDX query, I would like to select Date parameter as a parameter and pass it to MDX before report get executed. 

  [Time].[Date].[Day].&[2017-08-18T00:00:00]

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  August 22, 2017 at 11:54 am

  #1956224

  Look here:   https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e44c5315-43ca-45e6-b119-b43a4d5e6fb8/how-to-pass-parameter-in-mdx-query-using-management-studio?forum=sqlanalysisservices

  which also links to here:  http://prologika.com/how-to-test-ssrs-mdx-queries-in-sql-server-management-studio/

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• kk_tech

  Default port

  Points: 1492

  More actions

  August 22, 2017 at 1:33 pm

  #1956241

  Hi Sgmunson,
  Thank you for your reply, However I am looking to use parameter in SSRS.

• matak

  SSCrazy

  Points: 2674

  More actions

  August 24, 2017 at 6:55 pm

  #1956744

  Try adding the where statement like below.

  SELECT NON EMPTY { [Measures].[Measure1] } ON COLUMNS
FROM [Cube] 
where (strtomember(@Parameter))

  Make sure you set up the Parameter properly for the query - you need to choose the correct dimension and hierarchy to make it work.