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.
Integrate multiple data sources in one schema
Combine and transform any icCube tables from different data sources into a new table (view)
Define your business concepts
MDX+ is icCube’s extension package to the standard MDX language
High quality real time OLAP Server supporting standard MDX/XMLA
An architecture ready for Enterprise Integration
Our team is dedicated to providing you with an excellent experience
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:
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.
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.
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.
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).
Means icCube is a Web application, it can be opened in any browser.
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.
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)
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.