IcCube

From Wikipedia, the free encyclopedia
Jump to: navigation, search
icCube OLAP Server
Iccube-logo
Developer(s) icCube software Sarl
Stable release
6.0 / October 20, 2016 (2016-10-20)
Operating system Cross-platform (JVM)
Type OLAP
Website http://www.iccube.com

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.

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[edit]

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[edit]

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.

Date Version Event
June 2010 0.9.2 The very first published version (sort of preview) of the in-memory OLAP server; MDX/XMLA support are the primary objectives.
November 2010 1 Building on the feedback of the community this is the first features complete (e.g., MDX, write back, ...) version. A community (free) version.
June 2011 1.3 Listening on the community, v1.3 continues to expand on the MDX support and offers stronger cube modeling features; worth noticing this is the first version of the visualization library (GVI).
October 2011 2 An important step for icCube as this is the first Enterprise ready (vs Community) edition.
April 2012 2.5 Due to the increasing demand for an icCube native reporting, this is the first version featuring the Web Reporting server.
January 2013 3 An important step in term of performances and MDX/OLAP features bringing the first generation MDX/OLAP engine to its limit.
June 2013 4 Featuring a second generation calculation engine, v4 is the most matured edition of the icCube OLAP server and is making real-time / operational BI a reality.
January 2015 4.8.2 Improving the 4.x versions (server features and speed, Web Reporting, etc...).
May 2015 5.1 Featuring an ETL for an end-to-end BI solution, Web Reporting in community edition, server features and speed, etc...
May 2016 5.2 Improving the 5.x versions (server features and speed, Web Reporting, etc...).
October 2016 6.0 Brand new reporting and new server calculation engine that paves the way for future optimizations and distributed processing.

Architecture[edit]

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[edit]

icCube is natively using MDX standard as its query language and is supporting several extensions [1] to the original language : function declarations, objects, Java and R interactions.[2]

icCube is supporting a unique MDX patented [3] 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+[edit]

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[edit]

icCube comes with two different APIs : the standard XMLA interface and its proprietary GVI interface.

XMLA[edit]

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[edit]

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.[4] Javascript is the primary implementation language but a Java mapping library is available as well.

See also[edit]

References[edit]

External links[edit]