Community mailing list archives

community@mail.odoo.com

Re: Enterprise reporting

by
Carlos Liébana Anero
- 04/06/2015 05:53:06
Hello,

We have the same problems for some customers with high volume, and we finished creating custom excel reports. I think the approach of Odoo/OpenERP is very good and useful, but as you said it fails with that amount of data. In my opinion, the information retrieved should not be updated by default in real time (the reason why it's so slow) but should be saved in new custom models merging information from the model sources involved, updated in background with cron jobs. Something as this was tried in the BABI project but unfortunately was moved to Tryton [1]


2015-04-01 13:43 GMT+02:00 Markus Schneider <markus.schneider@initos.com>:
use pentaho

there are some modules arround

On 30.03.2015 22:03, OpenERP Master wrote:
> Hello,
> 
> I may embark on an epic journey to create a series of enterprise reports
> for a high transaction volume Odoo system. I am talking hundreds of
> thousands of products and hundreds of users.
> 
> I may engage in some kind of data warehousing project to normalize the
> data into a reporting database, I may use a replication system then
> report on the replicated database, im not really sure what my approach
> is going to be.
> 
> These reports are basic reports that everyone wants, like sales by
> product, balance sheet, top product sales, and many, many more.
> 
> The out of box functionality is a skeleton and just wont do. It is very
> slow and featureless.
> 
> I am looking for recommendations on what some integrators has done as I
> consider options.
> 
> 
> Thanks!
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> 

-- 
Dipl.-Comp.-Math. Markus Schneider
Softwareentwickler

initOS GmbH & Co. KG
An der Eisenbahn 1
21224 Rosengarten

Mobil:   +49 (0)172 2303699
Phone:   +49 (0)4105 5615613
Fax:     +49 (0)4105 5615610

Email:   markus.schneider@initos.com
Web:     http://www.initos.com

Geschäftsführung:
Dipl. Wirt.-Inf. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
Haftende Gesellschafterin: initOS Verwaltungs GmbH

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRA 201840
USt-IdNr: DE 275698169
Steuer-Nr: 15/205/21402

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
--------------------------

CARLOS LIÉBANA ANERO
Director | factorlibre.com
+34 635 86 67 92
@carlosliebana