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

[Tiago Santos]

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>

>
> 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
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20120829/0486a2f2/attachment.html