It's all about the answers!

Ask a question

Inconsistent data in reports built using ReportBuilder

Elaine Humphreys (2327) | asked Sep 14 '17, 9:04 a.m.
retagged Sep 14 '17, 9:19 a.m. by Jackie Albert (1.6k14946)

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,

3 answers

permanent link
Elaine Humphreys (2327) | answered Sep 19 '17, 7:55 a.m.

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,

Ulf Arne Bister commented Sep 19 '17, 8:54 a.m. | edited Sep 19 '17, 8:59 a.m.

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. )
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
Ulf Arne Bister (1.3k313) | answered Sep 14 '17, 10:12 a.m.

Hi Elaine,

please cp. my answer and comment in:

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

permanent link
Jackie Albert (1.6k14946) | answered Sep 19 '17, 2:07 p.m.

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.

Your answer

Register or to post your answer.