Posted by
cjhowe on
URL: http://ofbiz.116.s1.nabble.com/Business-Intellegence-tp173965p173968.html
--- David E Jones <
[hidden email]>
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.