Skip to Content
0
Apr 06, 2010 at 11:04 AM

How to set filter from different source at BI 7

13 Views

Hi All,

Could you kindly help me regarding this problem ?

I have problem to filter the data provider in WAD BI 7.0.

I use : " Set Filter Values Using Different Sources " .

The source is from Analysis Item component.

e.g.

I have :

a. Analysis Item A and Analysis Item B.

b. Combo Box.

the steps that I did is:

1. Filter Analysis Item A using Combo Box .

2. Filter Analysis Item B using Set Filter Values Using Different Sources.

I fail in step 2.

e.g.

Analysis Item A :

ZCSTCTR Group

NI01/100235 AAA

NI01/100236 AAA

Afterward, using Analysis Item A, I'd like to filter Analysis Item B using Set Filter Values Using Different Sources web Item.

Analysis Item B:

0COSTCENTER Amount

NI01/100235 120

NI01/100236 212

NI01/222333 2323

NI01/100233 4444

I trigger Set Filter Values Using Different Sources web Item using button.

The format of 0COSTCENTER like that because it has Controlling Area in 0COSTCENTER.

My Question is why I can't run the filtering ? Is this because of the format of 0COSTCENTER that has Compounding with Controlling Area ?

Could you kindly suggest me what I have to do ?

Thanks a lot and have a good day,

Best regards,

Daniel N.