Open Source Pivot table (OLAP cube?)
joncle at googlemail.com
Tue Apr 27 12:48:42 CEST 2010
On 27 Apr, 10:10, Laszlo Nagy <gand... at shopzeus.com> wrote:
> Hi All,
> I'm planning to create a new visual component for wxPython, for
> designing, creating and printing pivot tables. Also known as: decision
> cube, OLAP cube. I was searching on the internet for something similar,
> but I could not find any open source version (or free to use, at least).
> The only available free program was jmagallanes (http://jmagallanes.sourceforge.net/en/) but it is a stand alone
> application. I would like to create something that has Python bindings
> (more preferably, written in Python and is extensible).
> Before I start on this project, can you please confirm that there is no
> such thing available? I do not want to work on something that is already
Please note: this is not a direct answer to your question.
I would personally go for a client-server model; not worrying what the
server is written in or how it works. For some reason I have a scary
thought of your widget pulling in 100million records and cross-tabbing
two dimensions :) Don't worry about python bindings or such, why not
try and find something that can take an OLAP query, maintain
aggregates/computations on a DB that can possibly return in XML/JSON/
WHATEVER then just have your widget render visually the response and
send out XML/JSON/WHATEVER on click events.
Basically your widget is a renderer and UI to update the MDX/whatever
instructions in the OLAP server.
Of course, for small datasets, just nested dicts-of-dicts rendered
would probably do.
More information about the Python-list