RE: Business Objects with DB2 data

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

SEQUEL allows one to define its own "templates" to provide the users with
access to only the data they need. The scripting tool allows the developer
to design for maximum performance without those sql statements that try to
do everything in one massive select statement.

It makes absolutely no sense to plunge down the BO or Cognos black holes

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Thursday, August 01, 2013 11:30 PM
To: Midrange Systems Technical Discussion
Subject: Re: Business Objects with DB2 data

I have to ask why reporting has to be off the IBM i - the SEQUEL product 
gives you really nice reporting capabilities, it is read-only, with 
appropriate security, you can define views that have names that are 
meaningful to end users.

You can take your ERP and frame it as you need to.

So I give a +1 to Paul Nelson's comment here.

There are a couple other reporting products on the system - NGS/IQ and 
BCD's Clover - as well as IBM's Web Query - that can be somewhat 
daunting and needs horsepower, I've heard.

HTH
Vern

On 8/1/2013 7:38 PM, Hoteltravelfundotcom wrote:
> the problem in the company is that there is massive amounts of data. We
> have to get reporting off the AS/400. Is there no positive experience at
> all with Busieness Objects and AS/400?
>
>
> On Thu, Aug 1, 2013 at 7:21 PM, Bill Hopkins <bhopkins@xxxxxxxx> wrote:
>
> > Before allowing user direct access to the data with sequel/sql I would
> > work with your business users and IT to access this "old bulky ERP data
> > base" with Views. Which the users can use to access the data with
"rules".
> > I have seen where five users have five different ways of adding 2 + 2 ...
> > makes for a lot of unnecessary meetings down the road...can't always
count
> > on everyone knowing simple math..lol ... save a lot of headaches on all
> > sides...
> >
> > It will also allow you to keep data out of the wrong hands...even if they
> > are the boss....insert smile here...
> >
> > Also think about stored procedures.
> >
> > Regards,
> > Bill Hopkins
> >
> >
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> > midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
> > Sent: Thursday, August 01, 2013 6:15 PM
> > To: 'Midrange Systems Technical Discussion'
> > Subject: RE: Business Objects with DB2 data
> >
> > I have clients who got roped into BO by their business partner, who made
a
> > bundle selling BO services to their customers. The effort involved is
> > extremely complex.
> >
> > When BO was purchased by Oracle, the business partner was given a year by
> > Oracle to find another package to hustle. They went with Cognos in order
to
> > keep their services revenue.
> >
> > Every one of these clients uses SEQUEL for 99% of their reporting needs,
> > because SEQUEL gives them direct access to the data without having to
play
> > with BO universes or Cognos metadata setups.
> >
> > Paul Nelson
> > Cell 708-670-6978
> > Office 512-392-2577
> > nelsonp@xxxxxxxxxxxxx
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
> > Sent: Thursday, August 01, 2013 4:50 PM
> > To: Midrange Systems Technical Discussion
> > Subject: Business Objects with DB2 data
> >
> > I am interested in hearing of any Iseries shops which use Business
Objects.
> > We are interested
> > in that product to use for reports and allowing users to create their own
> > reports.
> > I am concerned in that that AS/400 ERP we have is rather old product,
> > basically
> > RPG from back in the 90's and data base is very bulky - any experiences
> > would be welcome.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.