[Mondrian] Unexpected behaviour while using a TopCount in a Named Set

Pedro Salgueiro pedro.salgueiro at inductiva.pt
Wed Jul 11 13:35:06 EDT 2012


Ok,

We are 95% sure that the results from executing this query against the 
Foodmart in the master branch of Mondrian produces wrong results:

     WITH
     SET [Top Count] AS
     {
         TopCount(
             DISTINCT([Customers].[Name].Members),
             5,
             [Measures].[Unit Sales]
         )
     }

     SELECT
     [Top Count] * [Measures].[Unit Sales] on 0
     FROM [Sales]
     WHERE [Time].[1997].[Q1].[1]:[Time].[1997].[Q3].[8]

Thank you,
Pedro



On 07/11/2012 05:59 PM, Julian Hyde wrote:
> On Jul 11, 2012, at 4:32 AM, Pedro Salgueiro wrote:
>
>> First, thank you all for the help on this problem.
>>
>> Ok, some problems have been solved, but others came out.
> I'm slammed for time today. Can you narrow this down to a query that you are 90% sure is giving the wrong results?
>
> Julian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>




More information about the Mondrian mailing list