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 >>> >>> >>> > > -- Chris Snow - CEng MBCS CITP MBA (Tech Mgmt) (Open) CISSP Tel: 01453 890660 Mob: 07944 880950 Www: www.snowconsulting.co.uk
