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:
Screenshot of Widget Version 2.02:
Screenshot of Widget Version 3.x (Coming Soon!!!): 
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-aa41def64...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...!</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.
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
142 Comments
