[Mondrian] Adding Grouping Set support for Distinct Count measures

John V. Sichi jsichi at gmail.com
Mon Mar 31 01:36:30 EDT 2008


Ajit Vasudeo Joglekar wrote:
> 
> The current logic can certainly be optimized for better performance. 
> Could you please share the mdxs that were taking especially longer time? 
> We can start looking into this

This is the one I used for comparison (intentionally pathological to 
make it easy to spot the problem while profiling).  Customer Count 
provides the necessary DISTINCTCOUNT.

With
Set [*BASE_MEMBERS_Customer] as [Customers].[Name].members
Set [*BASE_MEMBERS_Store] as [Store].[Store Name].members
Set [*BASE_MEMBERS_Product] as [Product].[All Products].[Food].children
Member [Customers].[*SUBTOTAL] As Aggregate([*BASE_MEMBERS_Customer])
Member [Product].[*SUBTOTAL] As Aggregate([*BASE_MEMBERS_Product])
Member [Store].[*SUBTOTAL] As Aggregate([*BASE_MEMBERS_Store])
Select
{[Measures].[Customer Count]} on columns,
([Store].[*SUBTOTAL],[Customers].[*SUBTOTAL],[Product].[*SUBTOTAL])
on rows
  From [Sales]
where ([Time].[1997]);

JVS



More information about the Mondrian mailing list