search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 99 forks source link

Count aggregator includes other aggregated values. #71

Closed mysticfall closed 11 years ago

mysticfall commented 11 years ago

Count type aggregator wrongly includes other aggregated values in calculation.

For example, adding sum and average aggregators to the column axis with a count type aggregator at the last position, it will report 3, instead of 1 as it counts including other aggregated columns.

SELECT {[Measures].[Unit Sales]} ON COLUMNS, Hierarchize(Union({[Store].[All Stores]}, [Store].[All Stores].Children)) ON ROWS FROM [Sales]