Report Questions
What's the easiest way to get custom reports from RAM? I've looked at the write up for using BIRT and I don't consider that very easy. Likewise I've tried the url reporting and it leaves a lot to be desired.
Say, for example, I want to generate an activity audit for Assets Submitted and Assets Downloaded across the entire repository and I want to see it sorted by Community. I don't see an easy to do that.
The activity audit will give me the repository wide information, but it doesn't include the community name or sorting capability.
Is there an easy way to add extra fields to the activity audit output?
Are there any plans for enhanced report generation capabilities within RAM with a gui?
I'm sure what I want can be done with programming, but I haven't programmed in years and don't have the time to learn the interfaces and API's to start again now.
Wondering what are other good options? Brio? Other tools?
Thanks!
Say, for example, I want to generate an activity audit for Assets Submitted and Assets Downloaded across the entire repository and I want to see it sorted by Community. I don't see an easy to do that.
The activity audit will give me the repository wide information, but it doesn't include the community name or sorting capability.
Is there an easy way to add extra fields to the activity audit output?
Are there any plans for enhanced report generation capabilities within RAM with a gui?
I'm sure what I want can be done with programming, but I haven't programmed in years and don't have the time to learn the interfaces and API's to start again now.
Wondering what are other good options? Brio? Other tools?
Thanks!
7 answers
... some sleeve rolling required:
In general, you can get this information (see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_create_url_activities.html) as following:
Note that you will get lots of information, ... browser may run out of memory... so you may want to limit by date range, or filter,
You can filter it farther using a search (use your browser to do a search with filters and what not on the web... and click the "search short cut" on the top (middle to the right tool) string, in this case for community Rational Development
see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_joining_data.html
You can use these URL to load (XML data) to Excel and sort, manage, graph ....
In general, you can get this information (see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_create_url_activities.html) as following:
<server>/reporting/activity:tid=(610,650,675)
Note that you will get lots of information, ... browser may run out of memory... so you may want to limit by date range, or filter,
You can filter it farther using a search (use your browser to do a search with filters and what not on the web... and click the "search short cut" on the top (middle to the right tool) string, in this case for community Rational Development
<server>/reporting/activity:tid=(610,650,675)|asset:shortcut=ramSearch:(1fGroup%2Crational_development)
see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_joining_data.html
You can use these URL to load (XML data) to Excel and sort, manage, graph ....
... some sleeve rolling required:
In general, you can get this information (see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_create_url_activities.html) as following:
<server>/reporting/activity:tid=(610,650,675)
Note that you will get lots of information, ... browser may run out of memory... so you may want to limit by date range, or filter,
You can filter it farther using a search (use your browser to do a search with filters and what not on the web... and click the "search short cut" on the top (middle to the right tool) string, in this case for community Rational Development
<server>/reporting/activity:tid=(610,650,675)|asset:shortcut=ramSearch:(1fGroup%2Crational_development)
see http://publib.boulder.ibm.com/infocenter/ramhelp/v7r5m1/topic/com.ibm.ram.web.doc/topics/t_joining_data.html
You can use these URL to load (XML data) to Excel and sort, manage, graph ....
Thanks, Gili.
I think most of my reporting requirements can be met with the Activity Audit report, except it doesn't return "Community" as one of the columns, by default. Is there an easy way to have the Activity Audit supply the Community name for the assets it returns?
The current format just queries the activity table. That table just has the key of the asset the activity is about. It doesn't have any concept of community involved.
Even if you then queried the asset of the activity it would just give you the community the asset is currently in. It wouldn't be able to tell you what community the asset was in at the time of the activity. It could of changed.
Sorry but I can't think of anything right now that could narrow it down to the community of the asset at the time of the activity.
Even if you then queried the asset of the activity it would just give you the community the asset is currently in. It wouldn't be able to tell you what community the asset was in at the time of the activity. It could of changed.
Sorry but I can't think of anything right now that could narrow it down to the community of the asset at the time of the activity.
The current format just queries the activity table. That table just has the key of the asset the activity is about. It doesn't have any concept of community involved.
Even if you then queried the asset of the activity it would just give you the community the asset is currently in. It wouldn't be able to tell you what community the asset was in at the time of the activity. It could of changed.
Sorry but I can't think of anything right now that could narrow it down to the community of the asset at the time of the activity.
Hi Rich,
Our assets don't change community. So, a report of the community that it was in when the activity occurred would be fine.
Is there a way to get that?
I'm talking about roughly 30 communities that I want to report on. An ideal solution would be a repository activity audit that also returned the community the asset was in when the activity occurred.
That way, I could load the results into Excel and do all my sorting and calculations there.
Is it do-able?
Thanks!
... per the sleeve rolling above, .. you can load each community (using a filter on the report) seperately
Okay, so I tried using this report url:
server_name/ram.ws/reporting/activity:tid=(650,675,680,700)|asset:shortcut=ramSearch:(1fGroup%2Csso_storage_management),fromTime=1330574401
but I've hidden the server name info above.
Anyway, it brings up a login screen. I log in and it starts processing. Fifteen minutes later and I'm still waiting.
I went into this same community and ran an activity audit from the Audit tab. I picked the same 4 items to correspond to the tids above and I selected from one week ago, which I believe is the same as the fromTime above.
That audit took about 3 seconds to complete. Shouldn't they be the same? Why does the url report just churn on forever? Is there something wrong in the way I constructed it?
Thanks
You said:
Okay, so I tried using this report url:
server_name/ram.ws/reporting/activity:tid =(650,675,680,700)|asset:shortcut=ramSearch:(1fGroup%2Csso_storage_management),fromTime=1330574401
Try replacing theactivity:tid with assetActivity:tid=(650,675,680,700),fromTime=1330575501
Just using activity:tid would for each asset grab ALL activities in (650, 676, 680, 700) throughout the whole repository with no time limits over and over for each asset.
If you use assetActivity that tells it that you are only interested in those activities for that specific asset.But I think you'll need to include the fromTime also in the assetActivity field. This is is because the '|' simply says pipe the asset into the next request. The fromTime of the asset request was simply telling the search to return assets that were changed from that time. Not the time range of the activities of interest.
Okay, so I tried using this report url:
server_name/ram.ws/reporting/
Try replacing the
Just using activity:tid would for each asset grab ALL activities in (650, 676, 680, 700) throughout the whole repository with no time limits over and over for each asset.
If you use assetActivity that tells it that you are only interested in those activities for that specific asset.