<div dir="ltr"><div>Hello,<br><br></div>Fact tables can not specify. "at mondrian.rolap.SqlConstraintUtils.joinLevelTableToFactTable(SqlConstraintUtils.java:684)
"<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/6/12 Martijn van den Broek <span dir="ltr"><<a href="mailto:martijn@basesoft.com" target="_blank">martijn@basesoft.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hi Merel, <br>
<br>
Thanks for the suggestion, but the same error is triggered. <br><div><div class="h5">
<br>
<br>
On 12/06/13 11:26, Meral Ozkaya wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>Hello,<br>
<br>
</div>
Please try mdx query this "select NON EMPTY <span style="background-color:rgb(255,255,0)">(</span>Crossjoin([Promotions].Members,
[Gender].Members)<span style="background-color:rgb(255,255,0)">)</span>
ON COLUMNS
<br>
from [VirtualSalesTest]
" . I write "NON EMPTY ( CrossJoin(...) )" with parenthesis.<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/6/12 Martijn van den Broek <span dir="ltr"><<a href="mailto:martijn@basesoft.com" target="_blank">martijn@basesoft.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> Hello Mondrian
developers,<br>
<br>
Last week we encountered a bug in mondrian and I made this
JIRA: <a href="http://jira.pentaho.com/browse/MONDRIAN-1608" target="_blank">http://jira.pentaho.com/browse/MONDRIAN-1608</a><br>
<br>
We are working on an application which makes usage of
virtual cubes and are stuck with this exception. I'm
writing you because we would like to fix this issue and I
hope you have some hints how to do so. <br>
<br>
I looked into the code a while but its not clear why the
level does not have the starKeyColumn set. From what I see
the schema is read properly. So if you have time to look
into this it would be much appreciated. <br>
<br>
Thank you,<br>
<br>
<br>
<br>
<pre cols="72">--
Kind regards,
Martijn van den Broek
BaseSoft Solutions B.V.
Herengracht 564
1017 CH Amsterdam
The Netherlands
<a href="http://www.basesoftsolutions.com/" target="_blank">http://www.basesoftsolutions.com/</a>
<a href="tel:%2B31%280%29206847087" value="+31206847087" target="_blank">+31(0)206847087</a>
Confidentiality notice
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
</pre>
</div>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Meral Özkaya
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Mondrian mailing list
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a>
</pre>
</blockquote>
<br>
<br>
<pre cols="72">--
Kind regards,
Martijn van den Broek
BaseSoft Solutions B.V.
Herengracht 564
1017 CH Amsterdam
The Netherlands
<a href="http://www.basesoftsolutions.com/" target="_blank">http://www.basesoftsolutions.com/</a>
<a href="tel:%2B31%280%29206847087" value="+31206847087" target="_blank">+31(0)206847087</a>
Confidentiality notice
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
</pre>
</div></div></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Meral Özkaya
</div>