RE: Business Objects with DB2 data

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

<<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.