<div dir="ltr"> For those of you who aren't java-averse you can setup a debug environment<br>with Eclipse (or whatever your favorite JDE is) -- though, with Eclipse when<br>you import <b>build.xml</b> there are a few things to do to get it working.<br>
<br> There are a number of exceptions that go largely ignored that, while<br>usually not a big deal, can help resolve obscure problems, not to mention<br>it's better than waiting for a bugfix if you either find an obscure problem<br>
without a good error message, or a legitimate bug.<br><br>-Brian<br><br><div class="gmail_quote">On Tue, Sep 23, 2008 at 5:32 PM, m h <span dir="ltr"><<a href="mailto:sesquile@gmail.com">sesquile@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Folks-<br>
<br>
I'm just thinking of the children (and hoping this get's indexed for<br>
future users). So, I'm at the point where I have something of a<br>
schema. It loads into the Workbench and validates (note, I'm weary<br>
about editing from the workbench, since it appeared to eat some of my<br>
xml). So I try a simple MDX query and get back no results! What to<br>
do?<br>
<br>
Turns out there is logging support. But for some reason java is not<br>
liking the DOS formatted version of ~/.schemaWorkbench/log4j.xml<br>
Since I'm running on Ubuntu, I ran dos2unix to fix that problem.<br>
(Also needed to edit the workbench.sh file because java wasn't liking<br>
the "~", so I put the full path to the log4j.xml file.<br>
<br>
Now, to actually get the sql query that Mondrian is issuing, change<br>
category@name=mondrian/priority@value from INFO to DEBUG in the<br>
log4j.xml file (pardon if my xpath isn't completely correct ;))<br>
<br>
After doing the above, the log file in<br>
~/.schemaWorkbench/workbench.log should spit out your query AFTER<br>
(wish it was before) it is run.<br>
<br>
Good luck children! ;)<br>
<br>
cheers,<br>
<br>
-matt<br>
<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>
</blockquote></div><br></div>