Hi everybody -
We have been experimenting with openi, olap, and mondrian with ofbiz
ourselves, thanks to Chris's documentation, and have had some
success. We're now able to generate some cubes for ofbiz.
Do you want to take a look at what we've done? Do you have some code
samples that you're willing to post/share somewhere online, so we can
coordinate?
Longer term, I do agree with David -- it might not be ideal for OFBiz
per se to have so much reliance on LGPL libraries.
On Dec 4, 2006, at 8:45 AM, David E Jones wrote:
Oleg,
It's great to see that you guys have made progress on this.
Reporting, data warehousing and data analysis have been problems
with OFBiz for a while.
Depending on licensing it may be a good goal to get this into the
main OFBiz code base, but if it is working okay as a separate
project then it can be an add-on for people to use on top of OFBiz
without worrying so much about licensing issues (ie you can
continue to include LGPL licensed libraries, etc). I should make it
clear that I'm just thinking out loud about this and while it would
be cool to have this stuff in OFBiz itself, it certainly isn't
required in order to be of use to OFBiz users, and hopefully to
allow some community/interesting building around it.
The one concern I would have as a separate project or even using
LGPL libraries is having a large library of OFBiz application
specific ETL artifacts, and reports based on the warehouse
database. If that is the direction this is going it would be a lot
easier to maintain those along with the applications and data model
and such of OFBiz. If the goal for now is just to produce a tool
set along with examples, it's not such a big deal.
-David
On Dec 3, 2006, at 11:38 PM, Oleg Kozyrev Jr. wrote:
Hello, all
My partner Kirill Kuznetsov and I were working last year on the
integration
of Data Warehouse module. Finally we reached following results:
1. ETL processes described in XML, executed in Ofbiz and realized via
Octopus, which transform and transfer data from some JDBC source
to Ofbiz
SQL database.
2. OLAP tool which makes it possible to process MDX queries & OLAP
Operations (sorting, filters, drilldowns, and so on) in Ofbiz
interface.
3. Ofbiz Interfaces including some nice diagrams (implemented as
applets
using JFreeChart).
In addition we have some working examples (data models + star
schemas, e.g.
Healthcare data model)
Certainly it's not a ready result, and this year new students of our
university will probably continue our efforts making it more
functional &
easy to use (it's planned to finish old functionalities, add new
math tools
like regressions, etc.)
Still it would be great if you took a look at out project (it is
downloadable at sourceforge.net), or if it is interesting we could
make
online access (demos to our working version). The most interesting
question
for us is if it can be after some modifications be included into
Ofbiz
Source Code.
There was also an issue in the old Jira (jira.ofbiz.org) called
"Ofbiz
Datawarehouse component" (617 as far as i remember).
Best Regards,
Kirill Kuzntetsov & Oleg Kozyrev
--
View this message in context: http://www.nabble.com/Datawarehouse-
implementation-tf2749621.html#a7671426
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
Best Regards,
Si
[EMAIL PROTECTED]
