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 ");
