Developer(s) icCube software Sarl Type OLAP | Operating system | |
 | ||
Stable release 6.0 / October 20, 2016 (2016-10-20) | ||
icCube is a business intelligence Enterprise software used for data analytics and reporting to get insights from a wide range of types of data, querying data across multiple datasources (e.g., RDBMS, Excel files, CSV files, MongoDB, etc). icCube has been especially developed to integrate IT environments, from webpages to 24/7 production solutions.
Contents
icCube’s server is on-premise and covers ETL - XMLA/MDX Real Time Analytical In-Memory OLAP Server - Web Reporting in a single application. It has been especially made to be Enterprise and OEM/Embedded Analytics ready.
icCube’s Reporting server leverages multi-dimensional concepts (e.g., drilldown, slice, dice, etc...) to create interactive Real Time Web dashboards.
About the company
icCube is a company providing a Business Intelligence solution founded in Switzerland. Labelled Swiss Made Software, icCube is live in 24/7 environments and used worldwide. Precision and reliability are key values of the company.
History
Starting in June 2010 with its first public community version (0.9.2), the latest icCube OLAPserver version (v6.0 RC1) has been released in October 2016.
Architecture
icCube is implemented in Java and follows J2EE standards. For the latter, it embeds both an HTTP server and a servlet container to handle all the communication tasks.
Being an in-memory OLAP server, the icCube server does not need to source its data from a RDBMS; any data source that exposes its data in a tabular form can be used; several plugins exists for accessing files, HTTP stream, etc...
Accessing icCube (i.e., cube modeling, server monitoring, MDX queries, Web reporting and dashboards) is performed through a unique Web interface.
The icCube OLAP server does not use any caching or pre-aggregation mechanism. Therefore all drilldowns and computations are performed on demand. Coupled with a multi-core MDX/OLAP engine this allows for near real-time / operational analytics.
MDX/XMLA
icCube is natively using MDX standard as its query language and is supporting several extensions to the original language : function declarations, objects, Java and R interactions.
icCube is supporting a unique MDX patented debugger that shortens the learning curve of this language for beginner and intermediate MDX programmer. And for advanced and expert users are able to fully understand what is happening behind the scene and how the MDX queries are actually processed.
Thanks to the XMLA protocol, icCube can connect to any XMLA compatible reporting tool.
MDX+
icCube has implemented over 50 new generic MDX functions and 45 Time Intelligence functions to manage date/time dimensions. It also includes Categories, Vectors, Matrices and dynamic creation of classifications and hierarchies (Real Time). icCube includes non additive vector as a native aggregation type (e.g. to support VaR, indirect many-to-many).
APIs
icCube comes with two different APIs : the standard XMLA interface and its proprietary GVI interface.
XMLA
icCube supports XMLA over HTTP that allows connection from any XMLA compliant front-ends (e.g., Excel, MS Reporting Services, JPivot...) and programming libraries (Olap4J for Java, ADOMD.NET for .NET, xmla4js for Javascript).
GVI
Apart from the standard XMLA protocol, icCube supports its own proprietary protocol : GVI. HTTP based, it is lighter than XMLA and can be extended as will to support the icCube Web Reporting.
This protocol leverages the Google Visualization wire protocol. Javascript is the primary implementation language but a Java mapping library is available as well.