SSRS Cascading Parameters Using SSAS Tabular
Hello everyone
Im using SSRS 2012 to connect to a SSAS Tabular Data Source. I have two parameters that Im using: State and City. The desired behavior is to select a State, and then select a city that ONLY belongs to the selected State.
I have been able to do this successfully connecting to a standard SQL Server Database, but am having problems with the Tabular and MDX.
Any help with this would be greatly appreciated.
Have a great weekend!
July 27th, 2012 6:18pm
HI iaaw !
You can cascade the report parameters by using following expression in your dataset properties, fields change query and calculated fields,
=Fields!State.Value
Write this expression in your city dataset.
Also, please have a look at below article;
http://sqlblog.com/blogs/davide_mauri/archive/2010/08/10/reporting-services-mdx-and-the-unwanted-cascading-parameters.aspx
Please let me know if this helps. Hopefully i have answered you correctly.
Thanks, Hasham
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2012 5:43pm