[Mondrian] Debugging schemas

[Brian Vandenberg]

  For those of you who aren't java-averse you can setup a debug environment
with Eclipse (or whatever your favorite JDE is) -- though, with Eclipse when
you import *build.xml* there are a few things to do to get it working.

  There are a number of exceptions that go largely ignored that, while
usually not a big deal, can help resolve obscure problems, not to mention
it's better than waiting for a bugfix if you either find an obscure problem
without a good error message, or a legitimate bug.

-Brian

On Tue, Sep 23, 2008 at 5:32 PM, m h <sesquile at gmail.com> wrote:

> Folks-
>
> I'm just thinking of the children (and hoping this get's indexed for
> future users).  So, I'm at the point where I have something of a
> schema.  It loads into the Workbench and validates (note, I'm weary
> about editing from the workbench, since it appeared to eat some of my
> xml).  So I try a simple MDX query and get back no results!  What to
> do?
>
> Turns out there is logging support.  But for some reason java is not
> liking the DOS formatted version of ~/.schemaWorkbench/log4j.xml
> Since I'm running on Ubuntu, I ran dos2unix to fix that problem.
> (Also needed to edit the workbench.sh file because java wasn't liking
> the "~", so I put the full path to the log4j.xml file.
>
> Now, to actually get the sql query that Mondrian is issuing, change
> category at name=mondrian/priority at value from INFO to DEBUG in the
> log4j.xml file (pardon if my xpath isn't completely correct ;))
>
> After doing the above, the log file in
> ~/.schemaWorkbench/workbench.log should spit out your query AFTER
> (wish it was before) it is run.
>
> Good luck children! ;)
>
> cheers,
>
> -matt
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080923/b0901039/attachment.html