Yes after Jacopo's presentation last year i ordered the book some time ago and found it again: The Data Warehouse Toolkit - Second Edition" by Ralph Kimball.
I have one of my people working on de orderfact entity to be able to make some birt reports in that area...We will extend the current BI pattern and follow the naming conventions already there..... Regards, Hans -- Antwebsystems.com: Quality OFBiz services for competitive rates On Fri, 2009-11-13 at 19:35 +1300, Scott Gray wrote: > Hi Hans, > > I would suggest getting hold of a good data warehousing book before > starting, making sure that the schemas are well designed will have a > huge impact on performance and usability going forward. That aside, > I'm a big +1 for fleshing out the schemas more and I'll try and find > some time myself to study up on the topic. > > I think Jacopo was using a book that he really liked when he was > working on BI but I'm not sure what the name of it was. > > Regards > Scott > > HotWax Media > http://www.hotwaxmedia.com > > On 13/11/2009, at 7:19 PM, Hans Bakker wrote: > > > for example we like to see which sales oriented data: which orders > > where made through promotions, > > which orders are back-ordered etc... > > > > should be start a org.ofbiz.bi.starschema.salesOrders next to > > org.ofbiz.bi.starschema.accounting? > > > > are there any rules to follow? > > > > The reason for all this: using birt to do sales reporting..... > > > > -- > > Antwebsystems.com: Quality OFBiz services for competitive rates > > > -- Antwebsystems.com: Quality OFBiz services for competitive rates
