Business intelligence solutions based on ROLAP (relational OLAP) platforms are the implementation of choice for applications accessing the world's largest data warehouses. Compared to multidimensional databases, ROLAP provides vastly superior data breadth and depth, allowing users to drill down to the lowest levels of detail or across to additional dimensions.

With all of its advantages, ROLAP architectures struggle to deliver consistent query performance, especially for ad-hoc information requests for which data has not been pre-aggregated. BI administrators cannot possibly predict every possible combination of measures and dimensions when building aggregate tables.

Enter HyperRoll

HyperRoll brings many of the benefits of multidimensional environments to relational data warehouses and data marts, including near-instantaneous query performance and pre-aggregated fact data across a large number of dimensions, without aggregate tables. In contrast to MDDBSs, however, the Hyperroll engine loads data in a fraction of the time and requires less than a 10th of the storage.

ROLAP Agnostic

Because HyperRoll interfaces directly with the back-end relational database, it works with any ROLAP query or reporting tool that uses SQL, including MicroStrategy, Cognos ReportNet, Business Objects, Actuate, and many others. HyperRoll installs quickly and does not require modification to existing ROLAP applications.

Shortened Batch Windows

Global 2000 companies use HyperRoll to reduce their data warehouseload window from hours to minutes, making intra-day refreshes finally a reality.

Enabling Operational BI

The shift towards operational BI applications deployed on the front line of the business has put even more pressure on existing relational data warehouses to deliver performance. These applications include operational dashboards, BAM (business activity monitoring) applications, and web-based ad-hoc reportingprojects deployed to large numbers of users.

Click here for an illustration of applying real-time analytics.

Instant & Dramatic Results

Once installed, HyperRoll can provide immediate benefit to ROLAP applications that are struggling to deliver consistent query performance or cannot efficiently process concurrent user requests during peak periods. HyperRoll increases end-user satisfaction, raises system utilization, and breathes new life into existing BI applications.