[Mondrian] distinct-count and explicit aggregate table recognition

[Tomasz Karlik]

I am getting different results while running simple query on FoodMart
(PostgreSql db). Result differs and seems to be wrong when using
explicit aggregate. I've created simple test which shows this
behavior. Also I've made some patch, but i'm not sure if the problem
is in sources? The problem doesn't appear when aggregate table is
recognized by the default rules.

query:

select

NON EMPTY {[Measures].[Customer Count]} ON COLUMNS,

NON EMPTY {[Time].[Year].Members} ON ROWS

from [Sales]

aggregate table: agg_c_10_sales_fact_1997


expected result:

Axis #0:

{}

Axis #1:

{[Measures].[Customer Count]}

Axis #2:

{[Time].[1997]}

Row #0: 5 581


actual result:

Axis #0:

{}

Axis #1:

{[Measures].[Customer Count]}

Axis #2:

{[Time].[1997]}

Row #0: 16 947
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ExplicitRecognizerTest.java
Type: application/octet-stream
Size: 3967 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20130107/b82c05fc/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mondrian_rolap_aggmatcher_Recognizer.java.patch
Type: application/octet-stream
Size: 268 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20130107/b82c05fc/attachment-0001.obj