icCube server


A high-performance 24/7 production-ready real-time Analytical Server with an ETL layer. Designed for multi dimensional analysis and MDX++ standards.

If you’re a Software/SaaS solution wanting to embed analytics into your application(s), you’ll love it as icCube is MADE FOR YOU!

 

SUPPORT

Our team is dedicated to providing you with an excellent experience

  • Swiss quality support
  • Zero open bug policy
  • Best time to market for new user features
  • Community support on stackoverflow

ARCHITECTURE

An architecture ready for Enterprise Integration

  • Single Java process running on any OS with JRE 8+
  • Hot restart
  • All user interfaces web enabled
  • Build to be integrate into existing solutions (Embedded Analytics)
  • Plugin framework to add custom data connectors and new MDX functions.
  • Integration with all XMLA compatible reporting tools
  • Limit resources allocation by role / users.
  • Remote maintenance over XMLA protocol
  • Customizable Authentication/Authorization
  • Native integration with Excel Pivot Table (Windows only)

REAL TIME OLAP SERVER

High quality real time OLAP Server supporting standard MDX/XMLA

  • Real-Time Multidimensional Server made for very sparse & high dimensionality systems
  • Powered by a modern JAVA Real Time In-Memory OLAP aggregation and calculation engine with focus on Quality of Services (QoS)
  • Multi-threaded calculation engine
  • Smart caching, dynamic code compilation and optimization
  • New NON EMPTY crossjoin algorithm with multithreading support
  • Partitioning → breach the 1 billion facts barrier
  • XMLA protocol support
  • Over 150 standard MDX functions implemented
  • 18 native aggregation types (sum,min,avg, distinct,vector…)
  • Over 300 MDX compliance tests

DATA INTEGRATION

Integrate multiple data sources in one schema

  • Relational databases
    • AWS Amazon Redshift
    • Generic JDBC driver
    • IBM db2
    • MySQL
    • Oracle
    • PostgreSQL
    • Snowflake
    • SQL Anywhere
    • SQL Server
    • Sybase ASE (jTDS)
    • Access (JDK JDBC/ODBC Bridge)
  • NoSQL integration
    • MongoDB → native JSON many-2-many
    • Hadoop/Impala
    • Hadoop/Hive
  • Google
    • Google Analytics
    • BigQuery
    • Google GDrive (Sheets)
    • Storage (CSV)
  • Files
    • CSV (File/HTTP)
    • Excel files (CSV)
    • Excel files (xls)
    • JSON (File/HTTP)
  • Others
    • In-Memory tables (CSV)
    • SPSS (sav) – Beta
    • Custom connectors on demand

TRANSFORMATION LAYER

ETL: Combine and transform any icCube tables from different data sources into a new table (view)

  • Classic transformations
    • Columns to Rows
    • Row to Columns
    • Group by
    • Sort
    • Parent/Child sort
    • Union
    • Join
    • Column Rename
  • Source Code
    • Java
    • Java Simple Row
    • Javascript (deprecated)

SCHEMA / SEMANTIC LAYER

Define your business concepts

  • Define your semantic layer using icCube’s thin client IDE
  • Many-to-many relation
  • Unbalanced dimensions (ragged, parent/child)
  • Asymmetric dimensions
  • Direct definition of many to many relations when using no-sql datasources as MongoDb
  • Create calculations using standard MDX language
  • Localization of the semantic layer (e.g. country names on different languages)

ADVANCED ANALYTICS / MDX++

MDX+ is icCube’s extension package to the standard MDX language

  • Over 50 new generic MDX functions
  • 45 Time Intelligence functions to manage date/time dimensions
  • Categories
  • Vector and Matrix syntax
  • Dynamic creation of new classifications/hierarchies (Real Time)
  • Non additive, vector (e.g. to support VaR, indirect many-to-many) aggregation types
  • Direct access to Java from MDX
  • Unique patented MDX debugger and profiler
  • Native R integration for advanced statistical modeling