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
Solved
Create a dependent dropdown list in SQL Table Editor
Hi,
Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below:
If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the P...
No, that's not going to work. But you can hide that button and just create yours.
- You can, I would suggest using a dashboard data set rule and then pass the parameter of the first drop down. Then in the rule check if the parameter is expanded. If it is then create a SQL to get the dependent ones and return the data table. On the dashboard side, you'll need those drops downs as a part of a different dashboard like a toolbar dashboard. On your anchor combobox, perform a refresh of the toolbar dashboard. There you go.
If I read correctly, he would want the parameter list assigned to the Profit Centre field to update after making a selection in Entity field. I don't think it's possible as I'm not sure how making a selection in Entity field would invoke record level refresh of the STE component. Not sure how what you recommend would look like but now curious!!
Cosimo, that's exactly what I'm looking for
