It's all about the answers!

Ask a question

Can we embed an excel worksheet into the RQM dashboard?


seema prabhu (166) | asked Mar 21 '13, 9:07 a.m.
retagged Mar 25 '13, 7:06 a.m. by Gerd Schiering (12211316)

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.


Comments
Laura Kuczarski commented Mar 21 '13, 9:22 a.m.
JAZZ DEVELOPER

What happens when you try to include the image in the HTML widget?

One answer



permanent link
Gerd Schiering (12211316) | answered Mar 25 '13, 7:05 a.m.
JAZZ DEVELOPER
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

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.