[Mondrian] Slicer axis: Difference between sets and aggregated members

[Pedro Alves]

Which one is the correct?



On Wed 29 Aug 2012 05:50:45 PM WEST, Julian Hyde wrote:
> Definitely a bug. It might be a duplicate -- but log it anyway.
>
> Julian
>
>
> On Aug 29, 2012, at 9:42 AM, Pedro Alves <pmgalves at gmail.com> wrote:
>
>>
>>
>> *confused*
>>
>> This query:
>>
>>
>> with set a as '([Time].[1997].[Q1] : [Time].[1997].[Q2])'
>> member Time.x as Aggregate(a,[Measures].[Store Sales])
>> member Measures.x1 as ([Time].[1997].[Q1],[Measures].[Store Sales])
>> member Measures.x2 as ([Time].[1997].[Q2],[Measures].[Store Sales])
>> set products as TopCount(Product.[Product
>> Name].Members,1,Measures.[Store Sales])
>> SELECT
>> NON EMPTY products ON 1,
>> NON EMPTY {[Measures].[Store Sales], Measures.x1, Measures.x2} ON 0
>> FROM [Sales]
>> -- where ([Time].[1997].[Q1] : [Time].[1997].[Q2])
>> where Time.x
>>
>>
>> Returns:
>>
>> Urban Small Eggs	
>> 497.42
>> 235.62
>> 261.80
>>
>>
>> While this:
>>
>>
>>
>> with set a as '([Time].[1997].[Q1] : [Time].[1997].[Q2])'
>> member Time.x as Aggregate(a,[Measures].[Store Sales])
>> member Measures.x1 as ([Time].[1997].[Q1],[Measures].[Store Sales])
>> member Measures.x2 as ([Time].[1997].[Q2],[Measures].[Store Sales])
>> set products as TopCount(Product.[Product
>> Name].Members,1,Measures.[Store Sales])
>> SELECT
>> NON EMPTY products ON 1,
>> NON EMPTY {[Measures].[Store Sales], Measures.x1, Measures.x2} ON 0
>> FROM [Sales]
>> where ([Time].[1997].[Q1] : [Time].[1997].[Q2])
>> -- where Time.x
>>
>>
>> returns:
>>
>> Urban Small Eggs
>> 497.42	
>> 497.42	
>> 497.42
>>
>>
>>
>> Is this expected?
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian