Transcript IBI Overhead Transparency Template

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
1
From FOCUS to WebFOCUS
From Many, One
Code merged
FOCUS /WebFOCUS 7.6 Release
Common access via interfaces
Common functions based upon language
WebFOCUS
2
FOCUS
From FOCUS to WebFOCUS
The Same, Yet Different
WebFOCUS
3
FOCUS
Interactive Web
Batch/Interactive
Reporting based
Transaction based
Graphic-rich
Green-screen
Point-n-Click
Editor based
From FOCUS to WebFOCUS
Four Levels
FOCUS
WebFOCUS
M
A
I
N
T
A
I
N
4
D
E
V
E
L
O
P
I
N
T
E
G
R
A
T
E
M
I
G
R
A
T
E
I
N
T
E
G
R
A
T
E
D
E
V
E
L
O
P
M
A
I
N
T
A
I
N
From FOCUS to WebFOCUS
Maintaining FOCUS Applications
For users who are maintaining existing FOCUS
applications-1. Continued support at their current
FOCUS level
2. Operating system support and certification
M
A
I
N
T
A
I
N
5
3. Current application investment
assurance
M
A
I
N
T
A
I
N
From FOCUS to WebFOCUS
Active FOCUS Development
For users who are actively developing FOCUS
applications--
D
E
V
E
L
O
P
New features to enhance the
development process
EXL2K, PDF
Dynamic reformatting
XFOCUS database and MDI
FOCLOG
Performance Improvement
6
D
E
V
E
L
O
P
From FOCUS to WebFOCUS
Dynamic Reformatting
DEFINE FILE CAR
CFORMAT/A8 = DECODE COUNTRY('ENGLAND' 'F10.1' 'FRANCE' 'D10'
'ITALY' 'P10.2' 'JAPAN' 'I9' ELSE 'D10.2M');
END
Dynamic
TABLE FILE CAR
SUM RC0ST/F5 DEALER_COST/CFORMAT
F10.1
BY COUNTRY
Static
END
COUNTRY
ENGLAND
FRANCE
ITALY
JAPAN
W GERMANY
7
RCOST
32485
3721
39999
5299
51895
DEALER_COST
37853.0
4,631
41235.00
5512
$54,563.00
D10
P10.2
I9
D10.2M
From FOCUS to WebFOCUS
XFOCUS 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
Reduced I/O
More pages per file
Larger files
8
Fewer partitions
TRUE DATA WAREHOUSE
From FOCUS to WebFOCUS
XFOCUS – Replacing Legacy Files
Converting is easy!
Just REBUILD!
FILE=filename, SUFFIX=FOCUS
SEGNAME=
DUMP
FILE=filename, SUFFIX=XFOCUS
SEGNAME=
9
LOAD
From FOCUS to WebFOCUS
High Performance Multi-Dimensional Index – MDI
MDI provides
virtually instant
access to the
data you need
CAR
MDI has been
in use for years
in our FUSION
product
MODEL
COUNTRY
MDIs can have more than 3 dimensions
10
From FOCUS to WebFOCUS
High Performance Multi-Dimensional Index - MDI
ACCESS FILE
MASTER = CAR,$
DATA = ‘CARACX1 FOCUS M’,$
DATA = ‘CARACX2 FOCUS M’,$
DATA = ‘CARACX3 FOCUS M’,$
MDI = CARMDI ,
TABLE FILE CAR
TARGET_OF = ORIGIN,$
PRINT BODYTYPE SEATS
DIM = CAR,$
WHERE CAR EQ ‘JAGUAR’
DIM = COUNTRY,$
WHERE COUNTRY EQ ‘ENGLAND’
DIM = MODEL,$
END
DATA = ‘CARMDI MDI M’,$
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
11
FOCLOG – A New Product is Born
12
FOCLOG – A New Product is Born
How Does FOCLOG Work?
FOCUS
Online User
FOCUS
Batch Job
FOCUS
Online User
FOCUS
Batch Job
Memory
Memory
Memory
Memory
FIN
FIN
FIN
LOG
FILE
(character flat file)
FIN
FTP
FOCLOG MFD
Mainframe Analysis
PC Analysis
MVS available now, VM coming shortly
13
FOCLOG – A New Product is Born
User Just Keeps On Going And Going And Going
“FOCLOG will never interfere
with your session or job”
Your session just keeps going and going and going …
Log Full
14
Log Not
Accessible
Error
writing
to log
Write
contention
to log
FOCLOG – A New Product is Born
Analyze Activity Using WebFOCUS Tools
WebFOCUS Reports
Excel, HTML, PDF
15
Dashboard, Graphics
Visual Discovery
From FOCUS to WebFOCUS
FOCLOG
LPAR 1
LPAR 2
FOCLOG
How much
FOCUS
usage?
LPAR 3
16
LPAR 4
FOCUS
Release 7.6
Up to 20% faster than FOCUS 7.3 !!
New ‘C’ compiler for MVS and VM
Includes all new features of
$
17
$
$
$
$
$
$
$
FOCUS
Release 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
18
Structured
HOLD Files
19
Structured HOLD FiIes
HOLD Flattens the Hierarchy
VSAM
DB2
FOCUS
HOLD Files currently
remove all structure
ON TABLE HOLD
Oracle
XFOCUS
VSAM
VSAM
20
DB2
Oracle
FOCUS
XFOCUS
Structured HOLD Files
Now Retain the Structure
FOCUS Database
A
B
C
E
D
Plain
HOLD File
A B C D
TABLE FILE
PRINT A B C D
IF C EQ 5
ON TABLE HOLD [ FORMAT HSA ]
END
Structured
HOLD FORMAT options
HSA
HSB HSX HREL HFOC
Hier Seq Alpha Hier Seq Binary Hier Seq Xml Hier Relational
Hier Focus
AHOLD File
B
C
C=5
D
 Retains knowledge of one-to-many relationships of original file
 Structured data easily downloads off mainframe to WebFOCUS
21
Structured HOLD FiIes
Move Data to PC
Deliver structured mainframe data
to the pc for deeper analysis and
presentation via
A
22
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
A
23
B
C
E
D
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
From FOCUS to WebFOCUS
Active FOCUS Development
For users who are actively developing FOCUS
applications--
D
E
V
E
L
O
P
24
WebFOCUS features to enhance the
development process
Stylesheets
FORECAST
FML Hierarchies
D
E
V
E
L
O
P
From FOCUS to WebFOCUS
Stylesheet Enhancements

25
Styling capabilities of
WebFOCUS are now
in mainframe FOCUS
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
From FOCUS to WebFOCUS
FORECAST - Prediction algorithms
TABLE FILE GGSALES
Number of predictions
SUM UNITS COST
Forecast Field
BY CATEGORY BY PERIOD
ON PERIOD RECAP MOVAVE/D10.1= FORECAST(COST, 1, 3, 'MOVAVE', 3);
END
Interval
CATEGORY
-------Coffee
  
PERIOD
-----01
02
03
UNITS
----61666
54870
61608
COST
-----801123
682340
765078
MOVAVE
--------801,123.0
741,731.5
749,513.7
10
11
12
13
14
15
57012
51110
58981
0
0
0
724412
620264
762328
0
0
0
703,545.0
691,667.7
702,334.7
694,975.6
719,879.4
705,729.9
{
Predictions
beyond real data
26
Method
Max number of
points to average
From FOCUS to WebFOCUS
BY 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
PAGE SET1 STYLE *
ON TABLE
GRID=OFF,$
Caption
TOP
END ------DOWN
Profit Before Tax
3 LEVELS
Gross Margin
Sales Revenue
Retail Sales
INDENT
Mail Order Sales
ON
Internet Sales
LEVEL
Cost Of Goods Sold
Variable Material Costs
Direct Labor
27
Month
Actual
------320,109.
-4,146,295.
-10,722,253.
-8,448,964.
-1,167,419.
-1,105,870.
6,575,958.
4,957,331.
1,072,250.
Month
Budget
------498,750.
-4,305,000.
-10,605,000.
-8,400,000.
-1,155,000.
-1,050,000.
6,300,000.
4,725,000.
1,050,000.
From FOCUS to WebFOCUS
DATETRAN Subroutine
ALPHA
MAXIMUM
DATA SIZE
For the ultimate control in date formatting
 Month and day translation
 Language
 Zero suppression and ordinal suffixes
 Date delimiters and punctuation
SMART DATE
LANGUAGE
DEFINE FILE DTFILE
FORMAT
DTDATE/YYMD = LEGACYDATE;
FMTDATE/A15=DATETRAN (DTDATE,’(YYMD)’, ‘Btdo’,’EN’, 15, ‘A15’);
END
SMART DATE
DATETRAN
TABLE FILE DTFILE
FIELD ONLY
FORMAT
PRINT FMTDATE AMOUNT
BY INOVICE
INOVICE FMTDATE
AMOUNT
END
------- ----------11111
Jan 4th 2005
$2,333.00
11112
Feb 2nd 2005
$3,444.00
11113
Mar 1st 2005
$4,555.00
28
From FOCUS to WebFOCUS
HOLD into PowerPoint and Visual Discovery
TABLE FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT VISDIS
END
Download data to pc and analyze in
Visual Discovery
29
GRAPH FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT PPT
END
Download as slide to pc and add to any
PowerPoint presentation
From FOCUS to WebFOCUS
Integrating FOCUS and WebFOCUS
For users who are integrating FOCUS applications with
WebFOCUS
I
I
N
N
T
T
Existing
E features to enhance the
E
G
development
process -Functionality
G
R
R
A Heavy lifting
A
T
T
E
E
Formatting
Services
30
From FOCUS to WebFOCUS
Integrating FOCUS and WebFOCUS
For users who are integrating FOCUS applications with
WebFOCUS
I
I
N
N
T
T
Existing
E features to enhance the
E
G
development
process
G
R
R
A FOCUS Email Option
A
T
T
E
E
WebFOCUS Reporting
31
Agent
From FOCUS to WebFOCUS
Migrating FOCUS to WebFOCUS
For users who are
applications to
Existing features that
migration process
M
I
G
R
A
T
enhance
E
migrating FOCUS
WebFOCUS
the
Common code
Common FOCUS Language
Common Data Interfaces
32
From FOCUS to WebFOCUS
4th Degree - Migrating FOCUS to WebFOCUS
For users who are
applications to
M
I
G
R
A
T
E
migrating FOCUS
WebFOCUS
Existing features that require attention in
the migration process
Interactive Issues
Execution Issues
33
From FOCUS to WebFOCUS
Language Issues
Language Issues to Watch
M For
-CRTFORM
34
I
G
R
A
T
E
CRTFORM
WINFORM
HTML
PROMPT
WINDOW
XML
SCRIPT
From FOCUS to WebFOCUS
Language Issues
Language Issues to Watch
M For
OS command
I
G
R
A
T
E
OS command
OS RUN
OS RUN
ALLOCATE
DYNAM
FILEDEF
SCRIPT
APP
35
From FOCUS to WebFOCUS
Language Issues
Language Issues to Watch
M For
TALK
Technologies
MODIFY
ANALYSE
TED
FSCAN
36
I
G
R
A
T
E
MAINTAIN
FORECAST
NOTEPAD
SCAN
From FOCUS to WebFOCUS
Execution Issues
Execution Issues to Watch For
M
I
G
R
A
T
E
37
From FOCUS to WebFOCUS
Execution Issues
Execution Issues to Watch For
M
I
G
R
A
T
E
FOCUS
WebFOCUS
38
From FOCUS to WebFOCUS
Execution Issues
Execution Issues to Watch For
Non-Persistent
M
Connection
I
G
R
A
T
E
Issues
& and && variables
SET
DEFINE
JOIN
FILEDEF
DEFINE FUNCTION
39
From FOCUS to WebFOCUS
Execution Issues
Execution Issues to Watch For
Non-Persistent
M
Connection
I
G
R
A
T
E
Issues
HOLD/SAVE files
EXEC
-INCLUDE
FILTER
40
From FOCUS to WebFOCUS
FOCUS in the WebFOCUS World
FOCUS
WebFOCUS
M
A
I
N
T
A
I
N
41
D
E
V
E
L
O
P
I
N
T
E
G
R
A
T
E
M
I
G
R
A
T
E
I
N
T
E
G
R
A
T
E
D
E
V
E
L
O
P
M
A
I
N
T
A
I
N