on 11-20-2014 6:05 AM
Hi,
I have two combo box
1st drop box: All, SIT, Dev, Test
2nd drop bpx: All, 40k, 50k, 60k
Spreadsheet:
Name env cost application
-----------------------------------------------------------
A SIT 40 aaa
B Dev 50 bbb
C Test 60 cccc
D Dev 50 ddddd
E SIT 60 cvvv
F Tet 40 sdsd
When i select 1st and 2nd combo, speradsheet data should display accordingly our selection in combo box.
Im facing challenge in selecting ALL.
Can anyone give some samples or scenarios, how to achieve.
Regards,
Rajesh
Hi Rajesh,
What is the source of the data ?? Is it WEBI ??
For this scenario i suggest create the raw data (or webi report output) as follows
Name env cost application
-----------------------------------------------------------
A SIT 40 aaa
B Dev 50 bbb
C Test 60 cccc
D Dev 50 ddddd
E SIT 60 cvvv
F Tet 40 sdsd
All SIT 40 aaa
All Dev 50 bbb
ALL Test 60 cccc
ALL Dev 50 ddddd
ALL SIT 60 cvvv
ALL Tet 40 sdsd
A SIT ALL aaa
B Dev ALL bbb
C Test ALL cccc
D Dev ALL ddddd
E SIT ALL cvvv
F Tet ALL sdsd
Thanks,
Srinivas Adepu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the source is WEBI report
Just adding unioin queries will work perfectly. Here you have to create dummy objects in Universe for Name and cost with select clause as "ALL" .
Then in first union query drag the all the objects and instead of Name drag the dummy name object.. repeat the same in 2nd union query for cost object.
Thanks,
Srinivas Adepu
ok.. Then you can try this.
save the selection from the combo boxes in the xcelsius spreadsheet.
Add one more spreadsheet component for 'ALL' selection on top the original component and use the dynamic visibility.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.