Hi,

I have one dashboard and one filter in PPS. Dashboard contains one main analytical chart report-- sales by Product category and the filter name is Year (contains the members values from 2005 to 2014).

I have one more drillthrough report--- Detailed report for sales by product category (SSRS report)

SSRS report having two parameters 1. year  (Multi selection) 2. Product category (single selection)

Now, I have select 2006,2008 in the pps filter and analytical chart report rendered based on the filter values.

next, on the analytical chart, I have selected on bar item (cars) out of 4 categories(Cars,Bikes,Trucks,Accessoreis) and right click -->drillthrough-->click on Detailed report for sales by product category.

I have verified the ssrs detailed report and pps is passing only ALL member instead of passing 2006 and 2008 to the Year filter and Cars category members correctly passed to product category parameter from PPS.

Note: If I have passed one member values (year=2006), pps is able to pass to ssrs report. But, it failed in two or more member values from filter.

I have verified in sql profiler also. PPS passing ALL member to SSRS detailed report Year parameter.

Please provide your suggestions. 

Thanks,

kishore