Julian<br><br>You are right. I had nullParentValue="Unknown".<br>I guess this is a bug in the schema workbench since I never put that parameter there (I was not aware of it).<br><br>Now excel's refresh action is working when connecting to mondrian 3.2.13343 but with 3.2.0.13583 excel still gives me "the
query did not run, or the database table could not be opened." error
when I refresh.<br><br>Manuel<br><br><div class="gmail_quote">On Fri, May 21, 2010 at 1:49 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div><span><font size="2" color="#000080" face="Lucida Sans">The error</font></span></div>
<div><span><font size="2" color="#000080" face="Lucida Sans"></font></span> </div>
<div><span> parentExp != null || nullParentValue
== null<br></span></div>
<div><span><font size="2" color="#000080" face="Lucida Sans">means that in your schema, you have specified nullParentValue
on a Level where you have not specified parentExp. You can only specify
nullParentValue in a parent-child level.</font></span></div>
<div><span><font size="2" color="#000080" face="Lucida Sans"></font></span> </div>
<div><span><font size="2" color="#000080" face="Lucida Sans">Julian</font></span></div>
</div></blockquote></div><br>