Reporting from customized WI using Birt
Hello,
Currently I am working over report form customized WI, but my main problem is getting value from my attributes like lists ( list of users ) and enumerations.
I have created data set on WORKITEMS_SNAPSHOT and Enumeration table but i get no results, it shows that table is empty.
Any ideas or help ?
Currently I am working over report form customized WI, but my main problem is getting value from my attributes like lists ( list of users ) and enumerations.
I have created data set on WORKITEMS_SNAPSHOT and Enumeration table but i get no results, it shows that table is empty.
Any ideas or help ?
Accepted answer
On 9/17/2009 9:23 AM, bchrabski wrote:
For the Enumerations table, have you passed in as a parameter the name
of the enumeration? If you do this, it should return rows with all the
literals in the enumeration.
Just to check, are you running on a server with some meaningful data,
and have the data warehouse snapshots run? (If the server has been up
permamently for more than a day, then the snapshots should have run
automatically - if this is just a server you bring up occasionally, then
probably not).
Hope this helps.
james
RTC Reports Team Lead
Hello,
Currently I am working over report form customized WI, but my main
problem is getting value from my attributes like lists ( list of
users ) and enumerations.
I have created data set on WORKITEMS_SNAPSHOT and Enumeration table
but i get no results, it shows that table is empty.
Any ideas or help ?
For the Enumerations table, have you passed in as a parameter the name
of the enumeration? If you do this, it should return rows with all the
literals in the enumeration.
Just to check, are you running on a server with some meaningful data,
and have the data warehouse snapshots run? (If the server has been up
permamently for more than a day, then the snapshots should have run
automatically - if this is just a server you bring up occasionally, then
probably not).
Hope this helps.
james
RTC Reports Team Lead
7 other answers
James,
Thanks for your reply, I have created data set on enumeration with no parameters so I should get all data. I've manually make snapshot using web UI so I do not this it is problem with refreshing.
Thanks for those movies but for me it does not work.
http://jazz.net/library/video/288
http://jazz.net/library/video/289
Thanks for your reply, I have created data set on enumeration with no parameters so I should get all data. I've manually make snapshot using web UI so I do not this it is problem with refreshing.
Thanks for those movies but for me it does not work.
http://jazz.net/library/video/288
http://jazz.net/library/video/289
Thanks for your reply, I've checked that even when I specify PROJECT_AREA_ITEMID the query returns no results.
I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?
james
On 9/21/2009 4:08 AM, bchrabski wrote:
James,
Thanks for your reply, I have created data set on enumeration with no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.
Thanks for those movies but for me it does not work.
http://jazz.net/library/video/288
http://jazz.net/library/video/289
I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?
james
You also need to pass in the project area. In 2.0.0.1, you can set the project area parameter to '{Current Project Area}' and that will give you the enumerations contributed by the project area you are reporting on.
For 2.0, it is a bit more complicated. The following two videos describe it:
http://jazz.net/library/video/288
http://jazz.net/library/video/289
Rafik Jaouani
Developer (Reports Team)
For 2.0, it is a bit more complicated. The following two videos describe it:
http://jazz.net/library/video/288
http://jazz.net/library/video/289
Rafik Jaouani
Developer (Reports Team)
A data set with no parameters on the ENUMERATIONS table will always give you an empty result. As I have already stated, data sets based on the ENUMERATIONS table always require a project area to be passed.
You can go to this page and download the report design that is described in the video.
https://jazz.net/wiki/bin/view/Main/ReportsCentral
You can go to this page and download the report design that is described in the video.
https://jazz.net/wiki/bin/view/Main/ReportsCentral
On 9/21/2009 4:08 AM, bchrabski wrote:
I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?
james
James,
Thanks for your reply, I have created data set on enumeration with no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.
Thanks for those movies but for me it does not work.
http://jazz.net/library/video/288
http://jazz.net/library/video/289
I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?
james
Interesting. Could you open a work item against the Reports component,
and attach your .rptdesign file (or a simplified one that demonstrates
the problem, if your report is sensitive)? That way we can debug the
problem more readily.
Thanks,
james
RTC Reports Team Lead
On 9/22/2009 8:38 AM, bchrabski wrote:
and attach your .rptdesign file (or a simplified one that demonstrates
the problem, if your report is sensitive)? That way we can debug the
problem more readily.
Thanks,
james
RTC Reports Team Lead
On 9/22/2009 8:38 AM, bchrabski wrote:
Thanks for your reply, I've checked that even when I specify
PROJECT_AREA_ITEMID the query returns no results.
jmoodywrote:
On 9/21/2009 4:08 AM, bchrabski wrote:
James,
Thanks for your reply, I have created data set on enumeration with
no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.
Thanks for those movies but for me it does not work.
http://jazz.net/library/video/288
http://jazz.net/library/video/289
I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?
james
On 10/7/2009 2:37 AM, hanzas wrote:
Hi Hanzas,
I recommend that you post on the Rational Quality Manager forum, it
sounds like this is an RQM-specific question.
james
RTC Reports Team Lead
Hi,
I am trying to create the earned value chart using BIRT in RTC. This
Earned value chart should consist of Actual test execution series
against Planned test execution series for the selected iteration
(Test milestone).
When i tried to do this, am able to get the values for the Actual test
execution series for the selected iteration. when it comes for the
planned test execution series, planned startdate and planned end date
that i see on the RQM Testplan under test schedule data is not visible
in the datasets.
Please suggest me how to proceed? and if any similar report is already
existing request you to shed light on that too.
Any kind of help to get this Earned value chart are welcome.
Thanks,
Hanzas
Hi Hanzas,
I recommend that you post on the Rational Quality Manager forum, it
sounds like this is an RQM-specific question.
james
RTC Reports Team Lead