[Libreoffice-ux-advise] Pivot Table data provider extension framework (removal possibility)

[Olivier Hallot]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Lionel

Em 14-03-2013 06:31, Lionel Elie Mamane escreveu:
> On Wed, Mar 13, 2013 at 09:48:32PM +0100, Eike Rathke wrote:
> 
>>> I believe the same functionality can be achieve via database
>>> connectivity, by having such external data provider register as a
>>> database, and use it to act as a data provider for pivot tables.
>>> So, I don't see a reason why we need to keep this as a separate data
>>> source category.
> 
>> IMHO the advantage of the data provider is that the actual data does not
>> have to reside in the spreadsheet, allowing for massive amounts of data
>> records but providing only the information necessary for the pivot
>> table. This maybe could be accomplished as well using a registered data
>> source, but currently we have no means to pull the data without actually
>> storing it in the spreadsheet for further processing. Or isn't that the
>> case?
> 
> Naively, I don't immediately see why when using database connectivity,
> you'd have to store the data in the spreadsheet?
> 

In enterprises environments, custom database queries in ERP systems
costs a fortune to get (e.g. Accenture man/hour price list) and are
almost never done timely. Managers use just 2 tools: Spreadsheets and
Presentations. The first to get data to report, the second, to make his
personal show for the boss and peers.

So managers use spreadsheets from whatever query they get from IT and
shuffles it for the show. That means almost always large CSV files
(often hideen behind a .xls extension).

Also, direct database connection is a privilege very few people have in
enterprises.

I hope it helps
- -- 
Olivier Hallot
Founder, Board of Directors Member - The Document Foundation
The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany
Fundação responsável civilmente, de acordo com o direito civil
Detalhes Legais: http://www.documentfoundation.org/imprint
LibreOffice translation leader for Brazilian Portuguese
+55-21-8822-8812
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQEcBAEBAgAGBQJRQZviAAoJEJp3R7nH3vLxUJ4H/382SRdziCpPcKjTTUF64fLJ
yJ2QlNYs5JTQsSh05ojCbZ/rfRMxw8VS75Ylrq2Ge4xDRdTtHbUwWJNEMs1jUsNo
0lhKdmASpC819uXusub+P4SToMdfkd/m+awA6vaqPrWGUpyzSQ1I4wdDgoK2F6Gb
N6pPnHxFMDiaTQgQRC6C5XItvuISZURJPUuDSSzRiziFp0PgqAtf2bxpH2YeMGzS
Ra8qPNG3Sc34a5C+tDwY3D5ilEbNg1P6Fhzimi2dqHtxNh6GcQX6k9L7SOffjrmd
7XxUuxxpdzzzfgPpmZBQ/FWj9qMKAFd1J0gzAkuyJo/TsLJKJj3HDcqZTvZdRe0=
=x82u
-----END PGP SIGNATURE-----