--- David E Jones <[EMAIL PROTECTED]> wrote: > The main thing left that is needed is a tool to > transform the data > from the source tables to the target tables in the > data warehouse. > The entity engine and simple-methods together are > actually quite good > for this sort of data mapping and moving. > > So yes, I think we already have a pretty good set of > tools for this > and the next step would just be to get a proof of > concept done and > then starting applying it more widely. > > -David >
This weekend I had the opportunity to play with the OLAP portion of Pentaho, Mondrian, through another open source project openI (http://openi.sourceforge.net/). The creation of analysis reports is done with JSPs but they have it set up to create them programmatically through the web application. I have to say, it had some moments of really shining with the ofbiz data. With speed and features. It really pushes a lot of the query decision making down to the user and takes it off of the developer (where once it's decided what data is permissible to see is where it should be). I mention this because there's a critical size of data that must be met first before the overhead of the CUD on a denormalized data warehouse is beneficial and not a hindrance. Anyway, I think a lot of what openi does can be replicated even smoother in OFBiz pretty easily by someone who's familiar with JSPs (the implicit references most JSP projects use seem too arbitrary for me to follow). Setting up OpenI was a bit smoother for me than the Pentaho demo, so I wasn't able to evaluate Pentaho as a package. Hopefully next weekend will fair better. One side question. Are the view-entities supposed to be creating actual views in the database? Because they don't in mysql. I had only used ofbiz to manipulate views before so I never looked at it. But now creating some OLAP schemas I'm noticing they're not there.
