Has anyone coded a dynamic multi-select prompt within the SQL of a derived table in the universe?
The values of the prompt should be populated from a database table making it a dynamic prompt u2013 not static as in hardcoding the values.
I have coded a multi-select prompt outside the derived table in a filter. This does work and displays properly in a multi-select drop down with code and description. However, in my case, the result of this is bad performance u2013 execution time is 6 minutes when it should be 3 seconds.
Bottom line here is I need a dynamic multi select prompt inside the SQL of the derived table. Is this possible?
I canu2019t find much from google or SAP forums on this specific question.
Google resources Iu2019ve checked out