Data Articles

Responsive layouts
icCube has been enhanced with a new set of responsive layouts. It allows the user to create dashboards that need automatic adjustement for different screens. Doc and live examples are...
August 31, 2023
LEARN MORE

How to: create a time bucket dropdown
Wondered how to create a time bucket dropdown in icCube? Here’s a step-by-step guide. To go further, we’ll also show how a chart can change its axis depending on the time bucket. For...
July 6, 2023
LEARN MORE

Gadgets: a new key for dashboard creation efficiency
A data visualization element (chart, table, map etc) can be just the visible tip of an iceberg. The data behind or the invisible complexity of the visual element itself can be highly sophisticated...
March 29, 2023
LEARN MORE

icCube Optimization Guide - Schema RAM usage
Once you have created your multi-dimensional data model (schema) in your development environment, it’s time to move on to the testing phase. Testing not only means testing the model from a...
March 1, 2023
LEARN MORE

How to run icCube in a Docker (on my Mac M1)
Here is a step-by-step guide on how to run icCube in a Docker container, in both - with and without mapping files - scenarios. We'll be showing the steps using Docker Desktop, but you can also use...
September 22, 2022
LEARN MORE

How to use SQLite as a datasource for icCube
When it comes to reading data from files, icCube already has .csv, .json and .xml formats. For more complex usecases, however, these formats are not sufficient. CSV does not support types or multiple...
September 7, 2022
LEARN MORE
icCube architecture setup
icCube can have different deployments and security setups. Single instance / single schema
Single instance / multiple schemas
Single instance with Multi-tenant environments
Several...
August 31, 2022
LEARN MORE

Pixel-perfect BOUM themes & widgets
icCube v8 brings in the ability to create pixel-perfect BOUM themes & widgets. What are these exactly? Pixel-perfect Software and SaaS solutions looking to embed analytics want to make...
April 5, 2022
LEARN MORE

Self-service widgets & features
Even when embedding analytics into a solution, you would sometimes like to give the user high flexibility on the data navigation and exploration. icCube has introduced new widgets and features...
April 4, 2022
LEARN MORE

Filter Panel: enhanced self-service data navigation
icCube has now been enhanced with a powerful new filter: the Filter Panel. It allows the user to add a list of filters based on rules, i.e. 'contains', 'greater than', 'between', 'starts/ends...
February 14, 2022
LEARN MORE

Both v7 & v8 Dashboards on the same icCube Server
To have both v7 Reporting and v8 Dashboards on a same icCube instance, ensure to have the following in your icCube.xml : [code language="xml"]
<!--
Reporting (v8): the new Dashboards...
December 17, 2021
LEARN MORE

The dev2dev version: v8 concepts, functionalities and resources
Given the recent release of icCube's v8 rc1, find here a summary of new concepts, functionalities and resources available with this version made for developers. Plugins / Theme / Widget...
November 11, 2021
LEARN MORE
Embedding icCube into an existing Web Application: Authentication
This article is explaining a typical way to embed icCube into an existing customer Web Application and configure the authentication. icCube will always be “behind” the customer Web...
August 19, 2021
LEARN MORE

Ad Hoc Reporting - What You Need to Know
Ad Hoc Reporting is a form of report creation which allows non-technical users to create and modify reports on the fly without training. Ad hoc reporting generally boils down to three steps. First, a...
October 6, 2020
LEARN MORE

AdventureWorks in icCube?
During one of my icCube demo meetings last year, one of the attendants asked if it is possible to migrate from Microsoft Analysis Services to icCube and what could be potential challenges. Well,...
February 20, 2020
LEARN MORE

Quick Reporting tips
Arthur van den Berg from Inside Vision, icCube's exclusive reseller for the Netherlands, is having lots of success with his quick icCube tips on Linkedin!
We therefore definitely wanted to share...
February 19, 2020
LEARN MORE

Creating your very own HTML widget in icCube
Embedded Analytics truly means allowing for a seamless integration of icCube into other softwares or webpages, not only from a technical point of view, but also from a design point of view.
The...
May 15, 2019
LEARN MORE

Understanding Many-to-Many relations
Many-to-many “m2m” relations are defined by a relation where one object is related to multiple other ones and vice versa, e.g. a bank account can be shared by multiple people and one person can...
January 31, 2019
LEARN MORE

Set up a Member Color Property
Need members to have specific colors on all reports without the need to redefine them each and every time? Check how to do so on this tutorial video that shows how to set up a member color...
January 8, 2019
LEARN MORE

Edit icCube’s Reporting Application’s coloring
How about making some details of icCube's Reporting Editor more personalized to your corporate branding?
A new feature that allows to change the Reporting application’s buttons color as well as...
December 27, 2018
LEARN MORE

Automatic PDF and threshold alerts
Weekly, monthly or quarterly reports? Getting an alert if a threshold is met on your real time data? These two concepts don’t seem similar but the way to set them up is exactly the same on...
December 18, 2018
LEARN MORE

Different layouts for your dashboard
We are usually looking at our dashboards on our computer screens, but sometimes we are on the go and want to quickly check your dashboard on your phone, tablet or even just need the report printed...
December 18, 2018
LEARN MORE

5 features in 5 minutes! (+ Chinese Editor)
On this video, you'll learn how to create an icCube report with 5 features, from basic to advanced: 1 – Table
2 – Filter
3 – Conditional coloring
4 – Sunburst
5 – Event...
September 6, 2018
LEARN MORE

How to : use/change default layout settings
For a same report, you can have different layouts: Tablet, Mobile, Print or Print Landscape. You can customize the widgets (have different configurations across layouts) so they can be better...
August 10, 2018
LEARN MORE

How to : set & view User-Defined configurations
Learn how to you can set different report settings and view the changes you have made!...
August 10, 2018
LEARN MORE

How to : set up filter preselections
Learn how to set preselected elements of a filter list, even if the elements contain commas!...
August 6, 2018
LEARN MORE

How to : write R & Java code within your MDX queries?
icCube now integrates native Java and R. This means that you can build Java and R scripts into your MDX statements. The advantage of having those two languages natively integrated into icCube is that...
April 25, 2018
LEARN MORE

How to : apply filters to discussions and comments
We're about to release version 6.7 - check how you can filter discussions and comments!
Stay tuned for the new release that comes with many more new features! Check all on our release...
April 25, 2018
LEARN MORE

How To : create a waterfall - variance break down (part 1)
A waterfall chart, or bridge chart, a special visualization
often used in financial reports. It is a specific data visualization that shows
how a specific total is transformed to another value by...
April 13, 2018
LEARN MORE

Intercompany elimination with icCube
I knew it from the start.
The moment I started with presenting general ledger data in icCube dashboards, the issue of intercompany elimination would pop-up, eventually. T I had an easy elimination...
February 14, 2018
LEARN MORE

How To : Conditionally color (multi measures)
...
December 26, 2017
LEARN MORE

Performance with icCube – Sum (YTD/MTD)
We’re working hard on the next version that will include some important performance improvements such as smart cache and pre-compilation. In the meantime, there are already a couple of...
December 26, 2017
LEARN MORE

How to: create a localized (translated) schema and report
...
December 26, 2017
LEARN MORE

Creating your first HTML Widget
In this academy post we are going to show how to create your own HTML Widget using icCube Reporting 6. What are Widgets ? They allow for defining your own visualization charts (html/javascript), add...
December 26, 2017
LEARN MORE

Healthcare Advanced Analytics - sumOn/VectorK
In this post we're going to explain one of the latest functions in icCube , sumOn / VectorK , and how it can be used. This start with the use case in the healthcare sector that was tricky to...
December 26, 2017
LEARN MORE

How to confuse your stakeholders with pie charts
You want to get the attention of your stakeholders and decided using a Pie chart.
Did you know Pie charts are one of the worst visualizations available and an ideal way for confusing your audience...
December 26, 2017
LEARN MORE

Quick start: Building your schema (wizard)
Get up to speed from loading your data to creating your first dashboard in 10 minutes.
Lesson #1a:
Building your schema (wizard)
(now...
December 26, 2017
LEARN MORE

Quick start: Building your schema (advanced)
Get up to speed from loading your data to creating your first dashboard in 10 minutes.
Lesson #1a:
Building your schema...
December 26, 2017
LEARN MORE

Quick start: Your first widget
Get up to speed from loading your data to creating your first dashboard in 10 minutes.
Lesson #1a:
Building your schema...
December 26, 2017
LEARN MORE

spatial dashboards, providing location related insights
Always wanted to show location based insights to your audience on a vector map of your own (and not Google maps)? With icCube's custom "Widget Template" you can! Here is how.... In this blog post...
November 10, 2016
LEARN MORE

Web Reporting & Apache Integration
Out of the box, the icCube Web Reporting application is hosted within the embedded HTTP server of icCube. This setup is well suited for “simple” production usages that do not require an...
January 29, 2016
LEARN MORE

High Availability & icCube
Following a recent requirement of one OEM customer, here we explore how to configure icCube for a highly available and redundant solution.
Overview
On the highest level, the customer solution is...
April 6, 2015
LEARN MORE

Creating a new Look and Feel for icCube reports
Creating a user-defined Look and Feel
Half of the work of creating an impacting report or dashboard depends on the Look and Feel you choose. Even though icCube comes with a set of existing themes,...
April 2, 2015
LEARN MORE

Shopping Cart Proximity Analytics with icCube and MongoDB III – OO Extension
Shopping Cart Advanced Analytics with icCube and MongoDB
In part 1 and part 2 of our blog post about icCube and MongoDB, we introduced how to load shopping cart data stored in MongoDB and how to...
September 12, 2014
LEARN MORE

Shopping Cart Advanced Analytics with icCube and MongoDB II – Subcubes
Shopping Cart Advanced Analytics with icCube and MongoDB
In our previous post, we introduced how to load shopping cart data stored in MongoDB to icCube leveraging the array support. Here we...
August 6, 2014
LEARN MORE

Shopping Cart Advanced Analytics with icCube and MongoDB – Part I
Shopping carts are a good example of big data with the need of advanced analytics. Here we present new MDX+ features of icCube – categories, subcubes, and arrays – coupled with the power and...
May 23, 2014
LEARN MORE

MongoDB Reporting and Analytics with icCube
What is NoSQL Reporting? NoSQL Databases are great for high scalability and flexible data storage but reporting can be tricky because of the lack of defined structure and the performance cost....
May 2, 2014
LEARN MORE
Solving a system of Linear Equations using Matrix Algebra in MDX with icCube
Since a couple of versions icCube includes out of the box support for basic Matrix algebra in MDX. There is a support for two basic bricks : vectors and matrices. In this short blog we’re going...
April 28, 2014
LEARN MORE