Skip to Content
Former Member
May 11, 2016 at 07:47 AM

dynamic filters based on optional prompt value


Hi there,

I am very new to business Objects, I am using BO 4.1 SP03. My business requirement is as below but I am not sure how to set this up in.

I have Universe built in IDT sourcing data from SQL database. I have field in database called Sales Cat type with 4 types 1,2,3,4.

I have build Webi report on top of this universe with optional prompts - prompt 1, prompt 2, prompt 3, prompt 4.

When prompt 1 is Null then I want all the sales category data. But when Prompt 1 is not null then I want only 1.

I want this to be dynamic and not static, I know that in static mode I can set filter on table itself.

It is very urgent and thanks so much for your excellent expert advices in advance.