bringing up baby mfg pro in the first three years n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Bringing Up Baby: MFG/PRO in the First Three Years PowerPoint Presentation
Download Presentation
Bringing Up Baby: MFG/PRO in the First Three Years

Loading in 2 Seconds...

  share
play fullscreen
1 / 32
asher

Bringing Up Baby: MFG/PRO in the First Three Years - PowerPoint PPT Presentation

133 Views
Download Presentation
Bringing Up Baby: MFG/PRO in the First Three Years
An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Bringing Up Baby:MFG/PRO in the First Three Years Scott M. Dulecki BravePoint

  2. Timeline • Getting ready • Birth • Infancy • Toddlerhood • Childhood • Questions • Final words

  3. Getting Ready

  4. Getting Ready: Me • Scott M. Dulecki • Presenter at Explore! and regional user groups • Board Member, Midwest MFG/PRO Users Group • President, Michigan Progress Users Group • PEG member 1998061901 • Author of: • Safe Haven: Archiving in MFG/PRO

  5. Getting Ready: Us • BravePoint Inc. (www.BravePoint.com) • 125+ Employees (30+ MFG/PRO Consultants) • QAD Service Alliance Partner • Progress Service Provider • Three of us have used Progress since 1984

  6. Getting Ready: You • MFG/PRO Version? • User Interface? • Progress Version: ? • Oracle? • Go-live date?

  7. Birth

  8. Birth • Single birth • Twins or more • Siamese? • Extra diaper bags

  9. Birth: Single Child • Every plant is in the same DB. • Simple visibility of cross-plant info • There are no secrets • But there are locks on the doors • Common number ranges • Single copy of base data (address, parts, etc.) • Difficult for pre-printed forms

  10. Birth: Twins or More • One plant, one DB • All data is visible to one plant only • Simple to separate when divesting • Complex to bring data together • Challenging for centralized processes • Whose item master is correct? A/R balance?

  11. Birth: Siamese? • AKA Split Schema • Best of both worlds • Break physical database into logical database with multiple chunks. • Common data (addresses, parts, etc.) can be shared • Easy in theory, challenging in practice • Good place to get assistance

  12. Birth: Extra Diaper Bags • You don’t want to be caught without a spare…. • Establish a backup strategy that includes After Imaging • Stick to it • Test it frequently • Restore production to test

  13. Infancy

  14. Infancy • More taking than giving • Feeding and cleaning • Decorating the room

  15. Infancy: More Taking Than Giving • All you do, all day long, is put stuff in • Once in a while, you’d like a smile, or a thanks, or something • Well, something other than that…

  16. Infancy: Feeding and Cleaning • Feeding the database • Entering data • Entering transactions • Burps • Old output files • Printouts

  17. Infancy: Decorating the Room • Personalizing • Adding your own non-intrusive extensions • Customizing • Changing base functionality • Paths • Install in QAD directory • Install in separate directory • Make it simple to get back to vanilla MFG/PRO

  18. Toddlerhood

  19. Toddlerhood • Growing bigger every day • Crawling, walking, running • Old cups

  20. Toddlerhood: Growing Bigger Every Day • History, by definition, tends to grow • Database extents fill up • Including variable extent – BEWARE! • Convert it to fixed, resize at next D&L • More people use the system for more things • Original sizing parameters may no longer be valid

  21. Toddlerhood: Crawling, Walking, Running • Most folks aren’t ready for all of MFG/PRO at the same time • Master the basics, and then move on • BOM Qty Per, inventory, etc. • Master the intermediates, and move on • Min/Max/Mult, scrap/yield, etc. • Master the advanced • Time fences, frozen periods

  22. Toddlerhood: Old Cups • Past decisions come back… to haunt? • Posting G/L in summary or detail? • Sold-to/ship-to/bill-to relationships • When did we turn on…. • Audit trails? • Orphaned sessions • Qad_wkfl • Temporary files (.dbi, .lbi, etc.)

  23. Childhood

  24. Childhood • Two-way communication • Old clothes • New toys • Redecorating

  25. Childhood: Two-Way Communication • Daddy, I don’t feel so good • Database statistics are more meaningful • Dbanalys • Tabanalys for dump & load • Ixanalys for index rebuilds

  26. Childhood: Old Clothes • You will continue to outgrow your history • Consider setting up archive routines • Routinely clean the closets • Keep the database shipshape • Consider setting up a history database • Make history available separately

  27. Childhood: New Toys • New applications may now be feasible • New modules may be needed • Okay, we’ve mastered this. Now what? • New business requirements develop

  28. Childhood: Redecorating • MFG/PRO will have newer versions out • So will Progress • Keeping up to date • easier support • more features • Plan for a successful upgrade • Include your customizations and personalizations

  29. Questions? ?

  30. Final Words

  31. Final Words • Raising your database is just like raising a child – lots of rewards, and lots of challenges, too • The benefits outweigh the problems • “I brought you into this world, and I can take you out. I’ll make another one, looks just like you.” • Bill Cosby’s dad