[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