Skip to Content

h5. Introduction

Yahoo Widgets are great applications for allowing users to interact with systems or applications directly on their desktop. Within the SAP space, there are casual users of BI that may want metrics on a daily basis. Many customers run their businesses off one or two key reports, such as a daily sales report, or a simplified financial statement. Therefore, this guide provides a way to consume BI Data within Yahoo Widgets.

Screenshot of Widget Version 1.0:

image

Screenshot of Widget Version 2.02:

image

Screenshot of Widget Version 3.x (Coming Soon!!!):

!https://weblogs.sdn.sap.com/weblogs/images/28269/widg3x.jpg|height=390|alt=image|width=578|src=https://weblogs.sdn.sap.com/weblogs/images/28269/widg3x.jpg|border=0!”

Scenario

As with any solution, the first thing you need to do is identify when to use the solution. The Yahoo Widgets solution is great for targeting your casual user. For example, many users have similar types of desktop applications to view their stock ticker every morning. This information is peripheral. You glance at it in the morning, but don’t really do anything or follow up unless your stock value changes drastically (either positive or negative).

I’m proposing that key enterprise metrics be treated in a similar manner. For example, if a company uses daily sales numbers to measure performance, this metric should be pervasive within the organization. Users should see their metric peripherally every day when they log onto their machine, and should only follow up if they see unexpected numbers.

The Yahoo Widget Application allows you to present this to the user in a very nice way. They won’t even know they are interacting with an SAP application! h5. Version History and Limitations

Version 1.1:

    • Does not support structures in both rows and columns

    • Does not support structures and characteristics in both rows and columns

    • Does not support hierarchies

    • Does not support queries with mandatory variables

Version 1.2:

0.1. Added support for all query datasets with 2 structures and n characteristics

0.2. Added support for structures in both rows and columns

0.3. Added support for structures and characteristics in both rows and columns

0.4. Does not support hierarchies

0.5. Does not support queries with mandatory variables

Version 1.3:

0.1. Widget now refreshes when preferences are changed

Version 2.01:

0.1. Sap blue skin

0.2. Ability to select demo data set from preferences

0.3. Removed Change Background Color (not needed in blue skin)

Version 2.02:

0.1. Adjusted timer 

0.2. Added 5 min option

Version 2.04:

0.1. Added Logon Language Support

0.2. Added Support for 0CALDAY (ExtVal display)

Version 2.05:

0.1. Added Support for Hierarchies (no expand and collapse)

Version 2.06:

0.1. Added Expand/Collapse icons for Hierachies (not dynamic)

Version 2.07:

0.1. Added “no applicable data found” support

0.2. Fixed the last updated display to support real time cubes

0.3. User defined number for the refresh interval instead of pull down

0.4. Added >1 header row query support

0.5. Added color coding based on BI exceptions

0.6. Added customizable height

0.7. Added display of key if description is not available

0.8. Added traffic light support (you need to use IOBJ 0TCTRQCSTA)

0.9. Added text variable support (not dynamic i.e. fixed in widget code)

0.10. Added secure check box that removes copy of the XML on the C: drive if any

0.11. Removed password from PDF, Excel and query jumps (for security)

Version 2.08:

0.1. Added themes to prefrerence

0.2. Added report navigation buttons, but did not enable it

0.3. Added button and second window for query informtion, and partially enabled it, still need to source info

0.4. Added a distraction image, but did not enable it

Version 2.09:

0.1. Added theme preference

0.2. Changed group to CPM

0.3. added last refresh date to query properties

0.4. re-aligned buttons

Version 2.10:</p><ul><li>Changed the tooltip on the information button</li><li>Fixed the query description when “no applicable data found” so that if it ran once, the desc will remain</li><li>Set the default theme to blue (in the preferences section)</li><li>Adjusted technical name display in cells (ChavlExt first then Chavl)</li><li>Display SAP logo instead of update icon in docking</li><li>Added multi language support to QueryInfo splash screen</li><li>Added multi language support to “Last refreshed date” </li><li>Remove the <name> tag in widget.xml to allow multiple widgets to run </li></ul><p>Version 2.6:

0.1. Updated Version Number to 2.6 due to confusion on SDN

0.2. Added underlying framework for expand/collapse hierarchy (dynamic hierarchies)

   – This is not complete yet…

Version 2.70:

0.1. Updated the Expand/Collapse Hierarchy WebApi Commands to include dynamically building parameters

0.2. Added sample dataset for 1 char and 1 hier in rows

0.3. Hid the preferences for dynamic hierarchies as this isn’t complete

Version 2.71:

0.1. Added Widget Version to the Info Screen

Version 2.73:

0.1. Ported the web service to call BAPI with dynamic webservice

0.2. Hierarchy icons were broken in this version

0.3. Added “View” Support

Version 2.74:

0.1. Updated Connectivity

0.2. Added eror handling

0.3. Hierarchy icons were broken in this version

*Version 2.75: </p><ul><li>Fixed Hierarchy Icons</li><li>Added more error handling</li><li>Added support for foreigh character sets (Japanese & the such)</li><li>Fixed Launching View URL to Web, PDF, and Excel</li></ul><p>Version 2.76:</p><ul><li>Upgraded to Yahoo Widget Engine 4.5</li><li>Bug in Deleting hierarchy icons when changing queries</li><li>Fixed bug in Preference Groups not showing up on subsequent executions</li></ul><p>Version 2.77:</p><ul><li>Fixed bug in Deleting hierarchy icons when changing queries</li></ul><p>Version 2.78:</p><ul><li>Enhanced Error Handling Framework to check if the RRW3_GET_QUERY_VIEW_DATA function is RFC enabled. It should be, but I added this check due to a rare customer issue where they did a core-mod</li><li>Published Widget in compressed format to reduce the size</li></ul><p>Version 2.79:</p><ul><li>Updated default widget width based on customer issue</li><li>Updated widget to handle secure mode even is SSO is not configured (using logon popup)</li><li>Updated initial widget view to hide scrollbar and info button until widget is rendered </li></ul><p>Version 2.80:</p><ul><li>Updated widget minumum column size for small datasets</li><li>Updated widget to include additional demo data</li></ul><p>_Latest Download (2.80) Available Here:

_*

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e01bb234-faf7-2a10-e9a8-aa41def64ffd

Pre-requisites

The latest versions of the BI Data Widget do not require the queryviewdata web service to be activated as the earlier versions did.

Step 1

Go to SICF and activate this web service: “/sap/bc/soap/rfc” 

</p><p>Step 2

Go to http://widgets.yahoo.com/download/  (http://widgets.yahoo.com/download/) and download and install the latest version of Yahoo’s Widget Engine. <br />!https://weblogs.sdn.sap.com/weblogs/images/28269/ywidg1.jpg|height=396|alt=image|width=256|src=https://weblogs.sdn.sap.com/weblogs/images/28269/ywidg1.jpg|border=0!</p><p>Optional:*

Here is an example of how to pass parameters for filter values using WEB API commands. We are passing the FILTER_IOBJNM=0D_CHANNEL and FILTER_VALUE=3.

image

 Here is an example of how to pass parameters for variable values using WEB API commands. In this case, we are using a selection option variable. We are passing the following parameters:

VAR_NAME_1=DISTGOP

VAR_OPERATOR_1=EQ

VAR_VALUE_LOW_EXT_1=3

VAR_VALUE_HIGH_EXT_1=5

!https://weblogs.sdn.sap.com/weblogs/images/28269/qvw18.JPG|height=326|alt=image|width=594|src=https://weblogs.sdn.sap.com/weblogs/images/28269/qvw18.JPG|border=0!</body>

To report this post you need to login first.

142 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    ..but the multitude of blogs on one and the same widget mixing essentials with trivialities like today’s excursion into webservice basics makes the whole thing really confusing.

    why not invest your talent into a new widget and surprise the kind reader with anOTHER cool widget realizing some bi-functionality?

    just my 2 cents,
    anton

    (0) 
    1. Former Member Post author
      I’m working on other widgets as well, but there has been lots of requests from people for updates on this. Therefore, I’m releasing all the udpates with new blogs so I can describe what I updated.

      Sorry if it adds confusion. I’ll try to be clearer on this in the future. This blog was to help people configure the BI web service for the widgets because a lot of people were asking questions about this…

      You’ll see some of the new widgets I’m working on shortly…

      (0) 
  2. Former Member
    Prakash,

    I am trying to implement this widget in an ABAP NW2004S SP11 Sneak Preview.
    Unfortunatly, i don’t have the J2EE engine installed. From my understanding i should be able to  access the Query_VIEW_DATA Web service via:

    http://localhost:8000/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?sap-client=001

    When running it in my browser, i get a “SOAP processing failure, error id = 112” error. Can you please elaborate on how to access the Query_View_Data from ABAP systems?

    Thanks,
    Gili

    (0) 
    1. Former Member Post author
      Without the J2EE, you won’t be able to launch this in the web analyzer or export to excel because that is required for that functionality. You should be able to access the web service though. After you’ve followed the steps listed above, if you still have a problem, check for ABAP dumps in ST22, check system messages in SM21, and the search OSS Notes to help resolve your error.
      (0) 
      1. Former Member
        Hi there
        I’m in the same boat and get the same error. SM21 reports SOAP Runtime exception 112 in method XP_READ_TAG of class CL_SOAP_XP. OSS Notes have no apparent matches to it.
        Did you manage to resolve the issue?
        Regards
        Rob
        (0) 
        1. Former Member Post author
          Hey Rob,

          I haven’t encountered that issue.

          A quick google search does show this:
          BAPI/RFC as Web Service

          I’d set a break point in that class and debug. Otherwise, log an OSS Message. If the query_view_data web service doesn’t work through transaction WSADMIN, this is something SAP fully supports.

          Cheers,
          Prakash

          (0) 
          1. Former Member
            Hi Prakash
            Thanks for the reply. Yeah I’d already spotted that thread, but I’m not techy enough to understand it! I’ll see if I can get a break point set as you suggest & I’ve logged an OSS for the error.
            Cheers,
            Rob
            (0) 
          2. Former Member
            Hi Prakash
            SAP OSS responded thus:
            “Probably the service is running without errors but you aren’t able to test a sap webservice directly via IE, so the error-message you described above is the normal response if you are calling a sap webservice via internet browser.”
            So that explains that!
            Instead I used WSDL from WSADMIN to open a browser and display the details of the service. That worked OK – no idea what the details meant though! Anyway I guess that means that the BI config is working OK.
            Got another question on the widget – but I’ll start a new string. Thanks for your support!
            Cheers
            Rob
            (0) 
  3. Former Member
    After executing Step 14, I received the following error.

    An error has occurred. Maybe the request is not accepted by the server:

    java.lang.NullPointerException

    Can you help me out. My Web Service Definition says it is active.

    (0) 
    1. Former Member
      hi I have the error on step 14  i enter the infoprovider and query when i click the send “an error has occurred. maybe the request is not accepted by the server:
      invalidinupt ” i ‘m sure input is true.
      (0) 
  4. Witalij Rudnicki
    Hello,
    We tried to do the exercise. Does anyone know what following error might mean?

    ERROR 08:10:10: SOAP Runtime CL_SOAP_RUNTIME_SERVER->EXECUTE
    _PROCESSING() A SOAP Runtime Core Exception occurred in method
    CL_SRG_RFC_PROXY_CONTEXT======CM002 of class CL_SRG_RFC_PROXY _CONTEXT======CP at position id 1 with internal error id 1001 and error text SRT: Unexpected failure in SOAP processing occurred (fault location is 1 ).

    Thank you!
    Vitaliy

    (0) 
  5. Former Member
    Hi ,

    Have you encountered such problem?
    Do you know how to cope with it?

    Why WEB AS does not return XML ?

    request[onreadystatechange]: null
        request[readyState]: 4
        request[responseText]:
        request[responseXML]: null
        request[status]: 200
        request[statusText]: OK
        request[autoRedirect]: false

    (0) 
      1. Former Member
        I have run the widget in the debug mode.
        And using option /dump request I have tested at which level there is a problem. So I can see that WEB AS doesn not return XML.
        (request.responseXML = null).

        Thanks for help.

        Marcin

        (0) 
      2. Former Member
        I have run the widget in the debug mode.
        And using option /dump request I have tested at which level there is a problem. So I can see that WEB AS doesn not return XML.
        (request.responseXML = null).

        Thanks for help.

        Marcin

        (0) 
  6. Former Member
    Hello,
    Could something similar to this process could work for displaying success or failure messages from Process Chains? If so please direct me to where I could get more information?

    Thanks,

    (0) 
    1. Former Member Post author
      Yes. We’ve got tons of customers doing this. The new BI Stats cubes within NW 7.0 have realtime Process Chain Status. You can just choose that query within your widget.
      (0) 
  7. Former Member
    Hi Prakesh
    I downloaded the widget & have got a suitable query to report.
    Whatever I try, I just get the standard error from the widget saying check username, password, etc. etc. So obviously I have set up something incorrectly. Can I just check my understanding?
    In the General Tab I’ve put in my username & password.
    In the Reporting tab I’ve done the following
    1. ABAP host; My_local_host:80nn
    2. Java host; Left blank as I only have the ABAP Usage type
    3. Language; EN
    4. ABAP Client; 050
    5. InfoCube; Tech name for cube
    6. Query; Tech name for query
    All other settings are default.
    SM21 & ST22 show no activity, so we’re a bit stumped!
    Hope you can help!
    Cheers
    Rob
    (0) 
    1. Former Member
      Hi Prakash
      After much puzzling and internet searching I’ve taught myself rudimentary XML, downloaded a SOAP debugger, cut & pasted your SOAP Envelope into it…and eventually discovered that it returns a SAP authorisation error.
      “QUERY_VIEW_DATA wurde aufgrund fehlerhafter Anmeldedaten abgebrochen”. Which babel fish translates as “QUERY_VIEW_DATA was broken off due to incorrect dates of registration”.
      Which would suggest that the user profile I’m using is out of validity perhaps? But it isn’t. The profile is valid (as far as WSDL is concerned) & is the same one I entered for the External alias of the web service.
      As always I’d appreciate any thoughts!
      Cheers
      Rob
      (0) 
      1. Former Member Post author
        S_SERVICE auth object in the ABAP system will allow access to this web service for a particular user. Make sure that is assigned to your user.
        (0) 
        1. Former Member
          Thanks for that. The profile we are using has SAP_ALL authority and we’ve checked that it includes S_SERVICE.
          Looked thru SDN but couldn’t find anything relevant so have raised an OSS Note. Will post back if I get a resolution.
          Cheers
          Rob
          (0) 
          1. Former Member Post author
            Hey Rob,

            I’m working on a newer version of the widget. In this, I’ve added more error handling. Here is a beta copy of version 2.74. The pre-requisite for this is slightly different. You must go to SICF and activate service: “default_host/sap/bc/soap/rfc”.

            Once that is done, this version 2.74 widget should work.

            If you have errors, it should popup the error message. Keep in mind that this is a beta version, so you may find some gremlins I haven’t cleaned up yet… Let me know if this works. If it gives you an error, let me know what the error is.

            Make sure you populate:
            User
            Password
            ABAP Host
            Language
            ABAP Client
            InfoCube
            Query

            Also, make sure “Secure Mode” is unchecked.

            Thanks,
            Prakash

            (0) 
    2. Hello
        Were you able to resolve the standard error?. I downloaded the widget and created a sample query and when I try to change the preferences and run the widget I keep getting the following error, can someone please guide me..
      “Please check that your user id,Password,Cube name and Query name are correctly maintained in the preferences.”

      Thanks
      Nirmala

      (0) 
          1. Former Member Post author
            Hey Nirmala,

            I’m working on a newer version of the widget. In this, I’ve added more error handling. Here is a beta copy of version 2.74. The pre-requisite for this is slightly different. You must go to SICF and activate service: “default_host/sap/bc/soap/rfc”.

            Once that is done, this version 2.74 widget should work.

            If you have errors, it should popup the error message. Keep in mind that this is a beta version, so you may find some gremlins I haven’t cleaned up yet… Let me know if this works. If it gives you an error, let me know what the error is.

            Make sure you populate:
            User
            Password
            ABAP Host
            Language
            ABAP Client
            InfoCube
            Query

            Also, make sure “Secure Mode” is unchecked.

            https://sapmats-us.sap-ag.de/download/download.cgi?id=2573HGMTSLRA2XTR077VWTJBZSL1OROE1HGKKZ4UXQ8L6BSSV3

            Thanks,
            Prakash

            (0) 
            1. Thanks Prakash for the update, I eventually got the widget to work with the existing version. The issue was the S_SERVICE auth object which did not get work the first couple of times that we tried. But I do have the following questions.
              1) Can we use query views instead of queries?
              2) Do all of the end users need to have the S_SERVICE auth object added to their profile to run the widgets on their machines?.
              3) Is there a way to show all the elements on the report if the query contains a hierarchical structure in the columns or rows? as it currently only displays the parent and hides all the child nodes in a hierarchical structure.

              Thanks
              Nirmala

              (0) 
              1. Former Member
                Hi sorry to interrupt guys, but i m not able to download this 2.74 ver.  it gives me this error can u please guide me..

                The XML page cannot be displayed
                Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

                ——————————————————————————–

                An invalid character was found in text content. Error processing resource ‘https://sapmats-us.sap-ag.de/download/download.c

                Thnaks…

                (0) 
            2. Prakash
                 I downloaded the 2.74 widget version and used a query view instead of a query and it looks pretty cool. Great job at it.

              Thanks
              Nirmala

              (0) 
              1. Former Member Post author
                Hey Nirmala,

                Glad it works. Does it now issue a different error message if you use a query? If so, let me know as I’d like to fix any issues or add better error messages if it doesn’t work for a query.

                Cheers,
                Prakash

                (0) 
                1. Prakash
                     One issue that I noticed on the v2.74 is when you use a query view instead of a query and try to export to excel the url command does not recognize the query view. It either brings back no applicabe data or only brings back the query data if the query name is populated on the preferences. Maybe an additional command is needed in the global include .js file to recognize the query view when one is used.

                  thanks
                  Nirmala

                  (0) 
                  1. Former Member Post author
                    Hey Nirmala,

                    Yes, this does indeed seem to be a problem. I’ll fix this in the next version. I’ve got a list of about 7 bugs still in 2.74 that I’m planning on fixing. I’ll add this to the list. Thanks for the input!!!

                    Cheers,
                    Prakash

                    (0) 
  8. Former Member
    I love this widget.  I had 1 minor problem with column widths.  one of my columns has a long Column name (much wider than the data).  when the widget re-sizes itself, the background ends up not being wide enough.  This was easily fixed by changing the mainWindow width in the global_include.js file. I don’t know if this is something you might want to address in a future version.
    (0) 
    1. Former Member Post author
      I’m not sure what error you’re talking about. What did you change in the code for this? I can include your changes in the next version…
      (0) 
      1. Former Member
        No errors just doesn’t display nice. I could email you a screen shot and you could see what I mean.  I have two columns of data.  The 2nd columns label is “Sales-Retail Value”  values are in dollars such as $800,000.  what I see is

        the column label “Sales – Retail Val”  the rest is cut off.  for the values I only see “$800,7”  I loose the last 2 places of the value.  The Blue background is also to narrow  I went in to the javascript and increased the mainwindow.width by about 50 to get around this.

        (0) 
  9. Former Member
    Hi there,

    I would like to use this widget but I just can’t get it to run my query? I get check the password, username from the widget? I have downloaded the new 2_74 and I still get the same error? So I’m a bit confused on where to check and configuration for the SOAP should be done if there is EP in the landscape. I’m assuming if the Service: “default_host/sap/bc/soap/rfc” is active no need to worry about the EP or do I need to activate the same service on the EP. Again I have downloaded both versions and I get the same standard error message regarding the username and password.

    Thanks in advance

    (0) 
    1. Former Member Post author
      Hey Vaishali,

      You can go to transaction SMICM -> Services. I’ve actually updated version 2.75 which will be on SDN shortly. I’ve added expanded error handling to that version. I include connection steps as well.

      Cheers,
      Prakash

      (0) 
  10. Former Member
    Where can I find the code to version 2.78? I would like to see how you created this. Your work looks great, but I would like to see more code examples.

    Thanks for the help

    (0) 
    1. Former Member
      Never mind, I figured out how to get into it. Apparently the .widget file is simply a zipped file with a different extension. To see the code, all you have to do is change the extension to zip, and uncompress the file. Pretty cool.

      Anyway, thanks again for the great work..

      (0) 
  11. Former Member
    You are a genius!  The best way to get people to adopt new technology is to make it easy for them to try themselves and actually see it work.
    You did all of these things and I thank you greatly.  Keep up the good work.
    (0) 
  12. Hello Prakash,

    great job by the way.  I’ve setup the widget here and am using it with the “Secure mode” box checked.  Everytime the widget first opens it asks for user/password, we’re fine up to here, but here’s the issue:

    1.  An error message comes up saying that user or password… is incorrect.

    2.  If I refresh, the report runs fine.  If I close the widget and open it again, the same issue appears.

    When going through debug:

    Request.status = 200

    BUT, the first run shows:

    request.responseXML = null

    when I refresh, request.responseXML now contains the right value.

    Been looking at the code, but can’t seem to find what is causing this…  Any ideas?

    Thanks.

    (0) 
      1. If secure mode isn’t checked it works if a default user/password is entered.  If no default user/password is specified, I have the exact same issue.

        Don’t know if that helps, but I’m on BW3.5 with no portal (created a copy of the widget which I modified to load in web through /sap/bw/bex? instead of the other path which is either portal or BI7).  My issue is with the unmodified widget though.

        (0) 
        1. Former Member Post author
          Ok. I think I know what is going on. When you check secure_mode, what should happen is that it checks for single signon. Therefore, if your ABAP system has single signon to secude or active directory with kerberos, then it doesn’t require a username and password. If you don’t have single signon, then it should prompt you with you username and password logon (similar to what you get when you logon via internet explorer). This popup only occurs via an http connection though instead of an https connection. Are you connecting through http with secure mode on, or via https?
          (0) 
            1. Former Member Post author
              Ok. That’s the issue then. You could either switch to connecting via https to get the dialog, or you could check off secure mode. To really use the secure mode option, the best thing is to implement SSO from ABAP to Windows, either via Secude or Kerberos. That way, you won’t have this issue and you can use true secure connections. Since https doesn’t support popup based logon, and only form based logon, I’m not sure I can create something to get around this.
              (0) 
              1. Not too sure why you say that, because once I do refresh without changing anything it does connect properly.  And I do get a popup although I am https, it gives me the error after the popup… 

                The rough way I’d do it would be to suppress the alert and before exiting run a refresh in the code.  That way it would be transparent to the user.

                (0) 
                  1. I found a way to make it work… maybe you can figure out why it works ๐Ÿ™‚ All I had to do was to repeat this line: xmlDoc = getXML();
                    when called in:
                    function setPreferences()

                    And now it loads normally the first time I open it instead of needing to do a refresh.

                    So the code now looks like this:

                    function setPreferences()
                    {
                    //preferences.MaxHeight.value = 140;
                    preferences.MaxWidth.value = 300;
                    preferences.currentNb.value = 1;
                    //Make Widget Window Visible
                    refreshBackground();
                    mainWindow.visible = true;

                    if (preferences.Password.value == ” & preferences.User.value == ” & preferences.demo_mode == 0)
                    {
                    var Mode = “offline”;
                    alert(‘Please enter your user name and password as a preference’);
                    }
                    else
                    {
                    xmlDoc = getXML();
                    xmlDoc = getXML();
                    if(xmlDoc==undefined)
                    {
                    alert(“error: Please check that your user id, password, cube name and query name are correctly maintained in the preferences. Also, the application needs to be run online first before offline mode will work”);

                    }
                    else
                    {
                    <..>

                    (0) 
                    1. Former Member Post author
                      Hey Eric,

                      Thanks for finding that. I updated version 2.79 to include your fix. The only problem is that it pings the server twice if you use secure mode now. I’ll try and work out a way to get this to work without two server rounds trips, but for now, at least the version is working again.

                      Thanks for your contribution! So far, most people who are using secure mode are doing so with SSO where you wouldn’t be prompted or have this issue. Therefore, I think that’s why I haven’t seen this yet.

                      Thanks again. If there’s anything else you’d like added, let me know.

                      (0) 
  13. Former Member
    Hi Prakash,

    It is indeed looking and working better than last one.

    Just one thing, i am bit confused why am i not getting any addon buttons at the bottom of the widget window. The fisrt time, it showed me all the buttons, but henceforth it’s not showing anything.

    Are you aware of this issue.

    Kindly lemme know the fix!!!

    Thanks!!!

    (0) 
    1. Former Member Post author
      Hey Aadil,

      I’m unable to duplicate this issue. If you’re in “Offline Mode” you won’t get all the icons at the bottom. Otherwise, you should. Can you let me know some details:

      1. Are you connecting using secure mode or not?
      2. Are you connceting to a query or a view?
      3. Are you using http or https?
      4. Do the icons show up the first time and not the second or third time?

      Thanks,
      Prakash

      (0) 
      1. Former Member
        Sorry Prakash for a late reply!

        To answer your questions:

        1. Are you connecting using secure mode or not?
        Ans: No I’m not using single sign on, instead Username and Password. Even in widget preference i have not selected secure mode and even when i do it does not make any effect. Works well displaying report but not icons at bottom.

        2. Are you connecting to a query or a view?
        Ans: I’m using a query on a cube.

        3. Are you using http or https?
        Ans: Either of them, doesn’t make any difference.

        4. Do the icons show up the first time and not the second or third time?
        Ans: It showed for the first time.

        Though there is a catch, when it showed for the first time, and i clicked ‘Export to PDF’. It didn’t work, there was some url request problem. Sorry i can’t give you more details abt this error as, it occurred only once.

        And Yes indeed i’m not on offline mode!!!

        Thanks, i hope this will give u more clear idea abt the issue!!!

        (0) 
        1. Former Member Post author
          Hey Aadil,

          I tried replicating this issue numerous ways and was unable to. I’m always seeing the icons when I’m in online mode. Sorry I couldn’t be more help on this? You may want to run this in debug mode to figure out why this is happening for you.

          Cheers,
          Prakash

          (0) 
          1. Former Member
            Thanks for trying it out… I suggest you give me your e-id and i’ll send u the screen shots for my situation.  Also i would like to mention that the first time when i did get the icons and i tried to use them i got error, as at that time some Web analyser settings on my pc were not there.  Can this be the problem..

            but pls do send me ur id…

            Thanks once again…

            Regards,
            Aadil.

            (0) 
            1. Former Member Post author
              Hey Aadil,

              I never use email to solve issues as the resolution usually gets lost and doesn’t benefit the SDN community. There is a Widgets forum on SDN: Software Downloads

              I suggest you start a thread there and post your issue. You can put screenshots in the forum post as well. We can resolve it there. That way, if anyone else has the resolution or same issue in the future, the solution is out there for everybody.

              Cheers,
              Prakash

              (0) 
  14. Former Member
    Hi Prakash,

    We are using v2.78 widget and it works great. A couple of questions-
    1)We use SSO for web reports but there is no sso setup to connect to backend. What else can be done to connect to the system without entering password?
    2) Is it possible for us to change the widget preferences to include a few dropdowns and based on the users’ selection pass the selections dynamically to the query?

    Thanks
    Krishna

    (0) 
    1. Former Member Post author
      Hey,

      There are few things to consider here. SSO is thrown around to mean many different things. The basic form of SSO usually occurs between ABAP and JAVA. This would be traditionally between your BI System and Portal. Meaning, once you’ve signed on to one of them, you can jump to the other as this is a trusted system.

      True SSO means a user signs onto their Windows desktop, and never has to enter a password to sign on to the ABAP, JAVA, Portal, or any system. Usually people achieve this through either Secude or Kerberos authentication to the Windows desktop.

      Assuming ABAP system is authenticated via kerberos or secude to the windows active directory or LDAP authentication, the Widget should work with SSO if you’ve flagged “securemode” checkbox in the widget preferences. Since the widget doesn’t have a logon procedure to authenticate to, and I don’t want to store the certificate of the ABAP system in the widget due to security reasons, you can’t authenticate using an SSO mechanism within the widget. Only if you use Secude or Kerberos to Windows.

      Cheers,
      Prakash

      (0) 
      1. Prakash
            The link to the Beta version 2.80 expired, can you please update it.

        Thanks
        Nirmala

        (0) 
  15. Hi Prakash,
    When I open the widget there is an error message said:Fault code is SOAP-env:Server, Fault string:
    SRT:ASSERT faild:Field is initial, Exception name is:CX_SOAP_CORE, and it seems a SAP chainedexception.
    But I can call this webservice successfully by transaction WSadmin.
    I really have no idea about this error, do you have any information about it?
    I’m really appreciated for your help.
    Best regards
    Fanchest
    (0) 
    1. Hi Prakash,

      I found this is caused by webservice URL:
      I used URL in this way:
      http://” +preferences.Host.value +”/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?sap-client=” +preferences.Client.value+”%26wsdl=1.1″+”%26sap-user=”+preferences.User.value+”%26sap-password=”+preferences.Passwd.value;
      But it seems that it doesn’t work, when I run the widget, I still need to input user and password manually.
      Do you have any idea about this?
      Thank a lot
      Best regards
      Fanchest

      (0) 
      1. Former Member Post author
        In the preferences, make sure secure mode is checked off. Also, did you follow the steps to active the service in transaction SICF? Also, ensure that your BW system can execute function module RRW3_GET_QUERY_VIEW_DATA successfully…
        (0) 
  16. Former Member
    Hi Prakash,

    I’m using v2.78 BI Widget. The query that I’m using produces about 10-15 rows. A little issue that I see is that the vertical scroll bar does not always appear even though there are a few rows that doesn’t appear in the initial screen. I tried to adjust the max. height manually and it seemed to be working but not sure if it was designed to dynamically show/hide the vertical scroll bar.

    Thanks
    Krishna

    (0) 
    1. Former Member Post author
      Hey Krishna,

      It is designed to dynamically show this scrollbar. Can you send me your code change? I’ll see if I can integrate it into the next version. I made some changes in version 2.80 on this, so you might want to try that version…

      Thanks,
      Prakash

      (0) 
  17. Former Member
    Hi I had a question . Can i invoke this widget from outside e-g from portal if i could click some link and execute widget.
    Thanks in advance.
    (0) 
  18. Former Member
    Hi Prakash,
    Thanks for responding to my earlier questions.
    I have another question. When I refresh the widget (Right Mouse Click–> Refresh or click on Network Button), the widget window always positions itself at the bottom of the screen – some where below the windows task bar. Is this controlled by the Yahoo widget engine or by the widget code? I looked for the reloadWidget()in the global_include.js file but did not find any code for that. Just wondering if we can change this some way.

    Thanks
    Krishna

    (0) 
    1. Former Member Post author
      Google the program SOAPUI and run it with this. This is an opensource program that is really cool for testing web services. This will give you the soap envelope and response…
      (0) 
        1. Former Member
          This widget is super!  I need help though.  Can anyone explain how to use SOAPUI to overcome the fact that I don’t have J2EE up and running, please?

          Thanks

          (0) 
          1. Former Member Post author
            Basically, the way SOAPUI works is to choose a web service, populate the SOAP Envelope with your parameters, and get the response from the system with your data… It’s just a web service tester. If you’re not familiar with soap envelopes and soap responses, then I’d check out the details of web services at http://www.w3schools.com.
            (0) 
    2. Former Member Post author
      Also, you don’t need to set “Allow external access to query”. That’s only for the MDX based web service. This one doesn’t need it…
      (0) 
    1. Former Member Post author
      This is open source. Just add a “.zip” extension to the end of the file after the “.widget” extension and then unzip the file…
      (0) 
      1. Hi,

        Thanks for the promt reply. It does not seem to work. winzip is issuing error messages that it cannot unzip.

        Thank you,
        ravi.

        (0) 
  19. Former Member
    Hello

    I am wondering what the data limitations are for the query view data web service (amount of query results that can be returned).  Is there also a way to confgiure the service or services in SAP to chunk data so it can be more responsive for large query result sets?

    Thanks in advance for any insight.

    (0) 
    1. Former Member Post author
      You should not use this for large datasets. If you need one for large datasets, you will have to use other apis and write your own web service. Queries don’t do packaging currently, and the widget shouldn’t expose large datasets…
      (0) 
  20. Former Member
    Hello Prakash,
        I have activated the web service that you have mentioned in this blog in SICF and downloaded the 2.80 version of the widget.
        I have set the preferences to run in the online mode(by unchecking the “Offline Mode”), gave the ABAP and Java host:port, entered the desired infocube(multiprovider in my case) and the queryname with my logon information. The query is simple with one row and one column. Despite of making the mentioned settings, I am unable to see any results in the widget.

        Moreover, at the right bottom of the widget I see that the system is “Not Connected” or “Offline”.
      
       I tried to find the answer in the forums but didnt get any response from the SDN community.

       Please help !!

    Thanks,
    Ajax.

    (0) 
    1. Former Member
      Hello Prakash,
      I am actually having the same issue.  I am unable to get any results to show from our BI system.  I cannot tell where the issue is as all I see is a blank widget with the “Not Connected / Offline” symbol showing.  All of the guides appear to correspond to steps that are not relevant for the v2.8 widget.  Is there any guide for ensuring that configuration is correct (where to get the values for server etc) and testing that the query / view connection that the widget is using is able to be accessed (via web browser or something else).  I know BPC is a big item right now but any help with this would be appreciated.

      Thanks,
      Dennis

      (0) 
      1. Former Member Post author

        Ok, try this:.xml and email me that file. I can let you know what the issue is with that file if the above has not solved your problem.

        (0) 
          1. Former Member Post author
            It sounds like you may not have windows rights to save a file to the C drive. This is required as that is the cache location for the queries.
            (0) 
  21. Former Member
    Hi,

    I have been testing the BI widget and it works with queries that do not require any parameters/criteria.

    Question is, how do i pass parameters in the BI widget for queries that require them??

    Also, I don’t understand the Optional part for the filters. What are those screen-shots?? is that some transaction in BW? If so, what is the tcode?

    Thanks for your help.

    (0) 
    1. Former Member Post author
      Currently, the BI Data Widget does not support that. I made this decision deliberately actually, as this is not intended as a replacement for a tool with filters like the Web Analyzer. It’s intended to provide users with contextual information on the desktop. If you want to filter, you can jump to the web analyzer for more capabilities in this area. I believe that we shouldn’t make things more complicated for users, and the more parameters and filters there are, the more complicated things get.

      That being said, it is possible to do this by updating the source code of the widget to support this. It’s pretty easy to enhance the soap envelope to pass in a few filters…

      (0) 
      1. Former Member
        Thanks Prakash.

        The direction you took makes sense.

        Do you have code sample or a link with sample code for passing filters in the soap envelope.

        Also, i noticed that when i click on the web analyzer link. The user/password are sent in clear text with the URL.

        We are currently not running SSL on the server, would that make a difference?

        Thanks

        (0) 
        1. Former Member Post author
          If you setup true SSO and you uncheck the “secure-mode” box in the preferences, then the username and password won’t be sent as clear text.
          (0) 
  22. Former Member
    Hello,

    I am interested to understand if you did the same approach for Google Gadget ?

    Main issue seems to use REST Web Services and not SOAP : is “ICF” the right “solution” to do it ?

    Thanks for your help

    Kind regards

    Eric d’Arche

    (0) 
    1. Former Member Post author
      Hey guys,

      SOrry I didn’t get version 3.x out yet. THis was just a side project of mine and not related to me real job. I’m trying to get BPC out the door. After that, I’ll try and clean up and fix up versioun 3.x and put it out. It’ll be a little while though…

      Prakash

      (0) 
        1. Konrad Gnoyke
          I do so, too.
          id would be very nice if you could find the time to get the version 3.x done.
          The graphic functions would take the widget on the next level.

          I’m still full of hope … ;o)

          regards

          (0) 
  23. Hello,
    is there a solution with a SAP BI Widget on the iphone? Please contact me, if you have informations about that.

    thank you a lot.

    Adrian

    (0) 
      1. Hello
        thank you for your response. Do you plan to create such a Widget for the iphone? Or could you tell me a guide, how to do that with the MAC OS X SDK 8? Or are there any other possibilities to create this? Or do you know a developper who can do that? I need this application!

        Thank you very much!

        Kind regards,

        Adrian

        (0) 
        1. Former Member Post author
          It wouldn’t be too hard to do, but currently, I don’t have any bandwith to work on this. You could probably hire a consultant to build this within a week or two…
          (0) 
  24. Former Member
    Hi Prakash,

    I was able to install QUERY_VIEW_DATA service successfully and test it as specified in document. However, when I try to configure the widget, I get err msg saying “User is forbidden or service is inactive”.

    -> Service is active and I tested it using the steps specified in the config document
    -> I tested query_view_data using the function module RR3_GET_QUERY_VIEW_DATA and it returns results correctly
    -> I checked in SE80 and made sure service is active.

    Any idea why this error msg?

    BTW, excellent work done and the functionality of widgets are awesome! just waiting to successfully try one.

    Thanks & Regards,
    Sree

    (0) 
  25. Former Member
    Hi ,

    We are trying to activate the query view webservices in our production environment and after doing all the settings and configurations and when we started to test the services we are getting error “Authority check failed “, to over come this error we set the access to SAP_ALL and all permissions on J2E side then we started to get al together a different error.

    We have raised the ticket to SAP but no solution till now.

    Our Environment:
    SAP BW: 3.5
    Support pack: 18
    OS: Sun Solaris

    (0) 
    1. Former Member Post author
      This solution isn’t officially supported by SAP as it is from a how-to guide on SDN. I’m not sure what your error details are. What are you getting in SM21…
      (0) 
  26. Former Member
    Hi,

    Thanks for the examples and the how to!

    I have a problem … the webservice doesn’t return the data, always  rerturn the WSDL definition.

    Any suggestion?

    Thanks!!!

    (0) 
  27. Hi,

    in the HowTo Guide is mentioned that the external alias must be configured with a user.
    Which permissions does that user need?

    Thank you
    Christian G

    (0) 
    1. Former Member Post author
      Hey Christian, in version 2.8, I’ve moved to a different connection method than is described in the how-to guide so the External Alias does not need to be configured.
      (0) 
  28. Former Member
    Hello Prakash, I’m trying to use this widget but I still haven’t been able to connect to the BI server. I’ver read almos all the post here in the Weblog but haven’t found an answer for my problem. If you could help me out, I created a thread on the SAP Widget forum:
    Software Downloads

    Thank you.

    JD

    (0) 
    1. Former Member
      Hi Prakash, I just solved my problem… it turns out the error has something to do whith the proxy server my IE uses, I changed the configuration of the Yahoo Widget to “No proxy” and it works just fine now. I still would like you to read the thread I created and check on the questions/comments/suggestions I put at the end and if you can please answer/comment about them.

      Thank you for your great work on this Widget! it’s just a great idea!!!

      Regards,

      JD

      (0) 
  29. Jose Aldemar Cortes Meneses
    Hi Prakash,

    I have a question, I follow your how to guide but I cant see de data in the widge. It shows the message “Cannot load BI query. Please change to offline mode  in preferences”.

    There are differents with the new transactions for web services SOAMANAGER.

    The question is: what would be the web service address if the how to example is created in SOAMANAGER??

    Thanks for your help.

    Jose

    (0) 
          1. Jose Aldemar Cortes Meneses
            Thanks Praksh

            It work fine. I just have to uncheck the proxy in the widget. After this my the widget works.

            I have an additional question, I saw in your presentations that you pop up a graphic related to a graphic. In the version 2.80 this function is not available so I trying to implement it. But I don’t find the engine to generate the graphics.

            You use the RRW3_GET_QUERY_VIEW_DATA program to get the data from the query.

            How do you do to generate the graphic??

            Again thank for your help.

            Jose

            (0) 
            1. Former Member Post author
              I actually haven’t completed the work on the graphics piece so this version that is released doesn’t include it. I dont’ know when I’ll be able to complete that.
              (0) 
  30. Former Member
    Hello Prakash,

    First let me say that this is an excellent piece of work – avoiding completely the need for MDX “rebuilding” and “recoding”.

    There seems to be a bit of a problem with variables though.

    I have seen suggestions that the underlying RRW3_GET_QUERY_VIEW_DATA will not accept mandatory and/or ready for input variables

    When coding up a normal URL for web services, one can use &VARIABLE_SCREEN=” ” to bypass the varable screen and ( as long as mandatory variables are supplied) all goes well.

    Do you have any comments to make (your latest downloaded widget version say “500 : ….. mandatory variables not allowed ….

    or have I misunderstood?

    Best Regards
    Ian

    (0) 
    1. Former Member Post author
      Yes, currently variables aren’t natively supported, but other customers have modified the widget to deploy queries with variables. I haven’t had time to dynamically generate variable screens. It’s possible, but I haven’t done that and probably won’t have time to do that in the near future…
      (0) 
  31. Former Member
    Hello Prakash,
          I am just a small bird in the world of widgets so my question my be bit silly to you. But please help me.
    I was trying to develop this Daily Sales Widget in our BW 3.5 and BI7 sandbox systems and found that we do not have J2EE sever for them. so, My question – Is J2EE server needed if we want to run any Widgets for our systems?
    (0) 
    1. Former Member Post author
      Nope, java is not needed. JAVA is only needed for the “Jump to web” or “Export to Excel” type operations. If you aren’t doing those things, the widget work just fine.
      (0) 

Leave a Reply