Reporting Using Microsoft Excel and Rational Asset Manager
September 30, 2008
In this 40 min Webcast you will get a quick primer on Reporting Using Microsoft Excel and Rational Asset Manager. Learn to:
1. How to create reports using Rational Asset Manager reporting URLs and a reporting tool like ( Crystal Reports, BIRT or in our case Microsoft Excel.)
2. How do I create the RAM report URLs.
3. Using Microsoft Excel as a way to import data using RAM web URLs and Web Queries in Excel.
4. Doing more sophisticated queries by joining RAM URL reports with other parameters like an asset activity downloads
5. Learn other ways to get data into Microsoft Excel, using data file import
6. Creating the report format in Microsoft Excel using pivot table to see who has done download activity on a set of assets.
7. Other things to consider.
To watch the tutorial you must first download and install the Raindance viewer to view the demonstration.
https://cpc.on.intercall.com/confmgr/installs/MeetingPlayer.exe
January 5, 2009 at 11:06 pm
[...] tools on the RAM Exchange and Blog. We also have previously described how RAM report URLs can be displayed as reports within Microsoft Excel worksheets. In this document I describe how you can use HTML and JavaScript to display formatted [...]
March 19, 2009 at 3:16 am
where is webcast ???
July 9, 2009 at 8:05 pm
Carlos
another great podcast, was able to follow no problem until I encountered the date/time stamp returned from RAM in Excel.
timestamp = 1.24714E+12
Excel is unable to convert the timestamp into anything meaningful – is there a macro I should be using?
thanks
July 10, 2009 at 6:58 pm
Hi Thomas, Thanks. I should have included that in the sample spreadsheet. Here is the formula.
=(C3+7200000)/86400000+25569
Then format that cell using the following format layout
Date – 3/14/01 1:30PM
This will display the date and time of the asset activity.