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