cancel
Showing results for 
Search instead for 
Did you mean: 

How to set filter from different source at BI 7

former_member187400
Active Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi.

Could you plz ellaborate ?

You have analysis A with the next data:


ZCSTCTR     | Group
NI01/100235 | AAA
NI01/100236 | AAA

Which filter action your combo box do ? Does it filter by cost center ?

If so, if you filtered NI01/100235 costcenter you also want to filter analysis B with this value ? Like this:


0COSTCENTER | Amount 
NI01/100235 | 120

It is not clear ...

Could you plz provide more detailed example of your requirement ?

Regards.

[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]

SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]

[My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];

former_member187400
Active Contributor
0 Kudos

Hi Andrey,

Greeting.

I'm sorry if it's not clear yet.

Yes u're correct, analysis item A is filtered by combo box based on Group. In my case, e.g I filtered based on Group: AAA so I'll got 2 values: 100235 & 100236.

Afterward, I used these 2 values to filter analysis item B. But I always fail to filter it.

Could you help me andrew how to resolve it / suggest me what to do ?? Or if is there other component that I can use in order to get this purpose, please let me know .

Thanks a lot,

Best regards,

Niel

Former Member
0 Kudos

Hi.

I think it should be done by another way:

1. you filter your 1st analysis item as you already did.

2. create in 2nd query (for 2nd analysis) variable replacement path that takes values from 1st query and restrict cost center with this variable.

It should solve your problem.

For example first time your application has loaded you 1st query will return all values of cost centre and all groups. Also replacement path will get all cost centre values. Once you restrict 1st query with group = AAA your cost centre values will be NI01/100235 and NI01/100236 so also values for replacement path variable will be NI01/100235 and NI01/100236. As a result your 2nd query will be restricted by those values.

Regards.

[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]

SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]

[My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];

Former Member
0 Kudos

Hi Andrey,

I have a similar or even the same requirement and hope you can also help me out:

I have one combobox including for e.g. 3 entries (1,2,3) and 2 analysis items based on two different query views(and even two different infoproviders).

Currently I filter the analysis item 1 with the choosen entry of the combobox and would like to filter also the 2nd analysis item with the value of the combobox. Unforuntately because of the different infoproviders it's not possible to filter both analysis with the combobox directly.

Can you please suggest how to handle this?

P.S.: Could you please explain in more detail because I've already started designing my first web application

Thank you for your effort!

Kind regards,

Andreas