Parameterized MDX query in SSRS report - Getting error

• mba.amitpatel

  Newbie

  Points: 5

  More actions

  September 25, 2009 at 10:20 am

  #211414

  This is the code I wrote for dataset

  ="with

  MEMBER [MEASURES].[Description] AS '[Employee].[All Members].Properties( "MemberDescription" )'

  MEMBER [MEASURES].[Name] AS '[Employee].[All Members].Properties( "MemberName" )'

  MEMBER [MEASURES].[Department] AS '[Employee].[All Members].Properties( "Department" )'

  MEMBER [MEASURES].[Hire Date] AS '[Employee].[All Members].Properties( "Hire Date" )'

  MEMBER [MEASURES].[Job Title] AS '[Employee].[All Members].Properties( "Job Title" )'

  SELECT

  { [MEASURES].[Name], [MEASURES].[Description], [MEASURES].[Department], [MEASURES].[Hire Date], [MEASURES].[Job Title]} ON COLUMNS,

  { ("+ Parameters!EmployeeID.Value +") } ON ROWS FROM [Employee Labor]"

  Here Parameters!EmployeeID.Value is UniqueName like [Employee].[All Members].[Employee].&[10795]

  and I declared it as a report parameter.

  I am keep getting errors like End of Statement expected,,,,,or Expecting Tuple value,,,String or Numeric passed.

  I will really appreciate if someone help me on this...

• drew.allen

  SSC Guru

  Points: 77014

  More actions

  September 25, 2009 at 5:59 pm

  #1058703

  You need to use StrToMember() to convert your parameter value to a member.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA