Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

hebi: a small smili-BI python module

173 views
Skip to first unread message

Nicolas Évrard

unread,
Jun 7, 2013, 10:36:05 AM6/7/13
to tryton-...@googlegroups.com
Hello,

We have created a small python module that acts a bit like a BI
application.

With this module you can from a starting table containing the
consolidated data from your application you can create some kind of a
drill-down hierarchy of tables.

For example let's say you have a table that look like this:

YEAR MONTH CATEGORY AMOUNT
2012 2 A 100
2012 3 B 200
2012 4 AA 300
2013 3 B 200
2013 4 B 400
2013 5 AA 100

This module will be able to generate a table considating those data by
year, year/month, year/month/category. With the additional feature
that the categories can refer to tree structure (and this information
will also be taken into account).

You can find the review here:

http://codereview.appspot.com/9943044/

--
Nicolas Évrard

B2CK SPRL
rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
E-mail/Jabber: nicolas...@b2ck.com
Website: http://www.b2ck.com/
signature.asc

Raimon Esteve

unread,
Jun 7, 2013, 10:46:58 AM6/7/13
to tryton-...@googlegroups.com
> We have created a small python module that acts a bit like a BI
> application.

Great!

In README is available a demo how to do.

Are you working in GTK client to integre it?

--
Si us plau, NO adjunti arxius a les seves respostes. Li preguem que
integri el text al cos del missatge. Pot respondre usant NetEtiquete
que li ajudarà a seguir la conversa.
http://es.wikipedia.org/wiki/Netiquette

Por favor, NO adjunte archivos a sus respuestas. Le rogamos que
integre el texto en el cuerpo del mensaje. Puede responder usando
NetEtiquete que le ayudará a seguir la
conversación.http://es.wikipedia.org/wiki/Netiquette

Please, DO NOT send attachment files with your answers, just copy and
paste only the text you need to send into the body of your mails.
Repply using NetEtiquete. http://en.wikipedia.org/wiki/Netiquette

Raimon Esteve
// Tryton - OpenERP - Django
// Doc OpenERP: http://openerp.zikzakmedia.com
// Doc Tryton: http://tryton.zikzakmedia.com
www.zikzakmedia.com

Albert Cervera i Areny

unread,
Jun 7, 2013, 10:51:53 AM6/7/13
to tryton-...@googlegroups.com
2013/6/7 Nicolas Évrard <nicolas...@b2ck.com>
Hello,

We have created a small python module that acts a bit like a BI
application.

With this module you can from a starting table containing the
consolidated data from your application you can create some kind of a
drill-down hierarchy of tables.

For example let's say you have a table that look like this:

    YEAR    MONTH   CATEGORY    AMOUNT
    2012    2       A           100
    2012    3       B           200
    2012    4       AA          300
    2013    3       B           200
    2013    4       B           400
    2013    5       AA          100

This module will be able to generate a table considating those data by
year, year/month, year/month/category. With the additional feature
that the categories can refer to tree structure (and this information
will also be taken into account).

Cool. We were talking about migrating our BABI module to Tryton only a couple of hours ago at today's TUC. The module we did for OpenERP allows users to do the data filtering + materialization, as well as the aggregates and visualization (tree + charts). We've been discussing ways of improving it with filter parameters and more features, so we could probably use what you did as an engine. We'll take a look at it!

 

You can find the review here:

    http://codereview.appspot.com/9943044/

--
Nicolas Évrard

B2CK SPRL
rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
E-mail/Jabber: nicolas...@b2ck.com
Website: http://www.b2ck.com/



--
Albert Cervera i Areny
Consultor funcional
Tel. 93 553 18 03
@albertnan

Cédric Krier

unread,
Jun 7, 2013, 11:25:06 AM6/7/13
to tryton-...@googlegroups.com
On 07/06/13 16:46 +0200, Raimon Esteve wrote:
> > We have created a small python module that acts a bit like a BI
> > application.
>
> Great!
>
> In README is available a demo how to do.
>
> Are you working in GTK client to integre it?

No because it will just require to define the Models.

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric...@b2ck.com
Website: http://www.b2ck.com/

Cédric Krier

unread,
Jun 7, 2013, 11:28:45 AM6/7/13
to tryton-...@googlegroups.com
Be warned that we choice to just build a tool for devs because we think
that end users don't have the knowledge to provide accurate and
efficient queries to build a "cube".

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Reply all
Reply to author
Forward
0 new messages