Proof of concept for an Integrated OFBiz framework for business intelligence

[Jacopo Cappellato]

Hi all,

in rev. 584727 I've committed my work on a proof of concept for an
Integrated OFBiz framework for business intelligence.
This is essentially a new specialpurpose component (but it will probably
disappear as soon as all its parts will be integrated in the main OFBiz
applications) with a simple web application.
For more details, visit the new tab "Business Intelligence" and read the
component introduction in the main page (there are also instructions on
how to start.... everything is very simple).
And of course, let me know your opinions/questions/comments etc...

*IMPORTANT*: the datawarehouse report will drill up/down correctly only
if the patch attached to this mail is applied; I will commit it (or an
equivalent variant) soon but I have to wait for feedback on this in the
dev list before... by the way I'll let you know as soon as it is in.

Jacopo



Index: framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java
===================================================================
--- framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java (revision 584577)
+++ framework/entity/src/org/ofbiz/entity/datasource/GenericDAO.java (working copy)
@@ -711,7 +711,7 @@
         // GROUP BY clause for view-entity
         if (modelEntity instanceof ModelViewEntity) {
             ModelViewEntity modelViewEntity = (ModelViewEntity) modelEntity;
-            String groupByString = modelViewEntity.colNameString(modelViewEntity.getGroupBysCopy(), ", ", "", false);
+            String groupByString = modelViewEntity.colNameString(modelViewEntity.getGroupBysCopy(selectFields), ", ", "", false);
 
             if (UtilValidate.isNotEmpty(groupByString)) {
                 sqlBuffer.append(" GROUP BY ");

[Derrick Kittler]

Jacopo-
The BI component is an excellent start to overall BI suite. Are you
thinking that OFBiz can be used as a standalone BI platform something
like Pentaho? Or are you thinking the BI will only support OFBiz-centric
apps. It would be excellent if there was another all-star open source BI
suite in the works.

Again, I think it is great work.
-Derrick


On Mon, 2007-10-15 at 13:05 +0200, Jacopo Cappellato wrote:

> new specialpurpose component (but it will probably
> disappear as soon as all its parts will be integrated in the main
> OFBiz
> applications) with a simple web application.
> For more details, visit the new tab "Business Intelligence" and read
> the
> component introduction in the main page (there are also instructions
> on
> how to start.... everything is very simple).
> And of course, let me know your opinions/questions/comments etc...
>
> *IMPORTANT*: the datawarehouse report will drill up/down correctly
> only
> if the patch attached to this mail is applied; I will commit it (or
> an
> equivalent variant) soon but I have to wait for feedback on this in
> the
> dev list before... by the way I'll let you know as soon as it is in.
>
> Jacopo

[Jacopo Cappellato]

Hi Derrick,

Derrick Kittler wrote:
> Jacopo-
> The BI component is an excellent start to overall BI suite. Are you
> thinking that OFBiz can be used as a standalone BI platform something
> like Pentaho? Or are you thinking the BI will only support OFBiz-centric
> apps.

The main goal right now is to create a clean, well documented (by meta
data) data model for datawarehouse based on best practices and together
with the services (business rules) and ecas (triggers) to keep its data
updated and synchronized with the transactional data model (i.e. the
data model of OFBiz). For this, it will just be something strictly
related with the OFBiz applications.
Of course, it would be possible to extract the data model for the
datawarehouse and use it outside of OFBiz.

> It would be excellent if there was another all-star open source BI
> suite in the works.
>
> Again, I think it is great work.

Thanks, you are too kind

Jacopo

> -Derrick
>
>
> On Mon, 2007-10-15 at 13:05 +0200, Jacopo Cappellato wrote:
>> new specialpurpose component (but it will probably
>> disappear as soon as all its parts will be integrated in the main
>> OFBiz
>> applications) with a simple web application.
>> For more details, visit the new tab "Business Intelligence" and read
>> the
>> component introduction in the main page (there are also instructions
>> on
>> how to start.... everything is very simple).
>> And of course, let me know your opinions/questions/comments etc...
>>
>> *IMPORTANT*: the datawarehouse report will drill up/down correctly
>> only
>> if the patch attached to this mail is applied; I will commit it (or
>> an
>> equivalent variant) soon but I have to wait for feedback on this in
>> the
>> dev list before... by the way I'll let you know as soon as it is in.
>>
>> Jacopo

[Jacopo Cappellato]

Ok,

the patch to the framework is not officially in the svn trunk (rev.
585051); so now you can just update your ofbiz instance and play with
the new component.

Jacopo


Jacopo Cappellato wrote:

> Hi all,
>
> in rev. 584727 I've committed my work on a proof of concept for an
> Integrated OFBiz framework for business intelligence.
> This is essentially a new specialpurpose component (but it will probably
> disappear as soon as all its parts will be integrated in the main OFBiz
> applications) with a simple web application.
> For more details, visit the new tab "Business Intelligence" and read the
> component introduction in the main page (there are also instructions on
> how to start.... everything is very simple).
> And of course, let me know your opinions/questions/comments etc...
>
> *IMPORTANT*: the datawarehouse report will drill up/down correctly only
> if the patch attached to this mail is applied; I will commit it (or an
> equivalent variant) soon but I have to wait for feedback on this in the
> dev list before... by the way I'll let you know as soon as it is in.
>
> Jacopo
>
>