IBI Overhead Transparency Template

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
From FOCUS to WebFOCUSFrom Many, One
3
From FOCUS to WebFOCUSThe Same, Yet Different
WebFOCUS
FOCUS
Interactive Web Batch/Interactive
Reporting based Transaction based
Graphic-rich Green-screen
Point-n-Click Editor based
4
From FOCUS to WebFOCUSFour Levels
FOCUS
WebFOCUS
5
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
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
Performance Improvement
7
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
COUNTRY RCOST DEALER_COST ENGLAND
32485 37853.0 FRANCE 3721
4,631 ITALY 39999 41235.00
JAPAN 5299 5512 W GERMANY
51895 54,563.00
D10.2M
8
From FOCUS to WebFOCUSXFOCUS Database Comparison
Chart
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
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
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!
FILEfilename, SUFFIXFOCUS SEGNAME
DUMP
FILEfilename, SUFFIXXFOCUS 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
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
FOCLOG A New Product is BornUser Just Keeps On
Going And Going And Going
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

• FOCLOG will never interfere with your session or
  job

Your session just keeps going and going and going

15
FOCLOG A New Product is BornAnalyze Activity
Using WebFOCUS Tools
Dashboard, Graphics
WebFOCUS Reports
Visual Discovery
Excel, HTML, PDF
16
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 wouldnt look good. So I intentionally hung
them off the left side of the screen so you dont
see that.
FOCUS 7.6
FOCUS 7.3








CPU DOLLAR
18
FOCUSRelease 7.6
IBM C Compiler

• Why switch compilers now?
• Recent compiler improvements by IBM
• Remerged code with WebFOCUS in 7.2 and 7.3
• Bonus Absorb new features of

19
Structured HOLD Files
20
Structured HOLD FiIesHOLD Flattens the Hierarchy

• HOLD Files currently remove all structure

ON TABLE HOLD
VSAM DB2 Oracle
VSAM FOCUS XFOCUS
21
Structured HOLD FilesNow Retain the Structure
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

• Retains knowledge of one-to-many relationships of
  original file
• Structured data easily downloads off mainframe to
  WebFOCUS

22
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
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
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
From FOCUS to WebFOCUSFORECAST - Prediction
algorithms
TABLE FILE GGSALES
SUM UNITS COST BY CATEGORY BY
PERIOD
ON PERIOD RECAP MOVAVE/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
GRIDOFF, 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/A15DATETRAN
(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
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
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
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
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
From FOCUS to WebFOCUSLanguage Issues
Language Issues to Watch For
-CRTFORM
WINFORM
Interactive
CRTFORM
HTML
PROMPT
XML
SCRIPT
WINDOW
35
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
From FOCUS to WebFOCUSLanguage Issues
Language Issues to Watch For
TALK Technologies
FUNCTIONALITY
MAINTAIN
MODIFY
FORECAST
ANALYSE
TED
NOTEPAD
SCAN
FSCAN
37
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch For
Non-
Persistence
38
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch For
?
FOCUS
WebFOCUS
?
39
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch For
Non-Persistent Connection Issues
and variables
SET
DEFINE
JOIN
FILEDEF
DEFINE FUNCTION
40
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch For
Non-Persistent Connection Issues
HOLD/SAVE files
EXEC
-INCLUDE
FILTER
41
From FOCUS to WebFOCUSFOCUS in the WebFOCUS World
FOCUS
WebFOCUS
Questions?