Adam - great topic. Thanks for raising it. I would like to suggest that you look at how Mondrian defines cubes. Not sure how we could incorporate that into the Entity Engine but two of the major open source BI products, Jasper and Pentaho, use Mondrian. So it would be nice if we could give users the option of using whatever is built in to OFBiz, and also use existing solutions.
Vince Clark vcl...@globalera.com (303) 493-6723 ----- Original Message ----- From: "Adam Heath" <doo...@brainfood.com> To: dev@ofbiz.apache.org Sent: Wednesday, July 29, 2009 10:14:02 AM GMT -07:00 US/Canada Mountain Subject: data/olap cubes Has anyone had any dealings with using data/olap cubes with ofbiz? I've recently had some thoughts on how to maintain such data structures automatically. This is somewhat of a brainstorm, but this is what I'm thinking. Define the cube with a dynamic view entity(possibly using my sql representation). Have this dve serialized to a DataCubeDescriptor table. Then, during ofbiz startup, it would read from DataCubeDescriptor, auto-create any missing summary tables, then add dynamic reverse ecas, so that any time the underlying data is modified, the summary table would be auto-updated with new data. This would allow data cube querying to be instantaneous, because it would just be dumping the summary table's contents. Does anyone else understand what I am describing? Is anyone else interested?