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.