Re: Ad Hoc Queries on JBA System/21

Hi Marc,

 Do you use  the native System/21 reports?
Yes, we use Financial Reports such as Open A/R and Open A/P Invoices,
etc.



Do you use just AS/400 query and download extracts to Excel?
We use AS/400 queries for simple reports and displays.
I create queries and add to a user's menu or on JBA Explorer so they can
call any time.
I also have many on nightly scheduler to print daily or weekly reports.
I rarely transfer to excel and on;ly I would do so, not users.


If you use Corvu, have you upgraded to Aurora?
NO.


Do you use System/21 Performance Analyzer?
NO.


Do you use some other product?  Which one?
We use COGNOS but are moving away from it to product called Intellijade.
Intellijade is SQL product, which requires no ODBC setup.  All queries
reside on AS/400.
I have many Jade reports & emails that are setup on my Windows Task
Scheduler that mostly emails reports around the world and done
overnight.


Are you doing any kind of EIS or executive dashboard software?  Which
one?
I think Intellijade can do, but I have not had the time to research.

Thanks 


Barbara Byrne
 
IT Manager
Greatex Mills Inc.

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mark Faulhaber
Sent: Friday, May 19, 2006 11:01 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Ad Hoc Queries on JBA System/21

 I'm the Director of IT for Griffin Industries in Northern Ky.  

We are JBA/GEAC/Infor (whatever) System/21 users.

We're looking at AD Hoc Query and reporting software to replace the
Corvu that JBA sold us when we originally went on System/21.

It would be a big help to me if you would let me know how you're dealing
with this.

Thanks in advance for your consideration of my request.

Do you use  the native System/21 reports?


Do you use just AS/400 query and download extracts to Excel?


If you use Corvu, have you upgraded to Aurora?


Do you use System/21 Performance Analyzer?


Do you use some other product?  Which one?


Are you doing any kind of EIS or executive dashboard software?  Which
one?


To get things rolling, here's my answers:

Do you use  the native System/21 reports?
 A: Yes, we do, but we've had to modify them extensively.

Do you use just AS/400 query and download extracts to Excel?
  A: We use some query, but for downloads to Excel we use a product
called mrc


If you use Corvu, have you upgraded to Aurora?
  A: We use Corvu now.  We're unhappy with the support we're getting. 
And we've 
       received contradictory information about whether it'll work with
Aurora.  
       (Hence the need for this mailing.)


Do you use System/21 Performance Analyzer?
  A: No, it's one that we're looking at as a Corvu replacement


Do you use some other product?  Which one?

  A: We use mrc-Productivity series.  An application generator that does
a good job for 
       us in the hands of a programmer.  But we've had little luck
getting the Accountants to
       embrace it.


Are you doing any kind of EIS or executive dashboard software?  Which
one?

   A: We have some EIS type screens that are written in mrc.  The
Executives use them, 
        but we'd like to do a lot more and the Infor sales rep is saying
that a lot of what we
       want is already in the basic templates they deliver with
System/21 Performance Analyzer.


Thanks again.

Mark Faulhaber
Director I/S
Griffin Industries
859-572-2507

The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work product
doctrine and thus protected from disclosure.  If the reader of this
message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited.
If you have received this communication in error, please delete this
message immediately.  


_______________________________________________
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.