Community mailing list archives

Re: Enterprise reporting

FACTOR LIBRE SL, Carlos Liébana Anero
- 04/06/2015 05:53:06

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 <>:
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:

Dipl.-Comp.-Math. Markus Schneider

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


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

Post to:


Director |
+34 635 86 67 92