How to code a dynamic multi select prompt in a universe derived table?

567 Views

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

http://biguru.wordpress.com/2009/07/19/businessobjects-universe-design-best-practices/

http://forumtopics.org/busobj/viewtopic.php?p=675811&sid=bf3dc50d5e60c61ef51d1a2bccc27e22

Thanks!

Keith