• 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!

Data Warehouse?

cglass

Member
Hi List.

We were wondering if anyone retains any sales history on JD Edwards or
through a third-party? Where is the history retained and how is it
accessed? How much history do you retain? Have you encountered any issues
or concerns regarding your "data warehouse"?

Thank you in advance.

_______________________________
Colin Glass - cglass@mlcc.mb.ca
Programmer/Analyst
Manitoba Liquor Control Commission
Ph: (204) 474-5597
 

Mike Dupaix

VIP Member
Colin,

The sales order history is stored in F42019 and F42119 based on the processing options in Sales Update. These files are typically populated when order headers and lines are posted to the GL and invoiced to AR.

You determine how much history you want to keep online. I have several clients that keep three plus years in these 'history' files. Reports can be generated against these tow file and many of the sales inquiries already look at history records based on 'activity status'.

Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 

kcobb

Member
Sales history can be maintained in OW (generally) in 2 table. The f42119 in
the build in history table provided by JDE. The sales update ube (r42800)
can be set using Proc Ops to auto archive most entries at update.
Additionally, R42996 can be used to supplement the move.

I have also seen the f42199 used as an archive. This is a ledger type file
that track the movement of an order based on status changes. The appearance
of an entry in the table is controlled via status setup.

I have also worked with various other external archive programs that do the
trick. The key is the volume of data and the db platform. For reporting
you may want to use a flavor of SQL to create a star schema...

Good luck,

KyL Cobb
Elastic Networks
 

cglass

Member
Doesn't the transactional system slow down when inquiries are made on the historical data?

_______________________________
Colin Glass - cglass@mlcc.mb.ca
Programmer/Analyst
Manitoba Liquor Control Commission
Ph: (204) 474-5597

>>> Mike_Dupaix <Mike_Dupaix@smius.com> 03/16/2001 10:54:18 AM >>>
Colin,

The sales order history is stored in F42019 and F42119 based on the processing options in Sales Update. These files are typically populated when order headers and lines are posted to the GL and invoiced to AR.

You determine how much history you want to keep online. I have several clients that keep three plus years in these 'history' files. Reports can be generated against these tow file and many of the sales inquiries already look at history records based on 'activity status'.

Mike Dupaix
JDE Certified Professional
(630) 904-5373 û Office/Fax
(630) 750-2500 - Cell




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7441
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
 

Mike Dupaix

VIP Member
re[2]: Data Warehouse?

I haven't had any user complaints. Typically users are searching for specific orders or customers and therefore the searches are limited and the screen is refreshed quickly.

> Doesn't the transactional system slow down when inquiries are made on the historical data?

_______________________________
Colin Glass - cglass@mlcc.mb.ca
Programmer/Analyst
Manitoba Liquor Control Commission
Ph: (204) 474-5597

>>> Mike_Dupaix <Mike_Dupaix@smius.com> 03/16/2001 10:54:18 AM >>>
Colin,

The sales order history is stored in F42019 and F42119 based on the processing options in Sales Update. These files are typically populated when order headers and lines are posted to the GL and invoiced to AR.

You determine how much history you want to keep online. I have several clients that keep three plus years in these 'history' files. Reports can be generated against these tow file and many of the sales inquiries already look at history records based on 'activity status'.

Mike Dupaix
JDE Certified Professional
(630) 904-5373 û Office/Fax
(630) 750-2500 - Cell




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7441
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7456
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +

<



Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 

GMunchel

Active Member
Yo Colin,

We download everyday our sales data into TM1, a multi-user OLAP
(multi-dimensional table) server that resides on a Windows NT box on the
network. Our "cube" has company, customer, part number, month, year,
measures (sales $$$, sales quantity, std. mat. cost, std. variable O/H, std
fixed O/H) dimensions. Within the customer and part dimension, several
groupings of low-level elements add upto create major customer and part
calculated elements. The "feed" from the AS/400 table includes the
necessary relationships so that the dimensions and element relationships
within the dimensions are dynamically updated (new parts and customers
added) as part of the download process.

Excel spreadsheets are currently the major front-end reporting tool
(although sexy and powerful web-enabled front-end tools are available like
Insight from www.arcplan.com). A TM1 add-in is installed on each computer's
Excel which gives the user the capability to reach across the network into
the TM1 server's memory and pull out data in real time. Since the data is
stored in the server's RAM, this is incredibly fast. It's cool, it's
flexible, it's powerful, the Excel front end everyone knows & can use, and
it can summarize tons of data virtually instantly (once the cube &
dimensions have been set up). I've been a TM1 user for a decade and love
this product even if the company is as obtuse as h*ll. If interested in
this OLAP data warehousing tool, check it out at www.applix.com.

...Gerry

OneWorld wannabee and Mailing List Lurker
currently World 7.3.10

>
 
Top