Jacopo,
I like the idea of this approach, and it's something I've been thinking about for a while.
A good next step might be to do a PoC implementation with maybe just one star schema using a simple-method to do the ETL, and a form widget to report on the data. In that process we'll probably find some things that are ugly and could use some tool extensions.
BTW, there are some interesting generic star schemas in the Data Model Resource Book. There is a sales one with some requirements in the form of questions on page 370 of volume 1, and a model diagram on page 371.
The data warehouse entities should go into their own entity group, a new group, with it's own datasource in the OOTB entityengine.xml file. A good group name might be something like org.ofbiz.olap (as opposed to oltp which characterizes most of the current entities.
Anyway, yeah this would be cool, and we already have a lot of tools that would work really well here.
-David On Feb 16, 2007, at 12:15 AM, Jacopo Cappellato wrote:
Christopher, still nothing official or concrete, as far as I know. I know that Chris Howe did some integration tests with OpenI: http://docs.ofbiz.org/x/0AII am seriously considering a different approach; while I'm studying the book "The Datawarehouse Toolkit" (http://ofbiz.apache.org/ documents.html), I'm trying to draft out a proposal for the implementation of base datawarehousing features in OFBiz (a separate set of entities for dimensions, facts and start schemas; ETL services based on minilang, tools to manage the dimensions tables and synchronization).You'll find some of my notes here: http://docs.ofbiz.org/x/2QIMy goal is this: once we have a set of star schemas (facts and dimensions) derived from OFBiz entities and based on best practices, and the tools to manage the data in them, we could integrate a visual reporting tool to run reports against them (or just use, with some improvements the form widgets). It may seem an ambitious plan, but I think that many of the building blocks to complete it are already in the framework, we'll just have to improve and fine tune them. If you are interested in helping with this we could try to create a work group for this...Jacopo Christopher Snow wrote:Is there any work going on at the moment to build an ofbiz data warehouse and reporting infrastructure, for example the integration of the Pentaho toolset?Many thanks ... --This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
smime.p7s
Description: S/MIME cryptographic signature
