PDA

View Full Version : [Mondrian] XMLA Crossjoin issue



Matt Campbell
02-06-2007, 03:50 PM
I'm seeing a new error in Mondrian when running through XMLA. If I run a
query like the following:

SELECT CrossJoin({[Product].[All Products].children}, {[Customers].[All
Customers].children}) ON columns FROM Sales

Mondrian throws the following exception: mondrian.xmla.XmlaException:
Mondrian Error:XMLA Execute unparse results error

Queries without crossjoins work fine for me, and crossjoin queries run fine
outside of XMLA. Has anyone else seen this behavior?

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

Julian Hyde
02-06-2007, 04:40 PM
Reproduced, logged 1653587
<http://sourceforge.net/tracker/index.php?func=detail&aid=1653587&group_id=3
5302&atid=414613> Crossjoin gives "Execute unparse results" error in XMLA
and assigned to Richard.


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
Behalf Of Matt Campbell
Sent: Tuesday, February 06, 2007 11:48 AM
To: mondrian (AT) pentaho (DOT) org
Subject: [Mondrian] XMLA Crossjoin issue


I'm seeing a new error in Mondrian when running through XMLA. If I run a
query like the following:

SELECT CrossJoin({[Product].[All Products].children}, {[Customers].[All
Customers].children}) ON columns FROM Sales

Mondrian throws the following exception: mondrian.xmla.XmlaException:
Mondrian Error:XMLA Execute unparse results error

Queries without crossjoins work fine for me, and crossjoin queries run fine
outside of XMLA. Has anyone else seen this behavior?





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

Richard Emberson
02-06-2007, 04:50 PM
Does it work if you replaces "Sales" with "[Sales]"?

Richard

Julian Hyde wrote:
> Reproduced, logged 1653587 Crossjoin gives "Execute unparse results"
> error in XMLA
> <http://sourceforge.net/tracker/index.php?func=detail&aid=1653587&group_id=35302&atid=414613> and
> assigned to Richard.
>
> ------------------------------------------------------------------------
> *From:* mondrian-bounces (AT) pentaho (DOT) org
> [mailto:mondrian-bounces (AT) pentaho (DOT) org] *On Behalf Of *Matt Campbell
> *Sent:* Tuesday, February 06, 2007 11:48 AM
> *To:* mondrian (AT) pentaho (DOT) org
> *Subject:* [Mondrian] XMLA Crossjoin issue
>
> I'm seeing a new error in Mondrian when running through XMLA. If I
> run a query like the following:
>
> SELECT CrossJoin({[Product].[All Products].children},
> {[Customers].[All Customers].children}) ON columns FROM Sales
>
> Mondrian throws the following exception:
> mondrian.xmla.XmlaException: Mondrian Error:XMLA Execute unparse
> results error
>
> Queries without crossjoins work fine for me, and crossjoin queries
> run fine outside of XMLA. Has anyone else seen this behavior?
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mondrian mailing list
> Mondrian (AT) pentaho (DOT) org
> http://lists.pentaho.org/mailman/listinfo/mondrian


--
Quis custodiet ipsos custodes:
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian