I have a requirement where the user wants to view the cascading prompt like--
if he selects Program ID in Prompt 1 then the Trial ID corresponding to the selected Program ID must only be displayed in the next prompt.
Prompt filter 1= Program ID : 12345ACP
Prompt filter 2=Trial ID : TR12 and TR34 (if there are only 2 trial ID for the selected Program ID)
How this can be achieved in universe design tool or webi please let me know.
I tried creating hierarchy on Program and Trial but all trial id's are coming and its not cascading based on Program selection.