Aggregate Export
The aggregate export is a convenient way of calculating the same statistical values throughout our products and storing them to a table where they can be retrieved. Aggregate exports are scheduled the same way as other deliverables in ERS and run on data groups, but the results are dropped off in a flattened SQL table. This makes it easy for an IT organization to pull these values for integration with other systems or outside reporting such as an intranet or portal website.
IT professionals no longer need to become statisticians! ERS aggregate exports can do the work!
Use in QC-Mobile
Aggregate export results are now being used in several places throughout QC-Mobile including home screen widgets. This allows the screen to load much faster since the data is queried, compiled, and statistics are calculated offline allowing the home screen to simply render the answers on screen.
Auto-Replacement of Calculations
Also available is the option for ERS to automatically replace the exported values with the latest values. This allows simpler querying that always pulls the latest calculations for a given export.
Query Samples
The ERS Help documentation contains several examples of how to use and query this data.