1 / 41

DN 9602 000.0001

FOCUS in a WebFOCUS World: From FOCUS to WebFOCUS. Walter F. Blood Technical Director, FOCUS Division Information Builders Fall, 2009. 1. DN 9602 000.0001. Code merged FOCUS /WebFOCUS 7.6 Release. Common access via interfaces.

aysel
Download Presentation

DN 9602 000.0001

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. FOCUS in a WebFOCUS World: From FOCUS to WebFOCUS Walter F. Blood Technical Director, FOCUS Division Information Builders Fall, 2009 1 DN 9602 000.0001

  2. Code merged FOCUS /WebFOCUS 7.6 Release Common access via interfaces Common functions based upon language WebFOCUS FOCUS From FOCUS to WebFOCUSFrom Many, One

  3. From FOCUS to WebFOCUSThe Same, Yet Different FOCUS WebFOCUS Interactive Web Batch/Interactive Reporting based Transaction based Graphic-rich Green-screen Point-n-Click Editor based

  4. MIGRATE INTEGRATE INTEGRATE DEVELOP DEVELOP MAINTAIN MAINTAIN From FOCUS to WebFOCUSFour Levels FOCUS WebFOCUS

  5. MAINTAIN MAINTAIN From FOCUS to WebFOCUSMaintaining FOCUS Applications For users who are maintaining existing FOCUS applications-- 1. Continued support at their current FOCUS level 2. Operating system support and certification 3. Current application investment assurance

  6. DEVELOP DEVELOP From FOCUS to WebFOCUSActive FOCUS Development For users who are actively developing FOCUS applications-- New features to enhance the development process EXL2K, PDF Dynamic reformatting XFOCUS database and MDI FOCLOG PerformanceImprovement

  7. F10.1 D10 P10.2 I9 From FOCUS to WebFOCUSDynamic Reformatting DEFINE FILE CAR CFORMAT/A8 = DECODE COUNTRY('ENGLAND' 'F10.1' 'FRANCE' 'D10' 'ITALY' 'P10.2' 'JAPAN' 'I9' ELSE'D10.2M'); END TABLE FILE CAR SUM RC0ST/F5 DEALER_COST/CFORMAT BY COUNTRY END Dynamic Static COUNTRYRCOSTDEALER_COST ENGLAND 3248537853.0 FRANCE 37214,631 ITALY 3999941235.00 JAPAN 52995512 W GERMANY 51895 $54,563.00 D10.2M

  8. From FOCUS to WebFOCUSXFOCUS Database Comparison Chart XFOCUS DATABASE 16K page size; 2X as many pages Alpha fields up to A4096 Up to 16-Gig per physical file Up to 1022 16-Gig partitions Up to 16 Terabytes total size Segment names up to 64 chars Index field names up to 66 chars Page 1 dedicated to FDT FOCUS DATABASE 4K Page Size Alpha fields up to A3964 Up to 2-Gig per physical file Up to 255 2-Gig partitions Up to ½ Terabyte total size Segment names up to 8 chars Index field names up to 12 chars Page 1 contains FDT and data More records per page More pages per file Larger files Reduced I/O Fewer partitions TRUE DATA WAREHOUSE

  9. From FOCUS to WebFOCUSXFOCUS – Replacing Legacy Files Converting is easy! Just REBUILD! FILE=filename, SUFFIX=FOCUS SEGNAME= DUMP FILE=filename, SUFFIX=XFOCUS SEGNAME= LOAD

  10. From FOCUS to WebFOCUSHigh Performance Multi-Dimensional Index – MDI MDI provides virtually instant access to the data you need MDI has been in use for years in our FUSION product CAR MODEL COUNTRY MDIs can have more than 3 dimensions

  11. From FOCUS to WebFOCUSHigh Performance Multi-Dimensional Index - MDI ACCESS FILE MASTER = CAR,$ DATA = ‘CARACX1 FOCUS M’,$ DATA = ‘CARACX2 FOCUS M’,$ DATA = ‘CARACX3 FOCUS M’,$ MDI =CARMDI , TARGET_OF = ORIGIN,$ DIM = CAR,$ DIM = COUNTRY,$DIM = MODEL,$ DATA = ‘CARMDI MDI M’,$ TABLE FILE CAR PRINT BODYTYPE SEATS WHERE CAR EQ ‘JAGUAR’ WHERE COUNTRY EQ ‘ENGLAND’ END Unlike RDBMS Clustered Index, MDI fields can be in any order and all fields need not be used. REBUILD MDINEX Creates new MDIs, or adds new partitions to an existing MDI

  12. FOCLOG – A New Product is Born FOCLOG

  13. FIN FIN FIN FIN FTP Mainframe Analysis PC Analysis FOCLOG – A New Product is BornHow Does FOCLOG Work? FOCUS Online User FOCUS Batch Job FOCUS Online User FOCUS Batch Job Memory Memory Memory Memory LOG FILE (character flat file) FOCLOG MFD MVS available now, VM coming shortly

  14. Error writing to log Error writing to log Write contention to log Write contention to log Log Not Accessible Log Not Accessible Log Full Log Full FOCUS FOCLOG – A New Product is BornUser Just Keeps On Going And Going And Going “FOCLOG will never interfere with your session or job” How the bunny uncovers the text The four cloud-groups, known in the Customer Animation box as Group 82, lays on top of a white box, and the identical cloud image is duplicated underneath that. The only reason Group 82 exists is to appear on top of the white box on paper handouts. As such, Group 82 is made to Appear and then Dim immediately, so it is never actually seen on the presented slide at all. That is, the one you see on top here is not the one that appears during the run. During the transition, the underneath cloud images are exposed as the white rectangle box that covers them (I extended it off the screen to the right just to see it here) transitions off to the right in sync with the bunny. If you highlight the bunny or the white box and bring up Custom Animation, you will see these motion lines with their green/red motion handles. GUARANTEED Your session just keeps going and going and going …

  15. FOCLOG – A New Product is BornAnalyze ActivityUsing WebFOCUS Tools WebFOCUS Reports Dashboard, Graphics Excel,HTML, PDF Visual Discovery

  16. LPAR 1 LPAR 2 FOCLOG LPAR 3 LPAR 4 From FOCUS to WebFOCUSFOCLOG How much FOCUS usage?

  17. FOCUSRelease 7.6 Up to 20% faster than FOCUS 7.3 !! New ‘C’ compiler for MVS and VM Includes all new features of How the sliding bar works Obviously overlayed bars, and one moves to the left. But if they were both fully on the screen, then the left side of the moving bar would show movement also and that wouldn’t look good. So I intentionally hung them off the left side of the screen so you don’t see that. FOCUS 7.6 FOCUS 7.3 $ $ $ $ $ $ $ $ CPU DOLLAR$

  18. FOCUSRelease 7.6 Why switch compilers now? • Recent compiler improvements by IBM • Remerged code with WebFOCUS in 7.2 and 7.3 • Bonus – Absorb new features of IBM C Compiler

  19. Structured HOLD Files

  20. VSAM DB2 FOCUS Oracle XFOCUS Structured HOLD FiIesHOLD Flattens the Hierarchy HOLD Files currently remove all structure ON TABLE HOLD VSAM DB2 Oracle VSAM FOCUS XFOCUS

  21. Plain HOLD File A B C D A A E Structured HOLD File B B C C C=5 D D Structured HOLD FilesNow Retain the Structure • Retains knowledge of one-to-many relationships of original file • Structured data easily downloads off mainframe to WebFOCUS FOCUS Database TABLE FILE PRINT A B C D IF C EQ 5 ON TABLE HOLD [ FORMAT HSA ] END HOLD FORMAT options HSA HSB HSX HREL HFOC Hier Seq Alpha Hier Seq Binary Hier Seq Xml Hier Relational Hier Focus

  22. A Deliver structured mainframe data to the pc for deeper analysis and presentation via B C E D Structured HOLD FiIes Move Data to PC How the coordinated effect happens The structure moves left and the PC picture wipes left at the same time using With Previous, but with the PC starting to wipe after a time delay visually adjusted to start when the structure catches up to it. The structure ‘settles’ into the PC via the Smooth End effect option. I let them both hang off the left side of the screen merely for effect. The picture is cropped, and the final end of the movement arrow is off the left edge.

  23. A B C E D Structured HOLD FiIes Content of the HOLD File • Structured HOLD file content is • Determined by structure of and relationships among the input files • Controlled with the FOCUS request syntax TABLE FILE PRINT A.F1 B.F2 D.F3 IF C.F4 EQ 5 ON TABLE SET EXTRACT * FIELDS =ALL,$ ENDEXTRACT ON TABLE HOLD FORMAT ALPHA END

  24. DEVELOP DEVELOP From FOCUS to WebFOCUSActive FOCUS Development For users who are actively developing FOCUS applications-- WebFOCUS features to enhance the development process Stylesheets FORECAST FML Hierarchies

  25. From FOCUS to WebFOCUSStylesheet Enhancements Cascading Stylesheets Compound Reports in one PDF / PS file GRID = ON / FILL / OFF WRAP = ON / OFF PAGECOLOR = color STYLE = [+/-] UNDERLINESET SET PSPAGESETUP = ON / OFF SET STYLEMODE = PAGED Row/Cell Borders With Style/Color Stylesheet Macros Conditional Styling TOPGAP / BOTTOMGAP Around Report Heading / Footing Element Alignment Direct from WebFOCUS • Styling capabilities of WebFOCUS are now in mainframe FOCUS

  26. Number of predictions Forecast Field Interval Method Max number of points to average { Predictions beyond real data From FOCUS to WebFOCUSFORECAST - Prediction algorithms TABLE FILE GGSALES SUM UNITS COST BY CATEGORY BY PERIOD ON PERIODRECAPMOVAVE/D10.1=FORECAST(COST, 1, 3, 'MOVAVE', 3); END CATEGORY PERIOD UNITS COST MOVAVE -------- ------ ----- ------ --------- Coffee 01 61666 801123 801,123.0 02 54870 682340 741,731.5 03 61608 765078 749,513.7    10 57012 724412 703,545.0 11 51110 620264 691,667.7 12 58981 762328 702,334.7 13 0 0 694,975.6 14 0 0 719,879.4 15 0 0 705,729.9

  27. From FOCUS to WebFOCUSBY HIERARCHY Use the simple BY HIERARCHY syntax -- JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF AS J1 TABLE FILE CENTGL SUM NAT_AMOUNT NAT_BUDGET BY GL_ACCOUNT_CAPTION HIERARCHY SHOW TO DOWN 3 ON TABLE SET STYLE * GRID=OFF,$ END PAGE 1 Month Month Caption Actual Budget ------- ------ ------ Profit Before Tax -320,109. -498,750. Gross Margin -4,146,295. -4,305,000. Sales Revenue -10,722,253. -10,605,000. Retail Sales -8,448,964. -8,400,000. Mail Order Sales -1,167,419. -1,155,000. Internet Sales -1,105,870. -1,050,000. Cost Of Goods Sold 6,575,958. 6,300,000. Variable Material Costs 4,957,331. 4,725,000. Direct Labor 1,072,250. 1,050,000. TOP DOWN 3 LEVELS INDENT ON LEVEL

  28. From FOCUS to WebFOCUSDATETRAN Subroutine For the ultimate control in date formatting • Month and day translation • Language • Zero suppression and ordinal suffixes • Date delimiters and punctuation ALPHA MAXIMUM DATA SIZE SMART DATE FORMAT LANGUAGE DEFINE FILE DTFILEDTDATE/YYMD = LEGACYDATE; FMTDATE/A15=DATETRAN (DTDATE,’(YYMD)’, ‘Btdo’,’EN’, 15, ‘A15’); END TABLE FILE DTFILE PRINT FMTDATE AMOUNT BY INOVICE END SMART DATE FIELD ONLY DATETRAN FORMAT • INOVICE FMTDATE AMOUNT • ------- ------- ----- • Jan 4th 2005 $2,333.00 • Feb 2nd 2005 $3,444.00 • Mar 1st 2005 $4,555.00

  29. From FOCUS to WebFOCUSHOLD into PowerPoint and Visual Discovery GRAPH FILE CAR SUM DCOST BY COUNTRY ON TABLE HOLD FORMAT PPT END TABLE FILE CAR SUM DCOST BY COUNTRY ON TABLE HOLD FORMAT VISDIS END • This slide was generated by: • Have the picture below take up the whole slide area. • Do a Print Screen to capture the whole screen. • Move the original graphic off the slide, then Paste. What you get is an image of the whole screen on the slide. • Size it to fit. Download as slide to pc and add to any PowerPoint presentation Download data to pc and analyze in Visual Discovery

  30. INTEGRATE INTEGRATE From FOCUS to WebFOCUSIntegrating FOCUS and WebFOCUS For users who are integrating FOCUS applications with WebFOCUS Existing features to enhance the development process -Functionality Heavy lifting Formatting Services

  31. INTEGRATE INTEGRATE From FOCUS to WebFOCUSIntegrating FOCUS and WebFOCUS For users who are integrating FOCUS applications with WebFOCUS Existing features to enhance the development process FOCUS Email Option WebFOCUS Reporting Agent

  32. MIGRATE From FOCUS to WebFOCUSMigrating FOCUS to WebFOCUS For users who are migrating FOCUS applications to WebFOCUS Existing features that enhance the migration process Common code Common FOCUS Language Common Data Interfaces

  33. MIGRATE From FOCUS to WebFOCUS4th Degree - Migrating FOCUS to WebFOCUS For users who are migrating FOCUS applications to WebFOCUS Existing features that require attention in the migration process Interactive Issues Execution Issues

  34. MIGRATE From FOCUS to WebFOCUSLanguage Issues Language Issues to Watch For -CRTFORM WINFORM Interactive CRTFORM HTML PROMPT XML SCRIPT WINDOW

  35. MIGRATE From FOCUS to WebFOCUSLanguage Issues Language Issues to Watch For OS command OS command Operating System OS RUN OS RUN ALLOCATE FILEDEF DYNAM SCRIPT APP

  36. MIGRATE From FOCUS to WebFOCUSLanguage Issues Language Issues to Watch For TALK Technologies FUNCTIONALITY MAINTAIN MODIFY ANALYSE FORECAST TED NOTEPAD SCAN FSCAN

  37. MIGRATE From FOCUS to WebFOCUSExecution Issues Execution Issues to Watch For Non- Persistence

  38. MIGRATE From FOCUS to WebFOCUSExecution Issues Execution Issues to Watch For ? FOCUS WebFOCUS ?

  39. MIGRATE From FOCUS to WebFOCUSExecution Issues Execution Issues to Watch For Non-Persistent Connection Issues & and && variables SET DEFINE JOIN FILEDEF DEFINE FUNCTION

  40. MIGRATE From FOCUS to WebFOCUSExecution Issues Execution Issues to Watch For Non-Persistent Connection Issues HOLD/SAVE files EXEC -INCLUDE FILTER

  41. MIGRATE INTEGRATE INTEGRATE DEVELOP DEVELOP MAINTAIN MAINTAIN From FOCUS to WebFOCUSFOCUS in the WebFOCUS World FOCUS WebFOCUS Questions?

More Related