Hi,

I have created cascade parameters (p1,p2 &p3) in SSRS and added mdx query to set defualt value in p2 & p3
When I used a dynamic mdx query to set default value, then p3 is not refreshed dynamically and it shows previous values itself.

But when I removed default values its working correctly.

Is this issue related to dynamic query?.Any suggestions?.
Any help is appreciated..

Thanks,
pvn

are you sure you are using correct data set for default values for p3?

Hi Bhawesh,

Its working correct for the first time whne I select value for p1. But the problem is when I select second value for p1 it dynamically set the default value for p2 but not loading correct values in p3 according to the value of p2.

You go the issue?..

Thanks in advance..

Hello,

A duplicate post, please see my reply in this thread below: 
http://social.technet.microsoft.com/Forums/en-US/5ca2df36-5986-49bb-bebd-dafe4c30d0cf/cascaded-parameter-are-not-refreshing-correctly

Best Regads,