openerp-community team mailing list archive

[Fabien Pinckaers <fp@xxxxxxxxxxx>]

Ana,

Just do a PostgreSQL view and you have your multi-object cube. Just a few
minutes of devs.
Or, if I am not wrong, Vadim just said he developed a module allowing this.

Fabien


On Thu, Jan 23, 2014 at 8:52 PM, Ana Juaristi <ajuaristio@xxxxxxxxx> wrote:

> Hi Fabien:
>
> I have just done what you recomend and have been playing little bit with
> opportunities. I like it. I think it's much more powerfull than reports on
> previous versions and it has got capabilites to cover the needs of most of
> companies but ... a single doubt.
> Usually BI systems are used to compare data between different objects. For
> instance, comparing sales-purchases prices for products, projects. Rotating
> products or mixing manufacturing with projects or accountancy.
> Would it be possible defining cubes mixing different OpenRP objects?
> Defining common and agregate fields to build cubes or stars as usually is
> done on any BI system. If yes...  I think that any integration would not be
> necesary otherwise, it will still be necesary for several companies.
>
> Thank you:
> Ana
>
>
>
>
>
> 2014/1/23 Fabien Pinckaers <fp@xxxxxxxxxxx>
>
>> 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.corperic.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
>>>>
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> CEO Avanzosc, S.L <http://www.avanzosc.es> : Office phone / Tfono
> oficina: (+34) 943 02 69 02
> Ana Juaristi Olalde <http://www.anajuaristi.com/>: Personal phone: 677 93
> 42 59. User/usuario skype: Avanzosc
> www.openerpsite.com
>
>
> *El contenido de esta comunicación y de toda su documentación anexa es
> confidencial y se dirige exclusivamente a su destinatario. El uso no
> autorizado de esta información está prohibido por la legislación vigente.
> Si usted no es el destinatario le rogamos nos lo indique, no comunique su
> contenido a terceros y proceda a su destrucción. Disculpe las molestias que
> le haya ocasionado la recepción indebida de este e-mail. Sus datos figuran
> en un fichero cuyo titular es Avanzosc, S.L., a quien usted puede dirigirse
> para ejercer sus derechos de acceso, rectificación, cancelación y oposición
> en Julio Urkijo, 32, 20720, Azkoitia (Gipuzkoa), Tef. 943 02 69 02 -
> administracion@xxxxxxxxxxxx <soporte@xxxxxxxxxxxx> *
>
> *Komunikazio honen edukia eta dokumentazio erantsia konfidentziala da eta
> hartzaileak bakarrik jaso beharko luke. Indarrean dagoen legeriak debekatu
> egiten du bertan eskainitako informazioa baimenik gabe erabiltzea.
> Komunikazioa zuri iritsi bazaizu, baina zu ez bazara hartzailea, mesedez,
> guri jakinarazi, eta jasotako informazioa ez inori jakinarazi eta suntsitu.
> Barkatu okerreko email hau jasotzeak eragindako eragozpenak. Zure datuak
> Avanzosc, S.L. enpresaren fitxategietan sartuta daude. Zure datuak atzitzea
> eska dezakezu, bai eta, datuak zuzentzea, ezereztea eta tratamenduari aurka
> egitea ere. Horretarako, enpresara jo dezakezu, helbide honetan: Julio
> Urkijo, 32, 20720, Azkoitia (Gipuzkoa), telefonoa: 943 02 69 02 - **administracion@xxxxxxxxxxxx
> <soporte@xxxxxxxxxxxx> *
> *This message and all documents attached to it are confidential and
> intended only for the person or entity to which it is addressed. Any use of
> this information by unauthorised persons is prohibited under current
> legislation. If you received this message by error, please advise us,
> destroy it and refrain from communicating its contents to third parties. We
> apologise for any inconvenience receiving this email improperly may cause
> to you. Your personal data are included in a file owned by Avanzosc, S.L.
> If you want to exercise your rights of access, correction, erasure and
> objection you can contact the Controller at Julio Urkijo, 32, 20720,
> Azkoitia (Gipuzkoa), T: 943 02 69 02 – administracion@xxxxxxxxxxxx
> <soporte@xxxxxxxxxxxx>*
>