Re: Cash Forecasting with JBA data -- SYSTEM21

I heard very recently that Cognos had put something together for AR / AP
reporting in JBA. Exactly what I don't yet know, be it reports, data
models,
data cubes or what ever. I've used this product in the past to produce
various
reports over finance, order entry and inventory, and found it to be very
powerful. But then I've also hit those reports which which end up being
just too
complicated to produce through a reporting tool even so powerful.
One such set of reports were summarized AR Debtor reports - Aged Debt,
Ageing of Current Debt, and Overdue Debt. I ended up producing them as
cross tab reports with a PC database tool, as I had to include a
preliminary data extract (through a Pascal program) to get the data I
wanted into the required format. The JBA database is very strong, and
can produce very complicated data models, making some reports incredibly
difficult to produce within the rigid confines of a straight forward
reporting tool. I'd be interested to know of other peoples experience on
this....
Regards,
Ian Owen


gbardsley@jbana.com wrote:

> Dear All,
>
>   I would agree with Doug that @ctive Reporter could be used for AR or AP
> reporting
>   and I am sure some of our TM1 customers are doing this already.
>
>   My Eureka Reporter(Previously IQ Objects) could also be used and again I
> am sure
>   there are customers using this or other Business Intelligence
> products(and not just JBA) for AP/AR.
>
> I am very interested to find out if customers that have @ctive Reporter are
> doing things outside the G/L
> scope. Also how people are working with My Eureka for reporting out of
> System 21.
>
> Regards
>
> Guy Bardsley
>
> Geac Product Marketing Manager for BI and CRM
>
> gbardsley@jbana.com
>   .
>
> Doug333@aol.com on 05/05/2000 04:41:31 PM
>
> Please respond to JBAUSERS-L@midrange.com
>
>
>
>  To:      JBAUSERS-L@midrange.com
>
>  cc:
>
>
>
>  Subject: Re: Cash Forecasting with JBA data
>
>
> I've heard this question before, but never heard of someone doing the
> project.  Spreadsheets and Active Reporter come to mind.
> Doug
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---