Re: End-user reporting tool
Date: Tue, 12 Feb 2002 07:05:19 GMT
Message-ID: <3c68bc81.366466_at_dtext.news.tele.dk>
On Mon, 11 Feb 2002 22:31:26 GMT, damorgan <dan.morgan_at_ci.seattle.wa.us> wrote:
>Perhaps you could explain to us exactly what you think you are going to
>do in Excel, other than fudge and fabricate data, that you can't do in
>Oracle better.
Perhaps it is better to explain my procedures today. For business reporting and analysis purposes I am making several extracts from Oracle into csv-files. As my current reporting tool only allows me to make an extract from one database at a time, I am making a lot of queries eg. an extract from our order database, an extract from our stocktable and one from our debtor tabel. Then I combine these files in a spreadsheet, eg. looking up the item name in the stocktable from the itemnumber in the ordertable and so on. Very timeconsuming, and very little up-to-date.
The data should preferably be integrated directly into the spreadsheet from the Oracle database. This would normally be in a database style with columns and a number of rows, upon which I perform Pivot table operations or other database functions.
Hope this explains my objective!
Mogens Received on Tue Feb 12 2002 - 08:05:19 CET