on 04-27-2014 9:09 AM
Hey Guru's
Kindly Help me in this issue how this can be tackle and any alternate to overcome this issue.
Thanks and best regards,
Hassan Ali.
2 ways you can do this
1. Change from a prompt selector to 3 drop downs and use 3 queries to display the content for these drop downs. The first query contains only country, the second has a filter on the selected country and returns only customer and the third has a filter on country and customer and returns only product. All queries refresh on change of prompt value.
2. Use one query and 3 drop downs. The drop downs has filtered values as a selection which will include all values that is equal to the selected value.
Option 1 is the better, but if you don't have too much data option 2 can work and it will be quicker.
Cheers,
Josh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks All for your effort it helped some how.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hasan,
which connection r u using.
i was also facing some problem but i solve with bics connection.(query browser).
can you send me .xlf file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Prasad
I have each n everything but the process u told is not working well and even combo box does'nt show the default value's. Is there any other way to achieve this.
Thanks
Hassan Ali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hasan,
in First Query set the option:Refresh before Components Load.
for second Query :
take one exce cell and write concatenate formula(concatenate of 3 destination cells).
for the second query set the option:trigger cell should be concatenated cell and select when value changes.
make sure that uncheck the Show Loading Status option in File->Options
Thnaks,
Prasad
Dear All thanks for ur quick replies but the thing bother me is that i want to use Prompt because i have other dynamic selection so prompt will work for me. So can u please tell how it can be done through prompt and please if possible plz share any demonstration or document. Thanks in Advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hassan,
Step1:Cretae one Bex Query with resulted objects are Country,Customer,Product
(Note:Bex Query should not have any prompts,remove variables from Bex Query)
Step2:Now map these 3 results objects(Country,Customer,Product) into 3 coulmns consecutively in your Dashboard Excel sheet.
Step3:take 3 combo boxes Country,Customer,Product.
step4:for Country combo box take labels as 1st coulmns and source as 3 excel Column and insertion type should filtered by rows and take some destionation cells(u can take 3 columns which are for country,Customer and Prodcut)
step5:For Customer combo box take labels as 2nd coulmns and source as 3 excel coulmns(i.e Destionation Cells of Country Box) and insertion type should filtered by rows and take some destionation cells(u can take 3 columns which are for country,Customer and Prodcut)
step6:For Product Combo box take labels as 2nd coulmns and source as 3 excel coulmns(i.e Destionation Cells of Customer Box) and insertion type should filtered by rows and take some destionation cells(u can take 3 columns which are for country,Customer and Prodcut)
Now finally u will get 3 rows and 3 column as final destination cells;
step7:take another query2 with results objects(what ever u want) and add filters in BO side(means when u add bex query u cand drag objects into filter panel,there u can drag country,customer,prodcut)
step:map the selected values for 3 prompts in query2 to the 3 final destionations cells,each prompt selected value should be mapped to each cell in excel(i.e Final destion cells)
Please let me know if u are face any challenges.
Thnaks,
Prasad
Thanks for your reply Josh but can u please elaborate a little bit more because i tried to do what u said but it's not happening.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.