Jacopo, We were using Octopus (http://forge.objectweb.org/projects/octopus/). It's made under LGPL. So, it can be used in the same way as Shark.
Also we have used Mondrian (http://sourceforge.net/projects/mondrian/). It's made under CPL and as far as I understand it's ok. OLAP part is using JFreeChart and it is aldo LGPL. Also we are using only css files from JPivot and, certainly, we can easily make our own and have nothing in common with JPivot. OLAP is fully made on OFBiz Widgets. Well, I hope, that licence stuff is ok. Oleg. Jacopo Cappellato wrote: > > Oleg, > > this is interesting and I'll have a look at it, thanks. > About including the new component into OFBiz, the first (but not the > only one) thing we should consider is the license issue: we can only > include in our svn tree jar files, xsd schemas and code compatible with > the licenses listed here: > > http://docs.ofbiz.org/display/OFBADMIN/Libraries+Included+in+OFBiz > > Jacopo > > PS: the direct link to Oleg's project in Sourceforge.net is: > > http://sourceforge.net/projects/datawarehouse/ > > > 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#a7671884 Sent from the OFBiz - Dev mailing list archive at Nabble.com.
