RE: Business Objects with DB2 data

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.