cascading prompts

building reports webintelligence
1

Hi All,

I found many posts on cascading prompts but nothing seemed to work for me. I have a field based on the value of which I need to populate other fields dynamically. This has to be done at report level because not all the reports I use implement this functionality.
There is one more issue… Is there any way I can group the prompts and say only 1 among them can be selected??
Pls help…
Thanks in advance :slight_smile:

sneha_268 (BOB member since 2009-11-10)

2

Hi,

A Big Welcome to BoB.
we can’t populate prompts based on another prompt at report level, (We can’t mold the funcationlities as we want in BO, because this is not a programing language)
And for your second doubt, you can keep all the prompts into a class and can drag the entire class into a reports.

Thanks

Arun.kumar :us: (BOB member since 2007-10-25)

3

Well I think we can achieve this by using CASE statement.

I never tried, its just a wild idea. you can follow create it like this.

CASE @prompt 1
When A then @prmpot2
When B then @prompt3
…
…
ELSE @promptn
END

let us know if it works.

Rakesh_K :india: (BOB member since 2007-12-11)

4

Good Day…

Good light throughing…
But can we implement in Report level.

Arun.kumar :us: (BOB member since 2007-10-25)

5

Direct option is there in universe level.
May I know why you are going to report level.

Arjun (BOB member since 2008-07-28)

6

The result being that ALL n prompts will show up, there is no conditional prompting yet available.

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

7

Hi,

Thanks for all your suggestions. I had to do that at the universe level only…At report level, nothing actually worked…

sneha_268 (BOB member since 2009-11-10)