Thank you Jacopo, we will work in that direction... Regards, hans
On Fri, 2009-11-13 at 08:43 +0100, Jacopo Cappellato wrote: > Hans, > > first of all: it is great that you are interested on enhancing the star > schemas and dimensions; also using Birt on top of them will be a great way of > using them. > I would really suggest the following book: > > http://www.amazon.com/gp/product/0471200247 > > If you can get it (or a digital copy of it) you will appreciate the way it is > written; I can also help to point you to the most important sections to speed > up. > BTW, regarding sales orders: > > 1) I would suggest to implement the new star schema (and supporting > eca/services) for sales orders in the "order" component > (org.ofbiz.bi.starschema.order) > 2) the start schema could be based on the schema described in the book at > page 116; > 2.1) its name could be SalesOrderItemFact and its field could be: orderId*, > orderItemSeqId*, dateDimensionId, productDimentionId, currencyDimensionId, > orderQuantity, grossOrderTotalAmount, orderDiscountDollarAmount, > netOrderDollarAmount > > Let me know if I can help more, I would be happy to. > > Jacopo > > On Nov 13, 2009, at 7:19 AM, 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
