It's all about the answers!

Ask a question

Can JRS reports using LQE and ETL data collection jobs co-exist

Richard Guzdek (113) | asked Dec 07 '15, 5:17 p.m.


Were currently running RTC 5.0.2 and JRS/JTL 6.0.

We've currently switched over to DCC using JRS reports our ETL jobs are disabled.  It's understanding DCC and ETL cannot co-exist.  Our user base likes the JRS reports and the drill down ability but there is also desire use the Insight reports for burn downs etc...  We've gone down the path of having excel to use output from the JRS reports and with excel creating trend reports but this is becoming a lot of overhead creating reports.

If JRS is configured to use LQE instead of DCC, can the ETL jobs for the insight reports be re-enabled to run without any issues?

thanks for any insight!


2 answers

permanent link
Geoffrey Clemm (30.1k33035) | answered Dec 07 '15, 7:54 p.m.
There are a few things being confused here.
First it is important to separate what stores information in the data warehouse from what reads information from the data warehouse to produce reports.
For storing information in the data warehouse, you have the choice of using an ETL or a DCC.   If you have not customized what information is being stored, you should always use a DCC (much faster).    If you have customized the information being stored, currently you need to use an ETL, but keep an eye out for DCC enhancements that allow you to customize what data is being stored (and what data sources are being used).
For reading information from the data warehouse, you have the choice of Cognos (aka Insight) Report Studio or the Jazz Report Builder (or just use SQL).   I'd recommend always trying the Jazz Report Builder first, and only if that doesn't allow you to create the report you want, fall back on SQL or Cognos.

The above was all bout the Data Warehouse.   As an alternative to the Data Warehouse, there is LQE.  
Unlike the Data Warehouse, you do not store information in the LQE by either an ETL or DCC, but rather by a TRS (tracked resource set).  
For reading information from the LQE, you have the choice of the Jazz Report Builder (not Cognos) or SPARQL (not SQL).   As with the Data Warehouse, I'd recomment always trying to use the Jazz Report Builder first, and only if that doesn't allow you to create the report you want, fall back on SPARQL.

Now to your actual question:
It doesn't make sense to talk about configuring JRS to use LQE instead of DCC (LQE is a data source ... DCC is a data collection mechanism).   So you can have JRS use LQE instead of the Data Warehouse (different data source choices), or you can have JRS use ETL instead of DCC (different data collection mechanisms).   Which did you have in mind?

WRT your comment, note that there is no such thing as an "ETL Report" ... ETL is a way of storing information in the Data Warehouse, not a way of producing reports.   The only reason to use an ETL instead of DCC is if you have customized what data is being stored in the data warehouse (in which case, today, you have to use an ETL and not a DCC).   The main thing you cannot do is use both an ETL and a DCC to read data from the same data source and write to the same Data Warehouse.

permanent link
Guido Schneider (3.4k1491115) | answered Dec 07 '15, 5:23 p.m.
Why not using DCC collection Jobs? They do exactly the same than the old ETL jobs, but smarter and faster. DCC is writing in same Datawarehouse and everithing is available from Insight like it was with ETL jobs.

LQE can reside parallel to DCC, so you always can have both in parall.


Richard Guzdek commented Dec 07 '15, 5:41 p.m.

Hi Guido,

The users like the ETL reports/Insight reports it allows more flexibility out of the box ready to go when it comes down to burn down reports.  To replicate these reports in JRS we configure excel spreadhseets to receive the output from the JRS report and use excel to create trend line reports. The user community is use to have to these front and center on each teams dashboard, now it's look at the spreadsheet generated yesterday posted at this location.   That along with some fields available to Insight reports not available in JRS reports have users requesting the old reporting mechanism

hope this helps explain the situation



Your answer

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