BusinessObjects Board

Prompt dependently to another prompt with differente LoV

building semantic layer
#1

Hi everybody,

I should create two Prompt, and the second is dependly to the first. The sub products are in different Table.
I tried this code.
It work when in the second prompt there is the same LoV (or any).
Whe the Lov is not the same… in Designer is ok; but in BO don´t run.

Someone can help me

Thanks in advance

(
(@Prompt('Please insert the Product','A','Product',Mono,Constrained) = 'OV')
AND 
(@Select(SubProduct_OV) IN @Prompt('Please insert the subproduct category','A', 'subProduct_OV', Multi,Constrained))
)
OR
(
(@Prompt('Please insert the Product','A', 'Product',Mono,Constrained) = 'AC')
AND 
(@Select(SubProduct_AC) IN @Prompt('Please insert the subproduct category','A','subProduct_AC',Multi,Constrained))
)
 :confused:

Nicola (BOB member since 2005-02-21)

#2

Try a search on ‘cascading prompts’. The trick is to edit the LOV of your object and let the lov use an LOV-object in which already a condition is implemented.

jobjoris :netherlands: (BOB member since 2004-06-30)

#3

A) Look at this FAQ: Designer entry

B) Business Objects XI offers cascading prompts.

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