Saiku OLAP axis, hierarchy, member aggregation

ReportServer (EN)
1

Hi

I’m looking for a way to achieve automatic axis, hierarchy, member aggregation [Total/Count] in Saiku report [Ex. pivot4j aggregation] .

Ex:
if i run following enabling axis, hierarchy, member aggregation, i would like to get the Total

Schema : FoodMart
Cube : Store

Column : [Store Type]
Row : [Store ]

MDX
SELECT Hierarchize(Union({[Store Type].[All Store Types]}, [Store Type].[All Store Types].Children)) ON COLUMNS, Hierarchize(Union(Union(Union(Union({[Store].[All Stores]}, [Store].[All Stores].Children), [Store].[Canada].Children), [Store].[Mexico].Children), [Store].[USA].Children)) ON ROWS FROM [Store]

2

Hi,

in order to see totals you would need to use the “All” dimensions and then use the context menu option “show children” (see the screenshots below). Regrettably, this configuration is only temporary and cannot be saved.

Regards,
Thomas

And now with child dimensions expanded via the context menu:

3

Thanks for the reply.
at least Is there a way to export the temporary data to a Excel report with the aggregations [Total] ? Or this is already planned for a future release ?

4

Hi,

thanks for raising this. In the current version, I am afraid this is not possible. I am currently working on a fix such that the Totals are in the Excel export.

Cheers,
Arno

5

thanks for the reply. Having automatic axis, hierarchy, member aggregation gives additional advantages to user and removes additional complexities in writing MDX query.