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 <[email protected]> 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 <[email protected]> > >> 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 <[email protected]> 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 <[email protected]> wrote: >>> >>>> >>>> >>>> >>>> On Thu, Jan 23, 2014 at 12:20 PM, Fabien Pinckaers <[email protected]>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 <[email protected] >>>>> > 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 < >>>>>> [email protected]> 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: [email protected] >>>>>>> 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 >>>>>>> [email protected] >>>>>>> <mailto:[email protected]><[email protected]> >>>>>>> http://www.elico-corp.com >>>>>>> >>>>>>> Elico Corp >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Mailing list: https://launchpad.net/~openerp-community >>>>>>> Post to : [email protected] >>>>>>> Unsubscribe : https://launchpad.net/~openerp-community >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Mailing list: https://launchpad.net/~openerp-community >>>>>>> Post to : [email protected] >>>>>>> Unsubscribe : https://launchpad.net/~openerp-community >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Mailing list: https://launchpad.net/~openerp-community >>>>>>> Post to : [email protected] >>>>>>> Unsubscribe : https://launchpad.net/~openerp-community >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Mailing list: https://launchpad.net/~openerp-community >>>>>> Post to : [email protected] >>>>>> Unsubscribe : https://launchpad.net/~openerp-community >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~openerp-community >>>>> Post to : [email protected] >>>>> 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 : [email protected] >> 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 - > [email protected] <[email protected]> * > > *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 - > **[email protected] > <[email protected]> * > *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 – [email protected] > <[email protected]>* >
<<elico_signature.jpg>>
_______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
