Can we embed an excel worksheet into the RQM dashboard?
seema prabhu (1●6●6)
| asked Mar 21 '13, 9:07 a.m.
retagged Mar 25 '13, 7:06 a.m. by Gerd Schiering (122●1●13●16) I have a report that is created in excel, which contains charts. I would like to display this on the RQM dashboard. Is there a way we can do this. I have tried using html widget and savingthe excel chart as an image . However this does not work. Please advise. |
One answer
Hi Seema,
You will need to put your image of the chart on a server that can be reached by a URL that is accessible from the RQM server machine (It will not go through any firewalls you might have in place!). The steps are: On the dashboard use the "External Content" widget. In the settings of that widget you can specify the external URL for your image graph: For example: http://www.ibm.com/images/portal/X793998X98785J28/08152011_Redbooks.png In case this is blocked by your infrastructure you can also try to use the Tomcat server of your CLM installation Create the folder C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static (or where you have installed your server) and put your images in there. For example C:\Program Files\IBM\JazzTeamServer\server\tomcat\webapps\ROOT\static\mychart.jpg The URL to use inside the widget is then something like https://clm-server:9443/static/mychart.jpg Hope this helps, Gerd Schiering TechSupport IBM Rational |
Comments
What happens when you try to include the image in the HTML widget?