The demography of any office such as ours (a conglomerate of diverse phylum and genus constituting a jumbled hierarchy of corporate social structure)has innumerable classifications based on how you want to study it- people with ideas and no work, people with work and no ideas, people with a protruding belly and a bald head, people with the sole ambition of getting promoted next year, people with a wife problem, people with a no wife problem, and not to forget that perennial piles problem…. all sorts of people; different size and shape from diverse habitats; But Wally is our patented attraction: he has an entire Phylum dedicated to himself, of which he is also the sole member. His workstation is a tourist spot for some and for some it is the holy shrine of our corporate religion.
Today he wanted us to plug an internet search button in the dashboard we were building for a particular customer. Now, why would anyone want to do a Google or SDN search from an inventory snapshot dashboard, which shows the material stock of different plants and warehouses? What is this customer?
We were told to include some thing like this in the dashboard:
Upon very little enquiry we came to know that it was our Wally who (during one of his mad spree- trying to mesmerize and regale everyone) has committed this feature to our customer; who still apparently has no clue as to why they must have it. I have no idea either, but here is how you do it:
1. Drag a URL button from the components to the canvas.
2. Put a suitable Label(Search in SDN) and link URL to a particular cell (say A2).
3. Drag an input text box to the canvas.
4. Link the destination to another cell (say A4)—this is where the ‘to be searched’ text would be placed.
5. Take another cell (B4) and type the below URL segment
(this is the URL which is dynamically generated when you search something in SDN)
6. On the cell A2(which you linked to URL in step 2) concatenate the cell B4 to cell A4. Excel formula for this is “=Concatenate(B4,A4)”.
Basically what we are doing here is, creating the full URL that has the search string embedded. The URL button simply executes this URL.
So, lets say you typed ‘BW’ in the input text(search) field.
In this case:
cell A4 = ‘BW’; and cell A2 = http://www.sdn.sap.com/irj/scn/advancedsearch?query=bw
You are are simply executing this URL to get the search page from SDN.
For google search use the below URL: