MDX Server

High-performance Analytical Server

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

If you’re an IT person you’ll love the fact that it supports XMLA and can be connected to multiple reporting tools (e.g. Excel)

If you’re a business person you’ll love it’s extremely high performance.

DATA INTEGRATION

Integrate multiple data sources in one schema

    • Relational databases
      • Oracle
      • MySQL
      • PostgreSQL
      • Sybase ASE (jTDS)
      • Amazon Redshift
      • Access (JDK JDBC/ODBC Bridge)
      • Any other datasource with a JDBC driver
    • NoSQL integration
      • MongoDB → native JSON many-2-many
      • Hadoop/Impala
      • Hadoop/Hive
    • Google
      • Google Sheets
      • Google Analytics
      • Big-Query
    • Excel files (xls, csv)
    • Flat files
    • HTTP files
    • Merge multiple Excel and flat files into a single table
    • In-Memory tables
    • Custom connectors on demand
TRANSFORMATION LAYER

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

  • Premade transformations available : Columns to Rows, Group By, Union, Sort and Order
  • Javascript view to implement complex user specific transformations
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
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
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)
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

Do you have further questions ON THE MDX SERVER? CHECK THE FAQ BELOW!

Under Data Integration, there is mention of ETL Layer, Semantic Layer and Offline version. What are these options? What additional features do these options provide to the customers?

ETL is a technology used to extract, transform and load data coming from sources of data. For instance, if you have 2 different Excel sheets, you can write a javascript code on this ETL layer (included in icCube) that can group the data. A very simple Sales example: in one sheet there is the user ID, time of purchase and amount, and on the other sheet there is ID and information on the customer: age, gender, city, etc. You can therefore group them in one table only.

There are softwares that are especially designed for very advanced transformations (ETL purpose only.) Clients with a complex demand on altering data can rework the data on an ETL tool before putting it in icCube. icCube’s ETL includes the following transformations: Columns to Rows, Group By, Union, Sort, GeoCoding, File Dump, Joins, Order and a Javascript view to implement complex user specific transformations.

Semantic Layer is what defines the concepts present on your data from a business point of view (no techy names). For example, you can have on a Sales data sample:

  • Customer
    • Geography
      • Region
      • Country
      • City
    • Time
      • Calendar
        • Year
        • Month
        • Day
      • Product
        • Product
          • Company
          • Category
          • Article

This is the Semantics layer. You define all business concepts in icCube, and when the calculation will be made, it will know which column of the database corresponds to which concept.

Offline version means you can access icCube offline and see the results of your last load even without an internet connexion. You however need to load the schema when you are online as it needs to access the data.

What is MDX and MDX functions? What are the other options that one can use in BI tools instead of MDX? What are the advantages and disadvantages of using MDX? How will it affect customer experience?

MDX is a programming language (MultiDimensional eXpressions) that icCube uses for defining all the calculations (analytics). It’s the syntax you use to write mathematical functions, e.g. how you would write percentage=amount/total amount*100.

MDX is a language developed by Microsoft, meaning it’s not owned by icCube, so people using icCube are using a language that is standard and there are books and courses on it (contact us to learn more) – and it’s a big advantage as they won’t have to learn a new language unlike for other softwares.

It can be considered to be a standard language on the “OLAP world” (multidimensional analysis). Microsoft’s BI product (SSAS) also uses MDX.

icCube’s Olap server is therefore a standard multidimensional server supporting the MDX standard language, i.e. MDX server.

What is MDX+? Is this a unique feature that icCube provide?

MDX+ is the extension of the language MDX: it means we have added functions to the MDX language. Think of it as a “package” of functions that was added (as you can do in Matlab or R) so you have more formulas that you don’t need to redefine! Find the list of functions here.

What is the benefit of providing direct access to Java from MDX?

Java is a common programming language used by a lot (if not most) of programmers worldwide. The advantage is that you can use MDX to access all existing libraries in Java (this might be important for string and data manipulation as well to access some advanced numerical libraries, i.e. apache maths).

What is Web 2.0?

Means icCube is a Web application, it can be opened in any browser.

What data security level does icCube provide? Do we comply with any industry security standards or not?

icCube’s server is on-premise: it means the server is on the client’s side, for example installed in a machine that is physically in the client’s company => we don’t host it, so we don’t have access to any data. It’s like when you install Excel in your machine, Microsoft doesn’t have the access to what you are doing.

This is regarding security of the data. Not to be mistaken with authentication and authorization.

  • Authentication, who you are, is your login to icCube (username & password).
  • Authorization: what you are allowed to do. For example, a general manager within a company can maybe see all the data, a manager from France can only see the data from France whereas an employee of the Paris branch can only see a portion of the data from France (for example, only sales data and no access to financial data). This system of roles can be defined within icCube, and then each user is given their corresponding role. Companies may already have these security systems in place with another software, and icCube will connect to it to look for the information.
What is XMLA and what are the advantages of having such protocol support?

XMLA is a standard protocol that permits icCube’s server to be connected with other reporting tools that support this XMLA standard (e.g. Excel, Tableau, etc). Those vendors didn’t need to do anything special to support icCube.

XMLA is a standard protocol which is an advantage for connecting to reporting tools in general, it means the reporting tool will accept the calculations sent by the server (see MDX above)

What is R? Why does it bring an added value to have the R plugin with icCube?

R is a programming language widely used by statisticians for data science, data discovery and data mining, i.e. testing which algorithm/mathematical model fits best the data.

icCube is a tool for production purpose, not for testing which algorithm fits best. Once the way of analysing the data is defined with R, it can be put to production with icCube.

READ more
READ LESS