|
Dan, I appreciate the needs of "Business Intelligence" workers. Before I switched careers to software development, ad-hoc reporting was a big part of my job. It's interesting that you moved your data warehouse off the AS/400 and onto an Intel Server. I wonder whether your company simply considered using OS/400 Query, rather than migrate to SQL Server for business intelligence? Thanks, Nathan. www.relational-data.com ----- Original Message ----- From: "Dan Neal" <dneal@btcgrp.com> To: <midrange-l@midrange.com> Sent: Tuesday, September 18, 2001 11:10 AM Subject: RE: Creating Reports? > We still use RPG, but have moved some reporting to Crystal Reports for > reports on the AS/400 and our SQL Servers. We have several users who have > been trained in crystal reports and are now in a place to write their own > reports. We do a nightly load of key data to the SQL server for their > reporting use during the day. This has taken a lot of the reporting load > from the AS/400 to the SQL server. We keep the tables on SQL to a minimum > and renamed the field names to more meaningful names. This was the > low-budget data warehouse, but has paid off big time with satisfied > customers and time for the IT group to focus on valued added projects. > > Dan
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.