The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Dependent parameters in a spreadsheet having cube view connection
Hi All,
We have a technical blocker for one of the report in our planning application. This report has UD2, UD3 and account as parameters. On the dashboard, this report appears fine when user seam...
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?