Skip to Content
author's profile photo Former Member
Former Member

In BICS Connection, prompt variable in webi takes huge time to find

Hi All,

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 07, 2015 at 10:32 AM

    Hi Snehashish ,

    In View mode ,a trick we follow is if you have sales order to pass to prompt with you

    1.Paste them in Excel

    2.=IF(A1="","",IF(A2="",A1&"",A1&";")) .formula to append ; at end of each value

    3.Copy this values to notepad

    4.remove last blank

    5.copy values to word . Replace ^p with null (no space also) . you'll get a vertical line of all values.

    6.paste them in prompt entry field (Type values here box).

    7.Run report.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.