JDE & Crystal 8 connectivity

• Jul 24, 2001

• #2

Guest_imported

New member

Jan 1, 1970

0

I am having the same problem. The table names do not make sense because it is in JDE alpha-numeric.Is there a site that gives some helpful hints on using JDE and Crystal 8.5?

Thanks.

 

Upvote 0 Downvote

• Jul 24, 2001

• Thread starter
• #3

dataprincess

MIS

Apr 12, 2001

29

US

I haven't found one yet. I do have what is called the "Worldsoftware Data Models" book from JDE that gives you an idea of what the tables contain and what they are. Ex F4101 is the Item Master, F4102 is the Item Branch, F3003 is the Routing Master. It also shows the relationship between the tables (one to many, etc) but doesn't tell you on what field it is related to. I've had to come up with my own "field mapping".

If you go to the "Management Menu" you should be able to type a "40" in the selection and it will bring up a form that you can type the name of the table in. Press enter and it will list the fields, description, type, length & position. I've copied and pasted this info into a spreadsheet so I can reference it. I hope this is of some help to you.

If you find a true "data mapping" source or a way to set up the ODBC connection so that it converts it to a user friendly format, please let me know.

 

Upvote 0 Downvote

• Jul 24, 2001

• #4

Guest_imported

New member

Jan 1, 1970

0

Thanks for the info dataprincess.

Which version of OneWorld are you using? JDE has a report writer incorporated into their package. I have just started to look into it as Crystal is very difficult to apply to JDE. Are you familiar with the JDE report writer?

 

Upvote 0 Downvote

• Aug 13, 2001

• Thread starter
• #5

dataprincess

MIS

Apr 12, 2001

29

US

Not real familiar with the report writer in JDE, been using mostly the canned reports.

 

Upvote 0 Downvote

• Aug 13, 2001

• #6

dput

IS-IT--Management

Jul 12, 2001

387

US

We are evaluating J.D.Edwards One World right now, and the report writer looks very powerful. You may want to take the time and try it. Dan

 

Upvote 0 Downvote

• Oct 15, 2001

• #7

Guest_imported

New member

Jan 1, 1970

0

JDE report writer is cumbersome and the reports it produces are thirsty.
Crystal is a better choice by miles.

N

 

Upvote 0 Downvote

• Oct 16, 2001

• Thread starter
• #8

dataprincess

MIS

Apr 12, 2001

29

US

So if your suggestion is to avoid the JDE report writer then are you using Crystal? If so have you found a data mapping that you could share or could you tell me where to get it? The info I've found on the JDE site is useless when it comes to developing relationships and understanding the data flow through the many tables. If you have any information it would be greatly appreciated. Thanks.

 

Upvote 0 Downvote

• Nov 13, 2001

• #9

GregCotten

Programmer

Feb 16, 2001

15

US

In order to configure your ODA settings so you will not see the long table/field name you go into the System DSN tab, choose OneWorld ODA and hit Configure. There are 4 choices for Fields and Table names. I believe if you choose Use Long Column names, it will fix your problem. You might have to try the others if it does not work.

Greg

 

Upvote 0 Downvote

• Nov 30, 2001

• #10

Guest_imported

New member

Jan 1, 1970

0

Hi guys,

I've been reading the reporting issue. Two years ago we've investigated what report tool we were going to use for OneWorld. A visit to Denver learned us that the JDE Report Writer is not user friendly at all. We've chosen Cognos as our reporting tool ans are still satisfied with this choice, very powerful with Impromptu and Powerplay.
We are a leading multinational Pharmaceutical company, I'm based in Europe.
I hope this helps you with your choice.

 

Upvote 0 Downvote