how to decide that I need RQM live reporting ?
Accepted answer
Hello Silvia,
the advantage of RQM live reporting over the data warehouse model is mainly that the data you see in the report is up to date with what you have in the tool. The data warehouse contains a snapshot of the RQM data at the time the last data collection job was executed.
The disadvantages of RQM live reporting are that
Francesco
the advantage of RQM live reporting over the data warehouse model is mainly that the data you see in the report is up to date with what you have in the tool. The data warehouse contains a snapshot of the RQM data at the time the last data collection job was executed.
The disadvantages of RQM live reporting are that
- the data is generated in real time from the RQM REST API, without using a database, and is subject to severe performance problems when the data volume increases.
- Additionally the RQM live data model is more restricted than the data warehouse data model and offers limited possibilities for cross reporting with the other CLM applications.
- Last, the list of projects and the user credentials are hard coded in the xdc file, so every time you have a new project in RQM or the data collector user password is changed, you will need to generate a new xdc file.
Francesco
2 other answers
Hi Silvia,
This is a common discussion that I have with clients. Assuming you are talking about RQM live reporting in RRDI or Insight, the key advantage is that you are able to get the latest (live) results in your reports. However, you need to be careful as there is a performance impact. The reports will generate much slower than a non-live report (Data warehouse) because everything is being generated on the fly (the querying of the RQM reportable REST API and the Insight/RRDI report filters, formatting, etc.). You also have to take into account the network latency between the RQM and Report server.
Depending on your report design query and/or how many live reports you are running, the Insight/RRDI Report server will experience a higher cpu utilization. Also, you would want to monitor your RQM server to make sure it is not experiencing any significant impact.
When most people hear "live" reporting, they tend to get excited and are not aware of the trade-offs. The bottom line is that the report requirements determine whether or not you need a live report. If the report's purpose is the be reviewed each morning, for example, then a data warehouse report will suffice. If the report will be access multiple times a day, randomly, then this would likely be a live report.
Hope this helps.
This is a common discussion that I have with clients. Assuming you are talking about RQM live reporting in RRDI or Insight, the key advantage is that you are able to get the latest (live) results in your reports. However, you need to be careful as there is a performance impact. The reports will generate much slower than a non-live report (Data warehouse) because everything is being generated on the fly (the querying of the RQM reportable REST API and the Insight/RRDI report filters, formatting, etc.). You also have to take into account the network latency between the RQM and Report server.
Depending on your report design query and/or how many live reports you are running, the Insight/RRDI Report server will experience a higher cpu utilization. Also, you would want to monitor your RQM server to make sure it is not experiencing any significant impact.
When most people hear "live" reporting, they tend to get excited and are not aware of the trade-offs. The bottom line is that the report requirements determine whether or not you need a live report. If the report's purpose is the be reviewed each morning, for example, then a data warehouse report will suffice. If the report will be access multiple times a day, randomly, then this would likely be a live report.
Hope this helps.
Good Morning Silvia,
The only advantage of using the RQM live reporting is the ability to obtain data from your environment "as is". As oppose to the other method of using a ODS (Operational Data store) or Data Warehouse which would be used to store your data over a course of time from oldest to most recent, but with a data warehouse you'll be able to isolate your information to single or more queries if needed. Live reporting could be beneficial but also it could cause additional strain on the RQM application if you are using live reporting when in use with many active users.
I hope this helps.