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.
Hahaha, this is why before responding I should read the whole thing. They I've done that is to move the column from SQL editor back to a combobox and not keep it in the editor itself.
That won't work as the SQL table needs to hold multiple entities.
Another thought that I had, is to have a popup dialog when you click new add new row, which allows you to choose the entity and store the selected entity in a literal parameter (and use the literal parameter in the Profit Centre filter). But not sure if that is possible?
