Data Articles

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...

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...

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...

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...

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...

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...

icCube can have different deployments and security setups. Single instance / single schema Single instance / multiple schemas Single instance with Multi-tenant environments Several...

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...

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...

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...

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...

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...

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...

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...

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,...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Learn how to you can set different report settings and view the changes you have made!...

Learn how to set preselected elements of a filter list, even if the elements contain commas!...

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...

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...

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...

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...

...

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...

...

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...

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...

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...

Get up to speed from loading your data to creating your first dashboard in 10 minutes. Lesson #1a: Building your schema (wizard) (now...

Get up to speed from loading your data to creating your first dashboard in 10 minutes. Lesson #1a: Building your schema...

Get up to speed from loading your data to creating your first dashboard in 10 minutes. Lesson #1a: Building your schema...

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...

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...

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...

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,...

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...

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...

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...

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....

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...