|icCube OLAP Server|
[Performance] Query large systems within sub-seconds
We specifically built our OLAP calculation engine for large volumes of highly sparse data. Querying a model of over 20 dimensions, with a range of tens of millions of facts, can be done in sub-seconds. All this without the need for tricky pre-aggregations or cache. Still not enough for you? Give our core team a chance to show what they're able to do. There's always room for improvement.
[Real Time] Continuous Data Update
Since its version 3.0, our OLAP calculation engine supports real time data sources to get instant answers to the most complex and challenging queries against both operational and historical data.
[Excel] Want to use the world's top reporting tool?
With icCube you can use Excel's Pivot tables without the need for any additional drivers or specific plugins.
[Reporting Integration] Want to go the extra mile on reporting?
Thanks to XMLA/MDX compatiblity, it's possible to connect to icCube Server from a wide range of reporting tools (e.g. Microsoft Reporting Services, JPivot, Report Portal).
[Quality and Benchmarking] Concerned about the accuracy and reliability of a newcomer?
For over 10 years, we have been successfully working with blue chip customers, where top quality is a major concern. Top quality is part of our daily business. Some facts: with over 700 published MDX test cases (see documentation examples), our server has been benchmarked against de-facto MDX reference (MSAS 2008). Additionally, over 30% of our lines of code are dedicated to testing.
[Open Technology] Don't be trapped by proprietary vendor solutions
Using well accepted standards, such as XMLA, MDX, JDBC, J2EE, and Java, prevents end-users from getting caught in typical vendor lock-in situations. Thanks to icCube's modular and open architecture, you can for example, choose the relational database and/or the reporting technology that best suits your needs.
[Data-source Agnostic] Feel the freedom
icCube offers straightforward consolidation of disparate data sources. You can source your data not only from any relational database but also from flat files, Excel sheets, HTTP streams, and on-demand from any potentially tabular oriented data source.
[MDX Capabilities] Advanced innovative analytics
Our engine supports state of the art write-back, measure groups, and a wide range of aggregation types (e.g., sum, min, max, count, avg(children), avg(leaves), open, close, open non-empty, close non-empty). And once again, on-demand, custom rollup types are also available.
We are committed to moving MDX/OLAP forward. We've extended the MDX language with functional support and new data types (i.e., matrix, vector) and opened the door to strong analytics thanks to its direct access to JAVA and R code. Additionally, icCube MDX IDE includes an innovative, and patent pending, MDX Debugger and Profiler making MDX developers much more productive.
We also offer the option of building dimension by range, meaning there's no longer any need for one-to-one mapping between facts and dimensions. And not for an overly complex ETL either.
[OS independent] Run your system anywhere
Thanks to our 100% Java solution, you can run icCube solutions on Windows, Linux, 32 or 64 bits.