[Mondrian] Bug with BottomCount

[Anton Nikitin]

Did anybody see such bug?

 

I'm checking simple query with Mondrian (2.4.2 against Foodmart):

 

Select    

{Product.DefaultMember} on columns,        

BottomCount([Time].levels(2).members,3) on rows  

FROM Sales where [Measures].[Store Sales]

 

Results are:

 


[Measures].[Store Sales] 

[Product].[All Products]


[Time].[1997].[Q1].[1]

45,539.69


[Time].[1997].[Q1].[2]

44,058.79


[Time].[1997].[Q1].[3]

50,029.87

 

It is incorrect. The same query in MSAS 2000 returns three empty cells.
Mondrian result is the same as if I used TopCount() function.

 

Also, the Mondrian result is changed if I pass [Measures].[Store Sales] as a
3rd parameter to BottomCount.

 

Anton

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080121/e23809e8/attachment.html