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

[Pedro Alves]

http://jira.pentaho.com/browse/MONDRIAN-1226


(I don't think it is)


Julian - am I correct in assuming the correct result is the one where 
the calculated member is used?




-pedro



On Wed 29 Aug 2012 06:02:01 PM WEST, Tiago Santos wrote:
> That could be related with this issue as well
> http://jira.pentaho.com/browse/MONDRIAN-1187
>
>
> 2012/8/29 Pedro Alves <pmgalves at gmail.com <mailto:pmgalves at gmail.com>>
>
>
>     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
>     <mailto: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 <mailto:Mondrian at pentaho.org>
>     >> http://lists.pentaho.org/mailman/listinfo/mondrian
>     >
>     > _______________________________________________
>     > Mondrian mailing list
>     > Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
>     > http://lists.pentaho.org/mailman/listinfo/mondrian
>     _______________________________________________
>     Mondrian mailing list
>     Mondrian at pentaho.org <mailto: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