[Mondrian] Adding Grouping Set support for Distinct Count measures

John V. Sichi jsichi at gmail.com
Mon Jan 28 17:33:48 EST 2008


Ajit Vasudeo Joglekar wrote:
> 2) Aggregation of a normal (non distinct count) measure for select members
> 
> It is possible to get this working since it is very similar to case 1). 
> There is a issue here though. Lets say for whatever reason user wants to 
> aggregate
> 
> Aggregate([Store].[All Stores].[USA].[CA], [Store].[All 
> Stores].[USA].[CA], [Store].[All Stores].[USA].[OR]) over 
> [Measures].[Unit Sales]. The expected value here is (2 * CA + OR) for a 
> non distinct count measure. The sql generated like above will not result 
> in correct aggregation value

I don't see an issue here; the desire to "double-count" CA by including 
it in the set twice would be misguided, since a set is a set (no dups).

JVS



More information about the Mondrian mailing list