RE: Reporting tools

Sivalingam's response nicely sums it up!

Once you go down this road, you wind up in the data warehouse business.  You
may find this to be quite time consuming depending on the needs of your
company and the users will always want more or the same in different ways
once you break this seal.  Be forward thinking in your creation of your data
warehouse.         

We originally selected Crystal (Web published) a few years ago but are
planning to move to SQL 2005 BI in the future as we already utilize SQL
server in other applications and it is a free add on.  The success of ODBC
is very dependent upon the size of your database.  If you are a smaller
company for example and warehouse on the AS400, response may not be so bad
for single file.

Finally, if your intent is to provide users a BI Ad Hoc inquiry tool, you
will want to consider OLAP based functionality.              



-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Glen Boyle
Sent: Tuesday, July 19, 2005 6:30 PM
To: System 21 Users
Subject: [SYSTEM21] Reporting tools

Hello all,
 
I've been set the task of looking at new reporting tools for with-in our
business and I thought I would ask on the user group  to see what people
are using and how they have found them extracting the data from System
21 and building the relevant cubes....
 
I've got documentation from Business Objects and have Cognos coming to
see me in the next few weeks.....
 
Any thing any one would like to share , I would be very interested
 
 
 
 
Kind Regards
Glen Boyle      
Group IT Manager        
G.Costa & Co. Limited   
Tel: 01622 713318       
Fax: 01622 713331       
www.gcosta.co.uk <blocked::http://www.gcosta.co.uk/>    
gboyle@xxxxxxxxxxxx <blocked::mailto:gboyle@xxxxxxxxxxxx>       
This communication contains information which is confidential and may
also be privileged. It is for the exclusive use of the intended
recipient(s). If you are not the intended recipient(s) please note that
any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you
have received this communication in error please return it to the
sender.         
 
 




  


The views expressed in this email are the views of the individual and may
not reflect the views of the organisation. G Costa & Co Limited accepts no
liability for any losses or damages arising from reliance on the information
contained in this email.The information contained in this email is
confidential, may be legally privileged and is intended solely for use by
the individual or organisation to whom it is addressed.

Email information is subject to copyright and must not be used,
disseminated, copied or disclosed to third parties without the written
consent of G Costa & Co Limited.
If you are not the intended recipient you should delete this email, destroy
all copies and inform the Webmaster (webmaster@xxxxxxxxxxxx).

Copyright G Costa & Co Limited
All Rights Reserved

Registered Office: Weston Centre, 10 Grosvenor Street, London W1K 4QY

This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security service
working around the clock, around the globe.
Visit http://www.messagelabs.com
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.