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.

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.