RE: Business Objects with DB2 data

<<No business can rely on one person who knows where all the fields are.>>

Why don't you publish a document that shows which fields are in which files?
Not necessarily everything, but the important stuff.

Show the users how to see the files that are open when they are looking at a
screen full of data. They'll figure it out pretty quickly.

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: Friday, August 16, 2013 1:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: Business Objects with DB2 data

The problem we have is that, alot of data is 'located' in the middle of
what I used to call filler fields. So someone has to know that sales rep
name is 1-20 of some field somewhere. All this will need to be mapped. But
I dont' think there is much choice. The company is using a limited I.T.
staff. No business can rely on one person who knows where all the fields
are.


On Tue, Aug 6, 2013 at 1:55 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

I
helped with a BO universe implementation over our production DB...

It wasn't too difficult, basically split the effort between myself and the
i guru and the BO guru. But your IBM i guy needs to be up to date with

SQL

skills.

One nice thing from your perspective is that the BO universe hides the
"bulkiness" of the original DB. The universe concept also allows you to
limit the data (tables) available.

If you don't already have BO (and the expertise) in-house, consider

playing

with IBM's Web Query. If you have a license to Query/400, you are

entitled

to Web Query. Like BO, there's meta-data setup requirements, which makes
it harder to get started but offers some of the same "hiding"
functionality.

Charles




On Thu, Aug 1, 2013 at 5:50 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

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.