Passing parameter to MDX query
Hi i am using following MDX query in my report SELECT NONEMPTY { [Measures].[Page Viewed Count] }ONCOLUMNS,NONEMPTY FILTER ({ ([Doc].[Title].[Title].ALLMEMBERS * [Doc].[Practice Area].[Practice Area].ALLMEMBERS * [Doc].[Chapter].[Chapter]. ALLMEMBERS * [DetailDate].[Month].[Month].ALLMEMBERS ) }, [Doc].[Title]. CurrentMember.MemberValue = "Title name") DIMENSIONPROPERTIESMEMBER_CAPTION, MEMBER_UNIQUE_NAME ONROWS FROM [DWOnLAW] CELLPROPERTIESVALUE,BACK_COLOR,FORE_COLOR,FORMATTED_VALUE,FORMAT_STRING, FONT_NAME,FONT_SIZE,FONT_FLAGS I want to pass title name as parameter. If i give like below, [Doc].[Title].CurrentMember.MemberValue = @Title its saying parameter not declared.I declared the parameter already. What is the error? how i can pass parameter to the mdx query? Thank you
November 10th, 2012 5:23pm

Please see these similar threads: http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/8259343a-85de-4aaa-ba13-59d73cdfb1c6 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/7ae1c5ef-98de-468a-bc28-b7c3ed4ad377Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2012 11:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics