Hi Vince,
you are totally correct: these are separate/independent efforts.
BI effort:
1) creating a data model for dimensional analysis (datawarehouse) for OFBiz
2) low level services to facilitate the communication between the
transactional and dimensional database
3) services to keep the dimensional data synchronized
4) (as a lower priority) a simple reporting tool for dimensional analysis
BIRT effort (but Guo will probably be more precise on this, I've just
read his Jira issue):
a) integration of the BIRT reporting engine into OFBiz
I don't know much about BIRT, but if it can be used for dimensional
analysis, it would be interesting to use it to provide examples for
advanced reports (see point 4 above).
Jacopo
Vince M. Clark wrote:
Could someone clarify for the community what is the difference between this BI effort and the activity I see on Jira relatted to BIRT?
My sense is that BIRT is a reporting tool, and the new proof of concept for BI is about populating a data warehouse. Is this a correct assessment? Is there any relationship between the two initiatives or opportunities to build upon each other?
Vince Clark
Global Era
The Freedom of Open Source
[EMAIL PROTECTED]
(303) 493-6723
----- Original Message -----
From: "Jacques Le Roux" <[EMAIL PROTECTED]>
To: [email protected]
Sent: Saturday, October 20, 2007 8:06:47 AM (GMT-0700) America/Chihuahua
Subject: Re: Proof of concept for an Integrated OFBiz framework for business intelligence
Thanks Jacopo,
Sorry I saw that briefly but did not note it and forgot. It was the cause. Moreover my entityengine.xml file was in svn conflict (I
surely resolved by hand one day but forgot to resolve at the svn level)
Jacques
De : "Jacopo Cappellato" <[EMAIL PROTECTED]>
Hi Jacques,
the datawarehouse entities are stored in a separate database; have a
look at the settings for derby, I think that you have to replicate them
for Postgres... there are now two entity-groups:
org.ofbiz
org.ofbiz.olap
My first guess is that the second one is not associated to a valid
datasource.
if it doesn't work let me know, and I will help to fix.!
Jacopo
