[Mondrian] Slicer axis ignored in query against a VirtualCube

Andy Grohe agrohe21 at gmail.com
Wed Nov 2 17:06:32 EDT 2016


That member is probably not valid for that virtual cube.  Try SELECT
Measures.members on columns, [Export Geography].members on rows from
[exports]

On Wed, Nov 2, 2016 at 3:04 PM, Manuel Aristarán <manuel at jazzido.com> wrote:

> On Nov 2, 2016, at 1:47 PM, Andy Grohe <agrohe21 at gmail.com> wrote:
> That is probably because it is an actual member
>
>
> I don’t think I understand. The slicer expression is valid (a member
> between brackets is a tuple). Besides, this query works as expected on a
> non-virtual cube:
>
> SELECT
>       NON EMPTY {
>         [Measures].[FOB US]
>       } ON 0,
>       NON EMPTY [Date].[Year].members ON 1
>     FROM [exports]
>     WHERE (
>             [Export Geography].[Magallanes]
>           )
>
>
>
> --
> Manuel Aristarán
> http://jazzido.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/20161102/6f32c461/attachment-0001.html 


More information about the Mondrian mailing list