Display/Selecting associated value with a Brand.

[aniadm]

Hi To Forum,
I am new to Business Object XI. I am having a small problem.
I have 2 drill down 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.

 

[synapsevampire]

It's generally best to display example data and expected output, and in your case it's very difficult to extract what the requirements are from this post.

To filter rows, use Report->Selection Formulas->Record and write it out, as in:

(
{table.brand} = "XX"
and
{table.class} in [1,2,3]
)
and
(
{table.brand} = "YY"
and
{table.class} in [4,5,6]
)

etc.

Again, this is just a wild guess as you didn't supply anything technical.

-k

 

[lbass]

In XI, you have the option of using cascading parameters. You would set this up in one parameter screen where you select "dynamic" and then make brand name the first parameter in the value column and then click to create the paramter under the parameter column, and then add class number as the second parameter immediately below it. Then use both parameters in the record selection formula area as you usually would.

-LB