BI XI question.

[aniadm]

Hi To Forum,
I am new to Business Object XI. I am having a small problem.
I have 2 drill down/LOV fields on the report.

First is Brand Name (character field) where Brand Name can be,
WW
XX
YY
ZZ

The Brand name will be populated on the report with a LOV

Now the second field is a Class Number (again a LOV and a Number field)where each Class Number is associated with that Brand.

My question is, How do I select a specific Class Number for Brand XX or YY or ZZ .

I tried something like this but looks like BI doesn't like it.

case when @Select(Table_name\Brand Name) = 'XX' then
I want to display/select Class Number for Brand Name XX only.

If case when @Select(Table_name\Brand Name) = 'YY' then
I want to display/select Class Number for Brand Name YY only.

I appriciate all help from this forum.

 

[skrandel]

What you're talking about is cascading prompts. These are not supported the way you would want.

I suggest going to busobj.forumtopics.com and searching for cascad* prompt.

Steve Krandel
Symantec