1 / 77

How Your DBA or Database Programmer Can Improve Your Argos Reporting!

How Your DBA or Database Programmer Can Improve Your Argos Reporting!. Presented By Bruce Knox University of Arkansas Division of Agriculture Cooperative Extension Service BAS S274 October 14 th 2008. Argos provides THE missing Banner Reporting Tool.

griffin-munoz
Download Presentation

How Your DBA or Database Programmer Can Improve Your Argos Reporting!

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How Your DBA or Database Programmer Can Improve Your Argos Reporting! Presented By Bruce Knox University of Arkansas Division of Agriculture Cooperative Extension Service BAS S274 October 14th 2008 How your Database Professionals can Improve your Argos Reporting

  2. Argos provides THE missing Banner Reporting Tool How your Database Professionals can Improve your Argos Reporting

  3. Even with Argos, there remains a need for further simplification How your Database Professionals can Improve your Argos Reporting

  4. Even with Argos, there remains a need for further simplification • Current Banner Record Sets How your Database Professionals can Improve your Argos Reporting

  5. Even with Argos, there remains a need for further simplification • Current Banner Record Sets • Flattened Banner Data How your Database Professionals can Improve your Argos Reporting

  6. Even with Argos, there remains a need for further simplification • Current Banner Record Sets • Flattened Banner Data • Using Desktop Data with Banner How your Database Professionals can Improve your Argos Reporting

  7. Views, Views, and Banner Views How your Database Professionals can Improve your Argos Reporting

  8. Views, Views, and Banner Views • To Deal with Effective Dated Records How your Database Professionals can Improve your Argos Reporting

  9. Views, Views, and Banner Views • To Deal with Effective Dated Records • To Flatten The Database How your Database Professionals can Improve your Argos Reporting

  10. Views, Views, and Banner Views • To Deal with Effective Dated Records • To Flatten The Database • Using Existing Banner Provided Views How your Database Professionals can Improve your Argos Reporting

  11. Effective Dated Records How your Database Professionals can Improve your Argos Reporting

  12. Effective Dated Records • The #1 Bane of Ad Hoc Banner Reporting How your Database Professionals can Improve your Argos Reporting

  13. Effective Dated Records • 99% of all Ad Hoc Reports are for Current Banner Records How your Database Professionals can Improve your Argos Reporting

  14. Effective Dated Records • 99% of all Ad Hoc Reports are for Current Records • Oracle Views can Deliver them without the need for Additional Selection Criteria How your Database Professionals can Improve your Argos Reporting

  15. Effective Dated Records • 99% of all Ad Hoc Reports are for Current Records • Views can Deliver them without the need for Additional Selection Criteria • Just JOIN the Views and the Query is Done! How your Database Professionals can Improve your Argos Reporting

  16. How your Database Professionals can Improve your Argos Reporting

  17. How your Database Professionals can Improve your Argos Reporting

  18. How your Database Professionals can Improve your Argos Reporting

  19. What Was Hidden Here? How your Database Professionals can Improve your Argos Reporting

  20. What Was Hidden Here? FROM FTVORGN WHERE TRUNC(FTVORGN_EFF_DATE) <= SYSDATE AND (FTVORGN_NCHG_DATE > SYSDATE OR FTVORGN_NCHG_DATE IS NULL) AND (FTVORGN_TERM_DATE > SYSDATE OR FTVORGN_TERM_DATE IS NULL) AND FTVORGN_STATUS_IND = 'A' How your Database Professionals can Improve your Argos Reporting

  21. Thousands of Related Tables How your Database Professionals can Improve your Argos Reporting

  22. Thousands of Related Tables • The #2 Bane of Ad Hoc Banner Reporting How your Database Professionals can Improve your Argos Reporting

  23. Thousands of Related Tables • The #2 Bane of Ad Hoc Banner Reporting • Oracle Views Can Flatten the Database How your Database Professionals can Improve your Argos Reporting

  24. Views How your Database Professionals can Improve your Argos Reporting

  25. How your Database Professionals can Improve your Argos Reporting

  26. Oracle Views How your Database Professionals can Improve your Argos Reporting

  27. Oracle Views How your Database Professionals can Improve your Argos Reporting

  28. How your Database Professionals can Improve your Argos Reporting

  29. How your Database Professionals can Improve your Argos Reporting

  30. Oracle Views How your Database Professionals can Improve your Argos Reporting

  31. From the Users’ Point of View How your Database Professionals can Improve your Argos Reporting

  32. How your Database Professionals can Improve your Argos Reporting

  33. How your Database Professionals can Improve your Argos Reporting

  34. How your Database Professionals can Improve your Argos Reporting

  35. Views How your Database Professionals can Improve your Argos Reporting

  36. Banner Views How your Database Professionals can Improve your Argos Reporting

  37. Banner Views • Banner Actually Includes Useful Views How your Database Professionals can Improve your Argos Reporting

  38. Banner Views • PEVEMPL: Employee Information View How your Database Professionals can Improve your Argos Reporting

  39. Banner Views • PEVEMPL: Employee Information View • A Commonly Used View How your Database Professionals can Improve your Argos Reporting

  40. Banner Views • PEVEMPL: Employee Information View • A Commonly Used View • Flattens 16 Tables How your Database Professionals can Improve your Argos Reporting

  41. Banner Views • PEVEMPL: Employee Information View • A Commonly Used View • Flattens 16 Tables • Obscures the Source Column Names How your Database Professionals can Improve your Argos Reporting

  42. How your Database Professionals can Improve your Argos Reporting

  43. How your Database Professionals can Improve your Argos Reporting

  44. Banner Views How your Database Professionals can Improve your Argos Reporting

  45. Banner Views How your Database Professionals can Improve your Argos Reporting

  46. Banner Views How your Database Professionals can Improve your Argos Reporting

  47. Importing Desktop Data How your Database Professionals can Improve your Argos Reporting

  48. Importing Desktop Data • Oracle Operates Best with Data in Oracle How your Database Professionals can Improve your Argos Reporting

  49. Importing Desktop Data • Oracle Operates Best with Data in Oracle • Upload Data Interactively with APEX How your Database Professionals can Improve your Argos Reporting

  50. Importing Desktop Data • Oracle Operates Best with Data in Oracle • Upload Data Interactively with APEX • Loading an Excel file • Upload Using Batch Scripts How your Database Professionals can Improve your Argos Reporting

More Related