on 04-06-2010 12:04 PM
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.
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];
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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];
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.