We have investigated different options in the past, such as ShowCase, etc.
and could not justify the cost based on the number of users that would
actively use the product.  We then went and wrote a course on AS/400 Query
and had the "power user" from each of about 5 departments attend the class.
They went through workshop-like exercises, etc.  We had issues with
authority and access to certain files and could not justify the expense of
coming up with an authorization scheme that was configurable by user, etc.
Perhaps, we just don't know enough about AS/400 authority to make it work.
In the end, we have one person in the Accounting department that writes some
of her own queries (she was already cleared to see any and all company data,
so security and authorization was not an issue).  We do download data
extracts for a couple of users and have setup other downloads to be run by
the user without our intervention or help. Typically, we write the queries
and put them on the user menu for them to run.  If the record selection gets
too weird for the user to handle, we write an RPG program. The one user that
is writing her own queries is pretty good at it and requires a minimum level
of support, but I have to say that she's the exception.  HTH.
Ed Chabot
The Marlin Firearms Co.

-----Original Message-----
From: []On
Behalf Of Bonnie Cameron
Sent: Wednesday, February 27, 2002 8:47 AM
Subject: Reporting

Our company currently uses ShowCase Query for accessing Mapics data (where
the Mapics inquiries and reports are inadequate.)  Although we offer
in-house training on the software, we constantly find ourselves supporting
much of our user base as often a user needs information who has not taken
the class (or took the class some time ago and doesn't recall how to use the
software.)  In addition, we spend a fair amount of time supporting logic
questions and problems.

I am wondering what tools some of the companies represented in this forum
use and how you handle reporting in you totally leave it up to
users to create their own inquiries or does IS actively support this effort,

Thanks in advance for your responses,

Bonnie Cameron
Polaris Industries
Roseau, MN
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email:
To subscribe, unsubscribe, or change list options,
or email:
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.