openerp-community team mailing list archive

["Enapps :: Vadim Chobanu" <vadim@xxxxxxxxxxxx>]

I tested it – very good indeed, step into the right direction – good job!
Now add a funnel graph for those opportunities – they will look business.



On another note, speaking about large and heavy sql views, Enapps will be
releasing something next week to address it. Hopefully it will work with
both – v6 and v7.

Regards,



Vadim









*From:* Openerp-community [mailto:openerp-community-bounces+vadim=
enapps.co.uk@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Fabien Pinckaers
*Sent:* 23 January 2014 18:37
*To:* Ovnicraft
*Cc:* openerp-community@xxxxxxxxxxxxxxxxxxx
*Subject:* Re: [Openerp-community] OpenERP and Business Intelligence



In addition, here are the remaining tasks that are the minimum before it's
useable:

  - the "extended search" will be expanded on top of the view to easily
slice

  - export data to excel



Then we will continue on extra features like better dashboards, ...



On Thu, Jan 23, 2014 at 7:27 PM, Fabien Pinckaers <fp@xxxxxxxxxxx> wrote:

Ovnicraft,



Please test it. Check and judge by yourself if you don't agree. Our
solution has PROs and CONs and it's very difficult to have an interesting
conversation if you don't know what you are talking about and you don't
have seen it before. We will waste time arguing "it's not feasible", "it's
probably not as good", "but saiku do it that way", "Not Inveted Here is
never a good approach..." if you don't judge by yourself.



It's quite easy to test on runbot, here is the steps to test:

  - Go to runbot: http://runbot.openerp.com

  - Search the branch  "trunk-new-graphview-ged"

  - Click on the arrow on the right of connect and select "All Addons"

  - Go to Sales > Opportunities

  - Switch to graph view

  - Play with the data (the 'cube' view is the first icon)



Once you will have tested it, I can answer all questions and we can discuss
PROs and CONs. Before, we all waste our time.



- -

Fabien



On Thu, Jan 23, 2014 at 7:10 PM, Ovnicraft <ovnicraft@xxxxxxxxx> wrote:





On Thu, Jan 23, 2014 at 12:20 PM, Fabien Pinckaers <fp@xxxxxxxxxxx> wrote:

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.



Hi @Fabien: BI capabilities are a little bit hard to write, a Q: that 1000
LOC has something like agregation, browsing, OLAP, ROLAP, logical analysis,
phisical analysis, hirarchical deps, slice ? just to mention few features.
You can check http://cubes.databrewery.org/



IDK if DRY is lost here, but integration is part of make apps and systems
work together, via WS and OERP has a good stuff here.

NIH Rule is a bad option.



Have a good graphs dont means has BI capabilities, if i am wrong please
describe features.



I consider OERP could be strong in WS maker new APIs, new methods, formats,
etc and help us to write more apps w/o reinvent the wheel.



Regards,



,



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




_______________________________________________
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





-- 
Cristian Salamea
@ovnicraft