icCube: multiple dimensions in MDX output

Question

The documentation of icCube states:

However, a SELECT is not limited to two axes. We could have columns, rows, pages, chapters, and sections. And you could still continue beyond these by specifying a number for the axis.

Indeed, when I try using three dimensions on the demo Sales cube, it works:

select 
    {[paris], [london]} on 0,
    {[2005], [2006]} on 1,
    product.members on 2
from sales

However, when I try four dimensions:

select 
    {[paris], [london]} on 0,
    {[2005], [2006]} on 1,
    product.members on 2,
    measures.members on 3
from sales

I get an error message: Unexpected number of axes (4) for the pivot table (expected:0..3)

What am I missing?

Marc Polizzi Marc Polizzi · Accepted Answer · 2017-10-23T05:59:43

There is nothing wrong with using a 4 axes query. However, it is left up to the client your are using to be able to display it.

For example, Excel accepts 2D results, the icCube pivot table is able to display results up to (and including) 3 axes.

Hope that helps.

icCube: multiple dimensions in MDX output

1 Answers