In BICS Connection, prompt variable in webi takes huge time to find
There is a BICS connection which is build on top of Bex Query. There is multiple option variable while running the webi report . Initially if I put the value in one the selection variable it was not coming, then I choose Match with Key and then again clicked on the find button, it was able to find out the sales order number after long time. I have to run the same report for 10 sales order number, it is really time taking to find the sales order number one by one. Can anyone please advise how can i get those sales order numbers in the selection without waiting that much time. List of sales order numbers in the selection are not fixed.Earlier using the universe I was not facing the issue.