Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: [Mondrian] mondrian populating same members on ROWS and COLUMNS

  1. #1
    Paul Stoellberger Guest

    Default [Mondrian] mondrian populating same members on ROWS and COLUMNS

    I would have filed a JIRA but I can't even describe what is happening, so I just post it on this ML.

    We have discovered a very weird behaviour in mondrian when we execute the following MDX statement on foodmart:
    SELECT
    NON EMPTY CrossJoin([Education Level].[Education Level].Members, CrossJoin([Product].[Product Family].Members, [Store].[Store State].Members)) ON COLUMNS,
    NON EMPTY CrossJoin([Promotions].[Promotion Name].Members, [Marital Status].[Marital Status].Members) ON ROWS
    FROM [Warehouse and Sales]

    When i execute this i get a result that looks like this: http://i.imgur.com/eK1KH.jpg (this is executed in saiku but i have reproduced the same issue with PDI (using a 3-3-SNAPSHOT and olap4j-0.9.9-SNAPSHOT)
    It seems like mondrian is populating the same members on both axes

    When I add a Measure to the ROWS axis, it works correctly, however if I add it to COLUMNS it adds the measure to the columns but shows the same faulty resultset as in the first query result

    I've never come along a similar error and this is the only combination i found so far that produces this behaviour.

    -Paul
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Luc Boudreau Guest

    Default Re: [Mondrian] mondrian populating same members on ROWS and COLUMNS

    Paul,

    I've tested your query on barebones Mondrian code. It is indeed a bug. Both
    axis have the same members. Please file a Jira for it and join your query to
    it.

    Thanks for spotting this

    Luc


    On Mon, Mar 7, 2011 at 2:12 PM, Paul Stoellberger
    <p.stoellberger (AT) gmail (DOT) com>wrote:

    > SELECT
    > NON EMPTY CrossJoin([Education Level].[Education Level].Members,
    > CrossJoin([Product].[Product Family].Members, [Store].[Store
    > State].Members)) ON COLUMNS,
    > NON EMPTY CrossJoin([Promotions].[Promotion Name].Members, [Marital
    > Status].[Marital Status].Members) ON ROWS
    > FROM [Warehouse and Sales]
    >


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Julian Hyde Guest

    Default RE: [Mondrian] mondrian populating same members on ROWS and COLUMNS

    I've just fixed it. <http://jira.pentaho.com/browse/MONDRIAN-902>
    http://jira.pentaho.com/browse/MONDRIAN-902.


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Luc Boudreau
    Sent: Monday, March 07, 2011 11:26 AM
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] mondrian populating same members on ROWS and COLUMNS


    Paul,

    I've tested your query on barebones Mondrian code. It is indeed a bug. Both
    axis have the same members. Please file a Jira for it and join your query to
    it.

    Thanks for spotting this

    Luc



    On Mon, Mar 7, 2011 at 2:12 PM, Paul Stoellberger <p.stoellberger (AT) gmail (DOT) com>
    wrote:


    SELECT
    NON EMPTY CrossJoin([Education Level].[Education Level].Members,
    CrossJoin([Product].[Product Family].Members, [Store].[Store
    State].Members)) ON COLUMNS,
    NON EMPTY CrossJoin([Promotions].[Promotion Name].Members, [Marital
    Status].[Marital Status].Members) ON ROWS
    FROM [Warehouse and Sales]



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  4. #4
    Paul Stoellberger Guest

    Default Re: [Mondrian] mondrian populating same members on ROWS and COLUMNS

    Thanks for the quick fix!! :-)

    -Paul

    On Mar 8, 2011, at 1:10 , Julian Hyde wrote:

    > I've just fixed it. http://jira.pentaho.com/browse/MONDRIAN-902.
    >
    > From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Luc Boudreau
    > Sent: Monday, March 07, 2011 11:26 AM
    > To: Mondrian developer mailing list
    > Subject: Re: [Mondrian] mondrian populating same members on ROWS and COLUMNS
    >
    > Paul,
    >
    > I've tested your query on barebones Mondrian code. It is indeed a bug. Both axis have the same members. Please file a Jira for it and join your query to it.
    >
    > Thanks for spotting this
    >
    > Luc
    >
    >
    > On Mon, Mar 7, 2011 at 2:12 PM, Paul Stoellberger <p.stoellberger (AT) gmail (DOT) com> wrote:
    > SELECT
    > NON EMPTY CrossJoin([Education Level].[Education Level].Members, CrossJoin([Product].[Product Family].Members, [Store].[Store State].Members)) ON COLUMNS,
    > NON EMPTY CrossJoin([Promotions].[Promotion Name].Members, [Marital Status].[Marital Status].Members) ON ROWS
    > FROM [Warehouse and Sales]
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.