Dashboard Query Prompt Default Selection

[former_member453300]

Hey Guru's

• I have requirement in Xcelsius Dashboard that to use query prompt selectors. like i am using three prompt from the single query.
• First prompt is of country where all the countries are appearing to which my company exports, second is of customer, and third one is of product sold.
• My question is that if i select the particular country like "CHINA", so the next prompt which is of customer should only show the customers which resides in china but the problem is that it shows all the customer database as whole so from such a long list it is almost impossible to search particular china customer. Same is the issue with product like it should only show product which i sold to china and to particular customer.

Kindly Help me in this issue how this can be tackle and any alternate to overcome this issue.

Thanks and best regards,

Hassan Ali.

[Former Member · Accepted solution]

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

[former_member453300]

Thanks All for your effort it helped some how.

[saurabh_sonawane]

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

[saurabh_sonawane]

dont use a query prompt selectors because query prompt selectors display the LOV values only.

[former_member453300]

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

[former_member195446]

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

[former_member453300]

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

[former_member195446]

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

[former_member453300]

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.

[former_member182541]

Hi,

Please check the below links, it can brief in detail.

Hope this Helps,

---SumanT