ReportServer Forum

mahesh

Member

Registered: 2016-07-16

Saiku OLAP axis, hierarchy, member aggregation

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]

Last edited by mahesh (2016-07-16 10:13:47)

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: Saiku OLAP axis, hierarchy, member aggregation

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:

mahesh

Member

Registered: 2016-07-16

Re: Saiku OLAP axis, hierarchy, member aggregation

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 ?

Last edited by mahesh (2016-07-18 05:13:50)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Saiku OLAP axis, hierarchy, member aggregation

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

mahesh

Member

Registered: 2016-07-16

Re: Saiku OLAP axis, hierarchy, member aggregation

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