Hi, Chris Thank you for useful comments & inspiring ideas. We plan to build server in the nearest time where it will be possible to see how it works. Certainly we (or our followers) will also work on bugs you have noticed (and hopefully will notice further). So we will post here when the server is ready.
Thanks Kirill Kuznetsov cjhowe wrote: > > In addition, requires updating web.xml and > controller.xml to utilize the current > org.ofbiz.webapp.control.LoginEventListener > instead of the securityext stuff. > > After getting the webapp loaded successfully, I was > not able to successfully run a query despite having > the foodmart database installed on a mysql server and > changing the settings to correspond to it. The java > methods used need to implement try/catch statements to > narrow down the problem, otherwise you just get > generic service failure messages. > > Oleg, > > There are quite a few unlicensed source files in your > repository, are you releasing these under the apache > license as well or are these source files in > collaboration with another project (The debug > statements make reference to mondrian.properties > whereas the file in your distribution is > dwh-mondrian.properties suggesting that at least part > of the java source files - ie QueryTag.java - are > derivative of files from another project - most likely > mondrian and AFAIK thereby not able to be released > under an Apache license) > > I would very much like to help make this something > that can eventually be worked in to Apache Ofbiz, but > need to fully understand the licensing limitations so > that I know if a solution needs to actually become a > part of Apache Ofbiz or simply run inside it as a > supplemental work. > > Last week I wrote up a simple guide on how to get > openI to run inside ofbiz (at least to use embedded > tomcat), but would very much prefer your solution as > it moves down the milestone path to already utilize > controller.xml, the screen widgets the login tools, > etc. I look forward to working on this. > > > --- Chris Howe <[EMAIL PROTECTED]> wrote: > >> Couple small details about the build.xml file. For >> those who want to try it out... >> >> Line 40 correct with your deployment's location of >> ofbizhome >> >> Line 47-49 /base should now be /framework/base >> >> >> >> --- "Oleg Kozyrev Jr." <[EMAIL PROTECTED]> wrote: >> >> > >> > 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. >> > >> > >> >> > > > -- View this message in context: http://www.nabble.com/Datawarehouse-implementation-tf2749621.html#a7734323 Sent from the OFBiz - Dev mailing list archive at Nabble.com.
