Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Inconsistent data in reports built using ReportBuilder

Hi -

A report builder report which reports on current data is showing stale data in the report on opening of the report. Are report builder reports built off current data or replicated data?

Best Regards,
Elaine.
 

0 votes



3 answers

Permanent link

Hi Arne -

The report I am seeing issues in queries for a list of work items with a certain field set -

the work item is new work item we created for our project [Change Request report type]
the field we query for is a date field [called Planned Deployment Date]

The report lists the Change Requests with Planned Deployment Date set, grouping the Change Requests based on date/time. We see that the Status attribute [using default RTC Status attribute for the WI] is incorrect - even when the report is initially opened. We have seen CRs where the status has been modified over 3 hours ago showing up incorrectly when the report is just opened.

The Report is built using Report Builder.

Best Regards,
Elaine.

1 vote

Comments

Hi Elaine,
sorry that I assumed you were reporting on DNG. Anyway, for work items it is essentially the same. When you use Data Warehouse as a data source in Report Builder the up-to-dateness of the data relies on how often DCC runs the respective ETL jobs (cp. https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.rational.dcc.doc/topics/c_ovr_process_etl_rrdi.html )
Can you check with a regular work item query (not report builder) if freshly created items show up immediately? Some widgets in dashboards run off BIRT reports which also use direct access as data source. For any other kind of reporting the ETL job needs to run often enough for your expectations --> either increase frequence of ETL jobs for DCC or use LQE as datasource for Report Builder
Or use work item queries - they should always be up to date.


Permanent link

Hi Elaine,

please cp. my answer and comment in: https://jazz.net/forum/questions/244235/why-dont-i-see-newly-entered-requirements-into-dng-when-immediately-generating-a-report-using-jazz-reporting

Basically in JRS the report builder will use either Data Warehouse or LQE as its data source. Depending on the tables you can run a report against Data Warehouse that fetches life data from the repository but most reports run against tables where the DCC pushes data in frequently (e.g. every hour or so). In LQE the cycles are typically faster and data is synched to the index every 60 seconds or so.

It pretty much depends on the exact report and data source. Can you share some more details?

- Arne

0 votes


Permanent link

Report Builder reports are not built using live data directly from RTC.  They will be using either the data warehouse or LQE as the data source.  The data warehouse data will be refreshed likely by DCC jobs  (or depending on your version of RTC, possibly the older ETL's).  You will want to check with your administrator to see how often the data is refreshed in your warehouse.


0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 1,220
× 359

Question asked: Sep 14 '17, 9:04 a.m.

Question was seen: 2,950 times

Last updated: Sep 19 '17, 2:07 p.m.

Confirmation Cancel Confirm