[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