• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

RDA and HR Data Model

gng_ca

Member
Hi,

I have 2 more questions before the New Year come.
They are:

1.In OW is there a way to build an array using RDA? I
need to create a report with many columns. Based on a
Province code, I will populate one of the province
columns with the open invoice amount. Sample layout
is :

-Provinces
Customer # AB BC SK ON
123456 300.00
449599 500.00
969600 65.00
8999911 3888.00
Total per Province 300.00 500.00 3888.00 65.00

In the old RPG way, I would build 3 arrays, one to
capture the Province Code, one for populating the
detail line and one for the totals. We have to
consider the number of province could increase. How
can we do this in OW? Memory Caching?


2.Anyone has the data model for HR/Payroll? Couldn't
find it in KG.

As usual, your help is very much appreciate.

Have a Happy New Year,
Gordon
OW Xe
Oracle on Sun Unix





__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
 

got_to_love_jde

Reputable Poster
gordon,
i don't think there is any array processing in rda. i think you must go to a c++ program.
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix
 

Gergely_Pongracz

Well Known Member
True, there isn't.
The best solution for Gordon's problem depends wether the number of
coloumns he needs is fixed, limited or dinamically growing. In the first two
cases he can write some simple ERs with variable1, variable2 etc. instead of
using an array... What he cannot do is the third case where even if he could
maintain arrays (he can in C BSFN) he couldn't display them in a limited
number of coloumns.
So as far as I know the type of problem he can write good reports with some
less elegant methods.
Regards and Happy New Year!
Gergely Pongrácz
Synergon, Hungary

> ----------
> From: got_to_love_jde[SMTP:got_to_love_jde@yahoo.com]
> Reply To: jdeowdev@jdelist.com
> Sent: Friday, December 29, 2000 3:01 PM
> To: jdeowdevml@jdelist.com
> Subject: Re: RDA and HR Data Model ~~3221:3225
>
> gordon,
> i don't think there is any array processing in rda. i think you must
> go to a c++ program.
> dave
>
>
> NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix
> --------------------------
> Visit the forum to view this thread at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Num
> ber=3225
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
 

Zoltan_Gyimesi

Legendary Poster
Hi Gordon,

Happy New Year!
Here are my coins:

1.) You can create array Data Items in Data Dictionary for your special needs, setting size of the array in the "Item Occurrences" attributum
...OR...
searching for some existing original array Data Item.
You can search on the FRARRN field of F9210 table. I have done it now and have found 345 array data item (ARRN is greater the zero).
Although I have never used array Data Items, you can read about it more in the Development Tools/Create a Data Item/To Define General Information section. See the main body of the section and the field explanations on the end of this section.

I'm very curious how does it work in ER, so please, share your experiences when you have tried it. Good Luck!

2.) I have found an HRPR.doc in our B7\System\Models\ subfolder but it is very-very poor, not more then a field list of two table without relations. Hope, somebody could help you more or you can find somthing on the KG.

Happy New Year!
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Zoltan_Gyimesi

Legendary Poster
Hi Gordon,
I have forgotten one other solution for your array issue:
Create a custom work file fitting it to your needs. Handling workfile is much more easier then managing cache if you aren't experienced with C++.
Happy New Year!
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

got_to_love_jde

Reputable Poster
Zoltan,
while i love to read your responses i have to question this one. i think the question is not how to define multiple occurrences of the same data item or whether or not to use a work file to help the event rule programming, i think the question is how to reference those multiple occurrences in the event rules. for example "dat,x" like good, old fashioned rpg code.
i find this to be the most limiting "feature" of the event rule programming. i guess that is why virtually all One World reports are lists that go down the page and not array elements that can be be laid out across the page.
If you or anyone else knows how to handle an array please enlighten me !!

and may you all of you have a safe and happy new year !

dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix
 

got_to_love_jde

Reputable Poster
Re: RE: RDA and HR Data Model

Thanks for the confirmation Gergely but i think you are being very generous when you state "less elegant solutions". To handle "array elements" by using multiple occurrences of the same variable named var1, var2, etc. in event rules becomes a very ugly, repetitive solution.
dave
ps: when did i schedule that C++ class again ??

NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix
 

Zoltan_Gyimesi

Legendary Poster
Dave,
You are right. It was a mistake from me. Excuse me.
Now, I have read the documentation again, this time more carefully and I have tried the "Item occurrences" in the Data Dictionary too.
The DD doesn't make else then create a lot of secondary data item based on the primary with an index suffix on the name.
The good old fashioned rpg style "dat,x" that I supposed previuosly, unfortunately doesn't work.
Maybe, we should address this issue to the JDE, making possible array definition and handling for us.
Happy New Year!
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

gng_ca

Member
Hi,

Glad to hear there is a possible solution for array,
before killing myself on C++ code. I will investigate
and try it out. Of course, will share the experience
later.

Thanks & Happy New Year!


--- Zoltan_Gyimesi <zoltan.gyimesi@synergon.hu> wrote:
> Hi Gordon,
>
> Happy New Year!
> Here are my coins:
>
> 1.) You can create array Data Items in Data
> Dictionary for your special needs, setting size of
> the array in the "Item Occurrences" attributum
> ...OR...
> searching for some existing original array Data
> Item.
> You can search on the FRARRN field of F9210 table. I
> have done it now and have found 345 array data item
> (ARRN is greater the zero).
> Although I have never used array Data Items, you can
> read about it more in the Development Tools/Create a
> Data Item/To Define General Information section. See
> the main body of the section and the field
> explanations on the end of this section.
>
> I'm very curious how does it work in ER, so please,
> share your experiences when you have tried it. Good
> Luck!
>
> 2.) I have found an HRPR.doc in our
> B7\System\Models\ subfolder but it is very-very
> poor, not more then a field list of two table
> without relations. Hope, somebody could help you
> more or you can find somthing on the KG.
>
> Happy New Year!
> Zoltán
>
> B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
> (working with B7321, B7331, XE too)
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=3232
>
>
*************************************************************
> This is the JDEList One World / XE Developers
> Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
 

Jack_Crouch

Well Known Member
On the Data Model question...




Seems like some enterprising person or company (OK, JDE should do this ---
but) would sell a decent and complete set of data model documentation.
Basically a nice ERD. I thought there were even tools out there (like
ERWIN) that could read a DB schema and produce something automatically?



AS400 V4R4, B733.2, SP11.3, NT-SQL7 for CO
 
Top