New Query Model Features

Please list any new features you would like to see in the Olap4J Query Model on this page.

Visual Totals

Currently, very much like JPivot there is no support for the VisualTotals() MDX function. This is a very useful function, that is sorely missed by business users. What we discussed in Barcelona was a similar function call in Olap4J to Hierarchize() which is a very simple:

query.getDimension(dimensionName).setHierarchizeMode(hierachizeMode);

So I propose a function call very similar:

query.getDimension(dimensionName).setVisualTotals(true);

Since Will Gorman introduced drilling though, he says, hierarchizeMode is broken, so I would assume it would also affect this call.