openerp-community team mailing list archive

[Fabien Pinckaers <fp@xxxxxxxxxxx>]

>
>
> Very kind to comment on the topic, thanks.
>
> Could you please let us know how well trunk-new-graphview-ged scales?
>

No, unfortunately, we have no data as it's quite new.

An easy answer would be: it scales like postgresql scales. It uses the
read_group method (with a bit of improvements)

Just tested on our own instance, an analysis view that covers 400k records
is computed in 50ms. (with an index, 200ms when grouping on a non indexed
field)

Do you know if Pentaho or Spago is faster?

i.e. – we have account.move.line table with 3 mln records.
>

Based a very simple test on our leads, I would say less than 1 second for a
report that covers all records on a 3 millions records table.

Then, all operations (drill up-down, slice, switch views, pivot, ...) are
optimized to request only the changes to the server. So, manipulation of
the cube is quite fast.


> How does that behave. Will the user have to wait 10 minutes before seing
> that data/modify grouping/refilter or would it behave like a normal olap
> cube: results instantly available when you slice and dice?
>

No, it will be in seconds rather than minutes, unless you have billions of
records.

Would be great if someone can download the branch and benchmark. It should
not be very difficult to test.


Fabien


> *From:* Openerp-community [mailto:openerp-community-bounces+vadim=
> enapps.co.uk@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Fabien Pinckaers
> *Sent:* 23 January 2014 17:21
> *To:* Axel Mendoza Pupo
> *Cc:* openerp-community@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Openerp-community] OpenERP and Business Intelligence
>
>
>
> Hello,
>
>
>
> I suggest not to go for pentaho, spago, saiku, or others. You should check
> the branch of Antony, we developed nearly all features of current BI
> software and it's already fully working.
>
>
>
>
>
> I think the community should better concentrate to build apps in OpenERP
> rather than trying to integrate with third party tools. Integration are
> always painful, difficult to reuse from one project to another, ...
> Developing a BI cube is just a few weeks of work (3 months for one
> developer, less than 1000 lines of code). Today, OpenERP is so advanced
> that developing a new app on OpenERP is usually easier than trying to
> integrate with others applications. It's much more powerful and it's
> maintainable over a long period of time.
>
>
>
> We used to say internally that everything we develop that is not an
> OpenERP module will probably die in a few years. We did the mistake to
> integrate with SugarCRM, Alfresco, Ubercart, Webdav, CALDAV, Moodle. None
> of these modules are still useable today.
>
>
>
> With OpenERP, modules last if they are integrated, not if they are
> interfaced. Search on the web, you will find plenty of integration with
> Pentaho, SpagoBI, ... I bet that none of them are reusable on v7.
>
>
>
>
>
> That's why I think you should rely on the work done on this branch:
> trunk-new-graphview-ged (on http://runbot.openerp.com)
>
>
>
> To test, go to any record (e.g. opportunities) and switch to the graph
> view. Then, play with the cubes.
>
>
>
>
>
> The future is going to be integrated, not interfaced...
>
>
>
> Thanks,
>
>
>
> Fabien
>
>
>
>
>
> On Thu, Jan 23, 2014 at 12:22 PM, Axel Mendoza Pupo <aekroft@xxxxxxxxx>
> wrote:
>
> You could take a look at http://cubes.databrewery.org/ itś a python based
> solution, it seems to be a good tool, lightweight, powerful and will be not
> very difficult to get integrated into OpenERP
>
>
>
> Light-weight Python framework and OLAP HTTP server for easy development of
> reporting applications and aggregate browsing of multi-dimensionally
> modeled data.
>
>
>
> Hope this helps
>
>
>
> On Thu, Jan 23, 2014 at 6:00 AM, Eric Caudal <eric.caudal@xxxxxxxxxxxxxx>
> wrote:
>
> Thanks everybody for the feedback!
> BTW: the branch in runbot is not responsive. I will test it locally though.
>
> Eric Caudal
>
> *CEO*
>
> --
>
> *Elico Corporation, Shanghai branch*
>
> *OpenERP Premium Certified Training Partner*
>
>
>
> Cell: + 86 186 2136 1670
>
> Office: + 86 21 6211 8017/27/37
>
> Skype: elico.corp
>
> eric.caudal@xxxxxxxxxxxxxx
>
> http://www.elico-corp.com
>
>
>
> [image: Elico Corp]
>
> On 01/23/2014 06:44 PM, Antony Lesuisse wrote:
>
> You may also check the branch trunk-new-graphview-ged it's available on
> runbot http://runbot.openerp.com/
>
> It's a new graph view with BI capabilities. It will be merged in trunk in
> a few days.
>
> https://code.launchpad.net/~openerp-dev/openerp-web/trunk-new-graphview-ged
>
> On 01/23/2014 07:24 AM, Eric Caudal wrote:
>
> Hi,
> What are currently the technical solutions available for OpenERP to be
> able to
> generate cubes for Business Intelligence?
>
> I need to prepare a panel of solutions for one of my customers and would
> like
> to know:
> - Tools and vendors involved
> - Difficulty to integrate withh OpenERP7 current data model
> - Price range if relevant.
>
> NB:
> I am not really looking for static reporting tools but more for dynamic
> data
> builders (equivalent to Cognos or Crystal Report).
> It doesnot need to be opensource and Google is not an option as google.doc
> is
> not available in China.
>
> Looking forward to reading you
> --
> Eric CAUDAL
>
> Eric Caudal
> /CEO/
> --
> *Elico Corporation, Shanghai branch
> /OpenERP Premium Certified Training Partner/  *
> Cell: + 86 186 2136 1670
> Office: + 86 21 6211 8017/27/37
> Skype: elico.corp
> eric.caudal@xxxxxxxxxxxxxx  <mailto:eric.caudal@xxxxxxxxxxxxxx><eric.caudal@xxxxxxxxxxxxxx>
> http://www.elico-corp.com
>
> Elico Corp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>
>