mondrian

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
13 messages Options
Reply | Threaded
Open this post in threaded view
|

mondrian

Chris Snow-3
Is it likely that the neogia mondrian addon will get added to ofbiz?

Many thanks in advance,

Chris

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Erwan de FERRIERES-3


Le 15/12/2009 08:00, Christopher Snow a écrit :
> Is it likely that the neogia mondrian addon will get added to ofbiz?
>
> Many thanks in advance,
>
> Chris
Hi Chris,

Maybe one time, but we have to check licences, and share the work with
the communauty.
For the momment, what you can do is to install this addon on you local
OFBiz instace !

Cheers,

>
>

--
Erwan de FERRIERES
www.nereide.biz
Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Chris Snow-3
Hi Erwan,

How do you install the addons?  Do I just drop them into hot-deploy?

Many thanks,

Chris

Erwan de FERRIERES wrote:

>
>
> Le 15/12/2009 08:00, Christopher Snow a écrit :
>> Is it likely that the neogia mondrian addon will get added to ofbiz?
>>
>> Many thanks in advance,
>>
>> Chris
> Hi Chris,
>
> Maybe one time, but we have to check licences, and share the work with
> the communauty.
> For the momment, what you can do is to install this addon on you local
> OFBiz instace !
>
> Cheers,
>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Erwan de FERRIERES-3


Le 15/12/2009 08:50, Christopher Snow a écrit :

> Hi Erwan,
>
> How do you install the addons?  Do I just drop them into hot-deploy?
>
> Many thanks,
>
> Chris
>
> Erwan de FERRIERES wrote:
>>
>>
>> Le 15/12/2009 08:00, Christopher Snow a écrit :
>>> Is it likely that the neogia mondrian addon will get added to ofbiz?
>>>
>>> Many thanks in advance,
>>>
>>> Chris
>> Hi Chris,
>>
>> Maybe one time, but we have to check licences, and share the work with
>> the communauty.
>> For the momment, what you can do is to install this addon on you local
>> OFBiz instace !

It would be too easy... You have to download and extract this file in
your hot-deploy component :
  http://addons.neogia.org/addonmanager-2.11.tar

Then, you start your OFBiz instance, and a new secondary app has
appeared, which is called addons. You go in it, and in the first page,
you expand the first screenlet, and you type the name of the addon, for
mondrian it is mondrian-3.1
It will automatically download the add-on and install it in your OFBiz.

You may look after at the help file  in helpdata, which will give you
more information on what you have to do.

HTH

>>
>> Cheers,
>>
>>>
>>>
>>
>
>

--
Erwan de FERRIERES
www.nereide.biz
Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Scott Gray-2
In reply to this post by Chris Snow-3
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
>


smime.p7s (4K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Milind P
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 <[hidden email]>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
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Chris Snow-3
In reply to this post by Scott Gray-2
My understanding is that the tools provide two different roles.

BIRT is for reporting
Mondrian if for (OLAP) analysis

However, I've just see that BIRT has functionality for working with
CUBES so the differences may be narrowing...



Scott Gray 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

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Chris Snow-3
In reply to this post by Milind P
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 <[hidden email]>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

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

hans_bakker
Hi Chris,

we are currently extending the OLAP entities and use these for Birt to
report on.

recently we added ordersales, today we will add the Inventory Item Facts
and Star schema and later the product and statistics will follow.....

Regards,
Hans


On Tue, 2009-12-15 at 08:54 +0000, Christopher Snow wrote:

> 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 <[hidden email]>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
> >>>
> >>>
> >>>      
> >
> >  
>
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Jacopo Cappellato-4
Hans, this is a really great news! Thank you.

Jacopo

On Dec 15, 2009, at 10:41 AM, Hans Bakker wrote:

> Hi Chris,
>
> we are currently extending the OLAP entities and use these for Birt to
> report on.
>
> recently we added ordersales, today we will add the Inventory Item Facts
> and Star schema and later the product and statistics will follow.....
>
> Regards,
> Hans
>
>
> On Tue, 2009-12-15 at 08:54 +0000, Christopher Snow wrote:
>> 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 <[hidden email]>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
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

Chris Snow-3
In reply to this post by hans_bakker
Hi Hans,

Congratulations on getting Birt into trunk!

Does Birt now contain most of the functionality found in mondrian?

Many thanks,

Chris

Hans Bakker wrote:

> Hi Chris,
>
> we are currently extending the OLAP entities and use these for Birt to
> report on.
>
> recently we added ordersales, today we will add the Inventory Item Facts
> and Star schema and later the product and statistics will follow.....
>
> Regards,
> Hans
>
>
> On Tue, 2009-12-15 at 08:54 +0000, Christopher Snow wrote:
>  
>> 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 <[hidden email]>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

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

hans_bakker
Hi Chris...
i do not know what mondrian is....

so i cannot really judge that.

Regards,
hans

On Tue, 2009-12-15 at 14:04 +0000, Christopher Snow wrote:

> Hi Hans,
>
> Congratulations on getting Birt into trunk!
>
> Does Birt now contain most of the functionality found in mondrian?
>
> Many thanks,
>
> Chris
>
> Hans Bakker wrote:
> > Hi Chris,
> >
> > we are currently extending the OLAP entities and use these for Birt to
> > report on.
> >
> > recently we added ordersales, today we will add the Inventory Item Facts
> > and Star schema and later the product and statistics will follow.....
> >
> > Regards,
> > Hans
> >
> >
> > On Tue, 2009-12-15 at 08:54 +0000, Christopher Snow wrote:
> >  
> >> 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 <[hidden email]>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
> >>>>>
> >>>>>
> >>>>>      
> >>>>>          
> >>>  
> >>>      
> >>    
>
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: mondrian

James McGill-5
On Tue, Dec 15, 2009 at 7:14 AM, Hans Bakker
<[hidden email]>wrote:

> Hi Chris...
> i do not know what mondrian is....
>
> so i cannot really judge that.
>
> Regards,
> hans


Mondrian is a tool for getting datasets into the form needed by Pentaho.
This is Business Intelligence software that is used heavily by analysts who
do forecasting and deal with business metrics.  To get into this stuff
requires a bit of immersion into the language and the concepts used by
business analysts, but it's pretty interesting if you need to do complex,
arbitrary reporting on a large volume of data.

A good place to start as an OFBiz user is with the Opentaps distribution,
which has some Pentaho integration already.   Pentaho itself is an enormous
project that has a very active community.  There's enough material here:
http://www.pentaho.com/   to keep you busy for months.

I hope the Pentaho/OFBiz integration improves, because I see great potential
for the ETL and reporting layers to fill a very important niche that is left
open by OFBiz so far.