There are no hierarchies. These are 3 different columns of a single table. Also, Product prompt depends on BU and Application prompt depends o BU and Product. For eg, for any BU(Business Unit) contains multiple products, and each of those products contain multiple applications.

I was initially using "All Column Values" but then the requirement changed. I had to introduce 2 more conditions in the prompt, so I switched to "SQL Results". For example, my 1st prompt is Business Unit. 2nd is products. Based on the business unit I choose from 1st prompt, corresponding products are listed in 2nd prompt.…

Hi Gianni, Thanks for ur reply! Can u please tell, how can I manage that in my rpd? I am new to this tool, so not aware of the best practices. It would be great if u please tell me how can I manage that in rpd?