SpagoBI provides extensive and integrated tools for BI/Reporting/Data
mining/Realtime BI/ Mobile BI/BAM all under Mozilla Public Licence.
The downside is that it's too big for simple reporting/dashboard needs
and a quite long learning curve.
http://www.spagoworld.org/xwiki/bin/view/SpagoBI/
HTH,
--Daoud.
On Fri, Jul 27, 2012 at 11:13 AM, Jacqui Caren
<jacqui.caren@ntlworld.com> wrote:
> On 26/07/2012 15:04, Vincent Veyron wrote:
>>
>> The money spent in licences alone would pay for scores of developpers to
>> produce any kind of reporting you will need many times over (the data
>> and its structure is what counts, reporting is easy if you have that)
>
>
> I disagree that licences will cover reporting costs...
>
> I come from the other end of the spectrum. We provide reporting systems
> for telco's banks etc. These are relatively stable, carefully designed
> reports going to either a small number of high profile clients or
> to a large number of end users.
>
> When we installed a system for a UK telco some years ago it ended up
> being the biggest outsourced print job in europe. It took up two
> exchange trunks for data and ran a months reports iin a few days.
>
> Initially the reporting hardware was three(ish) mid range sun desktops :-)
>
> We dont "do" generic reporting systems - our target audience are
> established complex and configurable reports that are run
> periodically and take up lots of manula or system resources.
>
> If the Op wants more detail I can pass provide $boss's email address
> but as I say it is more of a niche reporting product.
>
> Jacqui
>
> p.s. I am interested in this thread as I have a clinet who has a larg(ish)
> PG db and creates ad-hoc crosstab style reports. If I can find a tool he
> could
> use - he is a salesman and very non technical :-)
>
> At the mo I am building reporting tables and using thsi to populate
> crosstabs in openoffice using datapilot - crude but alot faster than
> the existing solution which involves manually calcing each cell in
> the crosstab :-/ openoffice replaces weeks of work with no more
> that an hours report design/config.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general