Thanks Pierre for taking it up. It looks promising. Are you also planning to document the overall high-level design at some point of time. If yes I would suggest to cut a separate JIRA and share it as and when you feel it's in good shape. It would be easy to refer/review/refine and appreciate it in its entirety rather than going through each of the tix separately to get the complete understanding.
Thanks & Regards, Swapnil > -----Original Message----- > From: Pierre Smits <[email protected]> > Sent: Saturday, April 27, 2019 4:53 PM > To: [email protected] > Subject: [DISCUSSION] bi/birt component integration > > Hi All, > Currently the various business intelligence (BI) functionalities are > scattered in > various components (consider all the overviews regarding inventory > positions, orders/deliveries per customer/supplier) in the applications > folder. > > And on the other hand we have the BI component and the Birt component in > the plugins repo. Both of those components have minimal functionality > regarding the business intelligence aspect. But both components are > complimentary: > > 1. the bi (short for: Business Intelligence) component initialised the > OFBiz DWH and has secas and services for copying data from the ofbiz > database to the ofbizolap database, and > 2. the birt (short for Business Intelligence Report Tool) component is > intended to deliver on functionalities to display data overviews in > various forms (tables, charts, in PDFs, UI widgets, etc)... > > Unfortunately, both components lack of love from our community. But a bit > more love would significantly enhances the appeal of OFBiz for (potential) > adopters! > > As a result from a customer project, I recently have been working a bit > more > on the business intelligence aspect (see recent tickets in [1] and [2]). > > I believe it would be in the best interest of the project to integrate the > functionalities in the Birt component into the BI component. It will send > a > clear message to both (potential) adopters and OFBiz developers (both our > contributors, and those not participating here but working on > implementations of adopters), being: > > *everything related with business intelligence happens in and comes from > the bi component*. > > > What do you think? > > When we have this, the community can start working on enhancing the > single component to increase its (and inherently OFBiz) appeal: > > > 1. more entitiy definitions for dimension and fact tables (per [3], > from > the OFBiz related books), > 2. more scheduled services that move data from various ofbiz tables > into > ofbizolap tables, > 3. more UI widgets for displaying data aggregations (tables, charts) in > the form of portal pages widgets. These portal page widgets can then be > integrated by our adopters dynamically anywhere in the components of > the > applications folder, e.g through starting/main pages. > > [1] > https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AN > D%20component%20%3D%20bi%20AND%20status%20not%20in%20(Closed) > [2] > https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AN > D%20component%20%3D%20birt%20AND%20status%20not%20in%20(Close > d) > [3] https://www.amazon.com/gp/product/0471200247 > > Best regards, > > Pierre Smits > > *Apache Trafodion <https://trafodion.apache.org>, Vice President* > *Apache Directory <https://directory.apache.org>, PMC Member* Apache > Incubator <https://incubator.apache.org>, committer *Apache OFBiz > <https://ofbiz.apache.org>, contributor (without privileges) since 2008* > Apache Steve <https://steve.apache.org>, committer
