RE: OLAP Reporting Packages with MAPICS -- MAPICS-L

Ed,

This was the reason for my suggestion of using Query/400. I made the
assumption that you already have a licence for Query/400 and people who
know how to use it. I also took into consideration the urgency of your
project. Query is by far not the best ad hoc reporting tool available, but
it seems like a good fit to at least get started.


Good Luck,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Heller, Ed"
                    <eheller@defianceprec        To:     mapics-l@midrange.com
                    ision.com>                   cc:
                    Sent by:                     Subject:     RE: OLAP 
Reporting Packages with MAPICS
                    mapics-l-admin@midran
                    ge.com


                    10/17/01 03:19 PM
                    Please respond to
                    mapics-l






Well . . . my biggest problem with Crystal Reports is (physical) distance.
Using Crystal alone means that the select/filter is not performed until the
data is brought onto the user's PC. Thus, if that user only needed to look
at 500 inventory transaction records, she would still need to download all
500,000 records to get the ones she wanted. Running through a 384K line
from
the AS/400 100 miles away, she could essentially go to lunch waiting just
to
get the data local. Plus, since that same line handles e-mail, Internet,
data collection, etc., my phone would be ringing off the hook from people
wondering where our bandwidth went to.

Agreed, Crystal is a nice tool, and perhaps I should take a look at
Crystal's back-end solution (sit an NT box for it next to the 400). We'll
have to see.

Thanks!

Ed

> -----Original Message-----
> From: De Vlieger Kris [mailto:devlieger.kris@village.uunet.be]
> Sent: Wednesday, October 17, 2001 2:46 PM
> To: mapics-l@midrange.com
> Subject: Re: OLAP Reporting Packages with MAPICS
>
>
> Choosing a package is allways hard, but I think you should
> remember none
> lasts forever and everything may change in the wink of an eye
> in software
> (alas).  Cr. Reports is good and easy to use, and you have it
> already.  It
> may be low end, but still it can do much more than 'pretty
> up' Query/400 in
> my opinion.  Vanguards tools are another class entirely.  If
> both ends are
> still an option, I think you should reconsider whether you
> know the target
> well enough?  Both are excellent solutions, to similar but different
> problems.
> Have you tried finding out what
>     CR can't do (you know, you have the enterprise version?)
>     you need (you should know)
>     Vanguard has from the above (you can find out )
> ?
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.