on 01-06-2015 11:46 PM
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.
Thanks
Snehasish
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sateesh for the response.
Let us assume 3 sales order I have to search.
6501907654
6501907655
6501907656
After following the above steps I got the output like
6501907654=IF(A1="","",IF(A2="",A1&"",A1&";"))6501907655=IF(A1="","",IF(A2="",A1&"",A1&";"))6501907656=IF(A1="","",IF(A2="",A1&"",A1&";"))
is this the right format you want me to enter into the (Type Value here box)
Thanks
Snehasish
we should do that formatting in Excel ,Notepad (to remove excel table formatting) ,then word to replace ^p with null.
It should be in order.
At last in word result should be like
6501907654;6501907655;6501907656
Then paste this string in webi .
Or
Just type in the Type value box like
6501907654;6501907655;6501907656 and check.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.