Hello Nidhi,
Can you try something for me as I think it should work.
If I assume you have your parameters in a drop down list, my understanding is that if I update paramUD2 it should "update" differently the "paramUD3" that is contained withing another drop down. If my statement is correct, you could have each drop down component in its own small dashboard. So in your case you would have 3 sub-dashboard for each drop down Account+UD2+UD3. After creating that, you will add a refresh on each dashboard with a correct XFBR function that will list the correct members...
Sorry for being so high level, I hope you understand the concept. I know it works as I did it once. I did a printscreen below. Have a close look at the dashboard...
Hi NicolasArgente ,
Thanks for your response. We have achieved this seamlessly in Dashboard as outlined by you,
When user opens the same in excel form, there the dropdown comes empty.
Could you please guide us how the dependent parameters can be handled in the spreadsheet having the cube view connection?
