MicroStrategy Acceleration
Transforming data outside the BI layer for increased speed
MicroStrategy provides visual information on cumulative financial performance, strategy management, and business intelligence, typically for analytical purposes. The SortCL program in the IRI Voracity platform or the constituent IRI CoSort Product converts disparate, structured data into CSV and other common „feed“ file formats outside of the BI layer.
When SortCL sorts, merges, and aggregates raw data records in a single job and I/O pass before MicroStrategy, users can get their BI results in half the time.
In a recent benchmarking, a MicroStrategy user took 193 seconds to create a report requiring sort, join, and aggregate transformations. SortCL performed the same transformations externally in 23 seconds. His data was available for multiple applications. The same user took an additional 77 seconds to run the same report using SortCL data, resulting in a new total runtime of 100 seconds.

Further information on the benchmark and CoSort's interaction with MicroStrategy can be found here.