Hi Chris, we are currently extending the OLAP entities and use these for Birt to report on.
recently we added ordersales, today we will add the Inventory Item Facts and Star schema and later the product and statistics will follow..... Regards, Hans On Tue, 2009-12-15 at 08:54 +0000, Christopher Snow wrote: > Hi Milind, > > I agree with you about not mixing OLAP/OLTP. However, it looks like the > marts are already built in Ofbiz (e.g. Sales Invoice Fact) and I was > thinking that mondrian may be good for exposing the ofbiz data mart > tables. Smaller users of ofbiz (such as my last client) would wanted > the analysis tools in the ofbiz UI. > > Also, using multiple data sources, the OLTP and OLAP data can be stored > in different backend databases that are optimized for their environment. > > Cheers, > > Chris > > Milind Parikh wrote: > > IMO, OLAP tools should not be used on transactional systems. Mondrian does > > provide some amazing capabilities; but these rely on data marts (facts and > > dimensional tables being built). Invariablely such data marts must be built > > and maintained seperate to the transactional systems (and with the attendant > > ETL runs) > > > > Regards > > -- Milind > > > > > > > > On Tue, Dec 15, 2009 at 12:29 AM, Scott Gray > > <[email protected]>wrote: > > > > > >> Unless it provides something amazing compared to what birt is offering I'm > >> guessing not. > >> > >> Regards > >> Scott > >> > >> HotWax Media > >> http://www.hotwaxmedia.com > >> > >> > >> On 15/12/2009, at 8:00 PM, Christopher Snow wrote: > >> > >> Is it likely that the neogia mondrian addon will get added to ofbiz? > >> > >>> Many thanks in advance, > >>> > >>> Chris > >>> > >>> > >>> > > > > > > -- Antwebsystems.com: Quality OFBiz services for competitive rates
