[Mondrian] Unexpected behaviour while using a TopCount in a Named Set
pmgalves at gmail.com
Wed Jul 11 14:28:29 EDT 2012
does this also apply for native top count evaluation?
On Wed Jul 11 19:27:30 2012, Julian Hyde wrote:
> On Jul 11, 2012, at 10:35 AM, Pedro Salgueiro wrote:
>> We are 95% sure that the results from executing this query against the
>> Foodmart in the master branch of Mondrian produces wrong results:
>> SET [Top Count] AS
>> [Measures].[Unit Sales]
>> [Top Count] * [Measures].[Unit Sales] on 0
>> FROM [Sales]
>> WHERE [Time]..[Q1].:[Time]..[Q3].
> I agree. The query gives different results with and without the DISTINCT for me also.
> Can you please log a jira case. Mention TopCount and Range in the WHERE clause in the case summary.
> Mondrian mailing list
> Mondrian at pentaho.org
More information about the Mondrian