Frankly speaking, now we were using FoodMart, because it contains much more data when the OFBiz from SVN. And that's why it's better for testing.
But, we have ETL based on Octopus and we have managed to build another model from OFBiz database. Unfortunatelly, it is using SQL terms, but not OFBiz Entities. As I alredy said next year new students are going to work on this. They will probably extend ETL functionality to work more with OFBiz Entities. It's better for modelling to my mind. Still the project is in pretty early stage, but we hope that it will under extensive development in future. cjhowe wrote: > > Hello Oleg, > > I was just doing a quick browse of your project ( > http://sourceforge.net/projects/datawarehouse/ ) and > noticed that you still had the FoodMart cube. Have > you created a cube based on OFBiz yet or were you just > testing the request/response capabilities? Thanks! > > > --- "Oleg Kozyrev Jr." <[EMAIL PROTECTED]> 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. >> >> > > > -- View this message in context: http://www.nabble.com/Datawarehouse-implementation-tf2749621.html#a7671789 Sent from the OFBiz - Dev mailing list archive at Nabble.com.
