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.
