[Mondrian] Bug in getNamedSet(List<Id.Segment> nameParts) ?

Matt Campbell mkambol at gmail.com
Wed Feb 18 12:56:44 EST 2009


I don't understand it, but the exact same behavior happens with both
Analysis Services 2000 and 2005--your first query returns no data.

On Wed, Feb 18, 2009 at 12:18 PM, Pedro Alves <pedro at neraka.no-ip.org>wrote:

>
>
>
> Hello everyone
>
>
>
> I'm having a problem with a query. This returns no results:
>
> with set a as '[Product].Children'
>  member [Product].[Filter] as 'Aggregate([a])'
> select {[Measures].[Unit Sales]} ON COLUMNS,
>  {[Promotion Media]} ON ROWS
> from [Sales]
> where [Product].[Filter]
>
>
> and this works as expected (only difference being [Product].[All
> Products]):
>
>
> with set a as '[Product].[All Products].Children'
>  member [Product].[Filter] as 'Aggregate([a])'
> select {[Measures].[Unit Sales]} ON COLUMNS,
>  {[Promotion Media]} ON ROWS
> from [Sales]
> where [Product].[Filter]
>
>
> If instead of .Children I use Descendants, It's the same behaviour
>
>
> I know [Product] is a RolapDimension, while [Product].[All Products] is a
> RolapMember;
>
> But I don't know why there should be a difference in this syntaxes, since
> the
> following queries work:
>
>
> with set a as '[Product].Children'
>  member [Product].[Filter] as 'Aggregate([a])'
> select {[Measures].[Unit Sales]} ON COLUMNS,
>  {[Product].[Filter]} ON ROWS
> from [Sales]
>
> with set a as '[Product].[All Products].Children'
>  member [Product].[Filter] as 'Aggregate([a])'
> select {[Measures].[Unit Sales]} ON COLUMNS,
>  {[Product].[Filter]} ON ROWS
> from [Sales]
>
>
> Is this a bug or a expected issue? I'm using this in CDF and I'l like to
> make some
> automatic exclusions, and got into this.
>
>
> Thanks
>
>
>
> --
> Pedro Alves
> pmgalves-at-gmail.com
>
> _______________________________________________
> 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/20090218/171ef18c/attachment.html 


More information about the Mondrian mailing list