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

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

Other recent topics Other recent topics