Re: [U2] U2-Users Digest, Vol 59, Issue 1

Just a quiet "second" to Jeff's comment about using ODBC and pulling the data into Excel and then using Powerpivot.  PivotTables are a good way to quickly obtain meaning from large data sets.

... other than that, I know nothing.

------------------------------

Message: 2
Date: Fri, 28 Feb 2014 20:31:20 +0000
From: Jeff Lettau <[email protected]>
To: U2 Users List <[email protected]>
Subject: Re: [U2] Reporting Tools
Message-ID:
        <7935b2cd14a94badb63ba6e7e52cb9d0@BLUPR05MB198.namprd05.prod.outlook.com>

Content-Type: text/plain; charset="iso-8859-1"

Without knowing exactly what you are doing, why not take a look at ODBC and linking an excel sheet to your database and use the powerpivot to create your report?
If you are really doing a ETL you need a tool or a programmer.
I've pulled over 300k worth of records without an issue.  Although the record set was not 200 columns, but I'd bet you could get down to under 50 then do calculations in excel, then pivot the data to the report.

Please note that my email address has changed.  Beginning immediately my new address is [email protected] .  Use this new address for all communications.

Jeffrey Lettau  |   ERP Systems Manager  | O 410.358.3600  |   D 410.764.5242   |   5601 Metro Drive   |   Baltimore MD 21215   |   www.soundunited.com
Polk Audio - WWW.POLKAUDIO.COM
Definitive Technologies - WWW.DEFINITIVETECH.COM
BOOM Movement - WWW.BOOMMOVEMENT.COM
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users