BusinessObjects Board

Prompt question

building semantic layer
#1

Hi.
I need a solution for next problem.
I have build a object ITEMS that used Prompt function.The user can insert into the prompt window 1 item = item1,some items = item1;item2;…;itemN or ALL.
This query BO build.

SELECT DISTINCT
V_COLLECTION_SUM.ITEMS
FROM
V_COLLECTION_SUM
WHERE
( V_COLLECTION_SUM.ITEMS IN DECODE(@Prompt(‘SELECT ITEMS’,‘N’,‘CLASS\ITEMS’,multi,),‘ALL’,V_COLLECTION_SUM.ITEMS,@Prompt(‘SELECT’,‘N’,‘CLASS\ITEMS’,multi,) )

The problem with the case when user select some items.
Any ideas?

sinale (BOB member since 2003-01-13)

#2

Did you look at this post in Designer FAQ first?

Andreas :de: (BOB member since 2002-06-20)

#3

Fank you very much :stuck_out_tongue:

sinale (BOB member since 2003-01-13)