how to add a parameter to mdx in reporting services

• lberan-754499

  Valued Member

  Points: 70

  More actions

  October 8, 2008 at 12:20 pm

  #382992

  I know little about mdx. I have a query as the following:

  SELECT NON EMPTY { [Measures].[Last 3 Months C], [Measures].[Last 12 Months C], [Measures].[Last Month C] } ON COLUMNS, NON EMPTY { ([Consistent Name].[Consistent Name].ALLMEMBERS * [Stype].[Stype].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Master Cube for SIMS asof 071017] CELL PROPERTIES VALUE

  I need to filter this part: [Consistent Name].[Consistent Name].ALLMEMBERS

  with an input consistentName.

  I tried Where and Filter but neither worked. I must have not used a correct syntax.

  Could anybody modify the above query for me? Thank you very much!

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  October 11, 2008 at 3:42 am

  #883737

  hi,

  i m bit confused but r u looking for something where u can see how to pass parameter in RS?

  if yes then following link will be helpful.

  http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/

  regards,

  vijay