WORKITEMS_SNAPSHOT is not showing any table list from Birt Plugin
Hello ,
I am trying to follow tutorials available on the internet about creating custom reports with BIRT - However I am not able to see any tables when I select WORKITEMS_SNAPSHOT as my data source and try to create data set from it. Other Snapshots e.g. Live Snapshot gives me back result . Any idea / help about why WORKITEMS_SNAPSHOT is not returning tables information will be greatly appreciated. My Configurations as follows BIRT BIRT Chart Framework 2.6.2.r262_v20101008 BIRT Chart OSGi Runtime Feature 2.6.2.r262_v20101025 BIRT Chart OSGi Runtime SDK Feature 2.6.2.r262_v20101025 BIRT Example Source Feature 2.6.2.r262_v20101008 BIRT Framework 2.6.2.r262_v20101008 Eclipse : Version: Helios Release Build id: 20100617-1415 RTC Rational Team Concert Version: 4.0.0.1 Build id: RTC-I20120911-1740 Thanks in advance kabir
showing 5 of 7
show 2 more comments
|
Accepted answer
|
Hello Donald and Ralph
Thank you for your input - The issue has been resolved for me at least. I discovered that our Server Version was 5.0.2 but the client i was using was Version: 4.0.0.1 - This morning i installed client for 5.0.2 from IBM installation manager and Bingo - I could see the tables coming in for Work item snapshot. Thanks again for pointing me to some useful resources. Best regards kabir Ralph Schoon selected this answer as the correct answer
|
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.
Comments
If you check the .metadata/.log file, can you see any errors?
The other thing to mention is that there needs to be data there. The data collection jobs need to be running, have to have already run once successfully, and there need to be work items that actually contribute.
Thank you for providing all the environment details in your question!
Can you check if the WORKITEMS_SNAPSHOT is run in the report section?
Do you have a production server - that runs the whole time? The data collection job in 4.x is run once a night. Does it maybe collide with the nightly reboot time?
If it is a test system, can you run the collection job manually?
@Donald : There is nothing in the log file. just to make sure i deleted the content and kept file empty . Create Data Set which did not returned any table in the UI and there was no entry appeared in the log as well.
@Ralph : Sure Data is there , we are running reports from web UI - I think this not related to data ( i may be wrong though) but i am not seeing Table name under Fact Information Window of data set creation wizard.
about your question Can you check if the WORKITEMS_SNAPSHOT is run in the report section?: Not sure how to do that can you guide me a bit to do this ?
Much appreciated your response, is there any work around creating custom reports ? We are really in need of doing this and I want to get rid of excel export and fiddling with data in excel to generate charts and reports
The WORKITEMS_SNAPSHOT corresponds to the data collection job "Work Items". So make sure this job has been run successfully.
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20
Hi Donal,
Thanks for responding. I have glanced through the link you provided. It does explain what a snapshot is however I am not sure how to run the data collection job. I dont have administrator access to server . is that what only can be done by administrator ? any pointer are much appreciated.
You do need someone with the "JazzAdmins" role to perform this.
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_4.0.0/com.ibm.rational.reporting.admin.doc/topics/t_running_the_data_collection_jobs.html