BusinessObjects Board

Cascading Prompts in Webi 6.5.1-logical hierarchy

building semantic layer
#1

Hi,
I have a logical hierarchy - VP to Director - Manager to Team Lead.
I am planning to have a Prompt from VP if a user select a VP they need to get tot all the Directors who report to that VP and If they select a Director they need to get only Managers who reports to that director and so on.
I know we need to use cascading Prompts but it is not working as i thought.
Can any one give me the syntax for cascading prompt that I can use.

Thanks

Nimu (BOB member since 2004-04-27)

#2

Exactly how did you create this ?

Did you follow the FAQ ? https://bobj-board.org/t/15227/8

Regards,

Gerard

highandstoned :netherlands: (BOB member since 2005-08-01)