1 / 17

Reporting Strategy Bill Pearce Ventura County CCD

Explore cutting-edge reporting techniques to enhance data analysis efficiency and security. Learn about oracle report replacement, GSASECR security, SQL*Plus reports, and more. Join us for an informative session brought by DARTH TATER!

aikenl
Download Presentation

Reporting Strategy Bill Pearce Ventura County CCD

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. 2005 CONFERENCE April 5th & 6th Reporting StrategyBill PearceVentura County CCD

  2. In honor of STAR WARS III “Revenge of the Sith” This presentation is brought to you by the evil…

  3. DARTH TATER!

  4. What is thy bidding, my Master Considerations • Replace Oracle Reports • Use GSASECR security • Run through job submission – parameter sets • Create text files for download to Excel • Create Adobe files for security • $$$$$ COST $$$$$ • Decided on sql*plus! 3CBG Conference - April 5th & 6th 2005

  5. Impressive. Most Impressive Process Description • xYSxxxx Local Reports can be printed, output to DATABASE, pdf, or text • All Baseline C reports can be printed, output to DATABASE, or pdf • COBOL reports can be printed, output to DATABASE, or selectively to pdf • Uses text2pdf.c program • DATABASE, pdf, text create GUBOUTP only 3CBG Conference - April 5th & 6th 2005

  6. Don’t be too proud of this technological terror you’ve constructed Reporting Schematic xYSxxxx Local Report database or text GUBOUTP Header Record Only text2pdf Web Report Viewer pdf Baseline C, COBOL Report database Report File On server 3CBG Conference - April 5th & 6th 2005

  7. This facility is crude but it should be adequate to freeze Skywalker for his journey to the Emperor. SQL*Plus Reports Created long ago in a galaxy far, far away (and enhanced by CLPCCD) – changes: • Defined as “Procedure” in GJAJOBS • Gjajobs.shl calls common grunsql.shl (unless .shl of same name is found) • Same select creates all 3 types of reports – creates/calls .sql script during runtime to change settings, breaks, totals, etc. for .lis, .pdf, .txt file • Performance much improved over OR 3CBG Conference - April 5th & 6th 2005

  8. I am altering the deal. Pray I don’t alter it any further. column c_text_file noprint new_value cn_text_file select lower('&cn_job_name') || '_' || &cn_one_up_no || '.sql' c_text_file from dual; spool $HOME/&cn_text_file select 'clear breaks' from dual where upper('&cn_printer') = 'TEXT' union all select 'clear computes' from dual where upper('&cn_printer') = 'TEXT' union all select 'set pagesize 50000' from dual where upper('&cn_printer') = 'TEXT' union all select 'ttitle off' from dual where upper('&cn_printer') = 'TEXT' union all select 'set underline off' from dual where upper('&cn_printer') = 'TEXT' union all select 'set pagesize 66' from dual where upper('&cn_printer') = 'PDF' union all select 'ttitle on' from dual where upper('&cn_printer') != 'TEXT'; spool off start $HOME/&cn_text_file !rm $HOME/&cn_text_file

  9. Indeed you are Powerful. Web Report Viewer • Part of Employee Self-Service • Report retention determined by GTVSDAX • Report can be copied to other user(s) or manually deleted • Clock starts over when report is copied to another user • Nightly cleanup script deletes GUBOUTP, server files (uses external tables) 3CBG Conference - April 5th & 6th 2005

  10. There’ll be no-one to stop us this time. Web Report Viewer (continued) • Will replace email to “push” reports • Used to deliver reports from Workflow automatically • Plans to add link to Banner 7.0 menu to sign on automatically to Report Viewer 3CBG Conference - April 5th & 6th 2005

  11. I sense something. A presence I’ve not felt since…

  12. Several fighters have broken off from the main group. Come with me.

  13. All too easy…

  14. There’s no escape. Don’t make me destroy you.

  15. I must obey my Master.

More Related