Hi @greg lipman ,
You cannot use expression Parameters!FromPolEffFullDate.Value in your dataset query except it’s dynamic query like this: =“select {} on 0 from”+ “cube”
To pass a parameter value from SSRS to MDX, you could refer to:
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/7ae1c5ef-98de-468a-bc28-b7c3ed4ad377
But I would suggest you generate query with parameter automatically via drag and drop, and then you will see how SSRS handle these kinds of query.
To write MDX query with parameter by yourself , you could refer to:
SSRS: How can i use a Parameter in MDX Query?
Total confusion around using Time as a filter paramete
How can we parameterize top N in MDX
Hope this helps.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.