Simba’s standards-based MDX query language technology and its incredibly deep data connectivity expertise were the catalysts for Kognitio’s ability to provide multi-dimensional query and analysis functionality within the Kognitio Analytical Platform. Simba’s solution enables our customers to use the OLAP-based BI front-end of their choice – including IBM Cognos, Microsoft Excel PivotTables and SAP BusinessObjects – to perform extreme analytics on Big Data and fully leverage the power that Kognitio delivers. By engaging Simba to work with us, we’ve been able to leapfrog our competitors by combining the in-memory prowess of the Kognitio Analytical Platform with Simba’s leading OLAP expertise for enabling connectivity to large-scale virtual cube environments.

Company Overview

For more than a generation, Kognitio has been a pioneer in software for advanced analytics, helping companies gain greater insight from large and complex volumes of data with low latency and limitless scalability for competitive business advantage. The Kognitio Analytical Platform can be used as a data science lab or to power comprehensive digital marketing analytics; it runs on industry-standard servers, as an appliance, or in Kognitio Cloud, a ready-to-use analytical Platform-as-a-Service (PaaS) in a public or private cloud environment.

Simba Product / Solution

Custom, Big Data ROLAP/MDX Provider for Kognitio

Key Requirements

  • Microsoft Excel PivotTable connectivity/OLAP-based BI connectivity
  • Virtual cubes to build terabyte-sized data cubes in seconds, not hours
  • Direct data connectivity leveraging the full power of Kognitio’s in-memory, MPP database for analytics on big data

The Challenge

The Kognitio Analytical Platform is recognized for its performance, scalability and ability to rapidly analyze massive amounts of Big Data through its in-memory capability. Kognitio wanted to add multi-dimensional reporting capabilities that enable OLAP cubes to be replaced by virtual in-memory ones. For this, the OLAP solution needed standards-based multi-dimensional connectivity with any applications. The Simba MDX Extension for Kognitio enables incredibly powerful analytics to be done simply in Excel or in concert with any standard business intelligence reporting or visualization tool.

The Solution

Simba built a custom MDX query language solution for Kognitio that leverages Kognitio’s proprietary, in-memory, big data, analytics technologies to provide their customers with OLAP-based reporting using the BI tool of their choice. Simba’s MDX query language solution combines MOLAP performance with ROLAP scalability to provide Kognitio with a distinct competitive advantage.

The Results

Simba provided the necessary metadata mapping and structure to create a star schema data configuration within the Kognitio database. This structure provides the foundation for building virtual data cubes within the database. MDX is a fully compliant, standards-based OLAP API tailored for in-memory database application on big data, providing MOLAP performance with ROLAP scalability.

By choosing Simba’s commercially available MDX query language technology, Kognitio provided their customers with the widest choice of multi-dimensional BI tools for feature-rich, fast analysis of their data.