slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
DN 9602 000.0001 PowerPoint Presentation
Download Presentation
DN 9602 000.0001

Loading in 2 Seconds...

play fullscreen
1 / 41

DN 9602 000.0001 - PowerPoint PPT Presentation


  • 109 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'DN 9602 000.0001' - levi


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

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

from focus to webfocus from many one

Code merged FOCUS /WebFOCUS 7.6 Release

Common access via interfaces

Common functions based upon language

WebFOCUS

FOCUS

From FOCUS to WebFOCUSFrom Many, One
from focus to webfocus the same yet different
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

from focus to webfocus four levels

MIGRATE

INTEGRATE

INTEGRATE

DEVELOP

DEVELOP

MAINTAIN

MAINTAIN

From FOCUS to WebFOCUSFour Levels

FOCUS

WebFOCUS

from focus to webfocus maintaining focus applications

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

from focus to webfocus active focus development

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

from focus to webfocus dynamic reformatting

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

from focus to webfocus xfocus database comparison chart
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

from focus to webfocus xfocus replacing legacy files
From FOCUS to WebFOCUSXFOCUS – Replacing Legacy Files

Converting is easy!

Just REBUILD!

FILE=filename, SUFFIX=FOCUS

SEGNAME=

DUMP

FILE=filename, SUFFIX=XFOCUS

SEGNAME=

LOAD

from focus to webfocus high performance multi dimensional index mdi
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

from focus to webfocus high performance multi dimensional index mdi1
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

foclog a new product is born how does foclog work

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

foclog a new product is born user just keeps on going and going and going

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 …

foclog a new product is born analyze activity using webfocus tools
FOCLOG – A New Product is BornAnalyze ActivityUsing WebFOCUS Tools

WebFOCUS Reports

Dashboard, Graphics

Excel,HTML, PDF

Visual Discovery

from focus to webfocus foclog

LPAR 1

LPAR 2

FOCLOG

LPAR 3

LPAR 4

From FOCUS to WebFOCUSFOCLOG

How much FOCUS usage?

focus release 7 6
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$

focus release 7 61
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

structured hold fiies hold flattens the hierarchy

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

structured hold files now retain the structure

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

structured hold fiies move data to pc

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.

structured hold fiies content of the hold file

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

from focus to webfocus active focus development1

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

from focus to webfocus stylesheet enhancements
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
from focus to webfocus forecast prediction algorithms

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

from focus to webfocus by hierarchy
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

from focus to webfocus datetran subroutine
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
from focus to webfocus hold into powerpoint and visual discovery
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

from focus to webfocus integrating focus and webfocus

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

from focus to webfocus integrating focus and webfocus1

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

from focus to webfocus migrating focus to webfocus

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

from focus to webfocus 4 th degree migrating focus to webfocus

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

from focus to webfocus language issues

MIGRATE

From FOCUS to WebFOCUSLanguage Issues

Language Issues to Watch For

-CRTFORM

WINFORM

Interactive

CRTFORM

HTML

PROMPT

XML

SCRIPT

WINDOW

from focus to webfocus language issues1

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

from focus to webfocus language issues2

MIGRATE

From FOCUS to WebFOCUSLanguage Issues

Language Issues to Watch For

TALK

Technologies

FUNCTIONALITY

MAINTAIN

MODIFY

ANALYSE

FORECAST

TED

NOTEPAD

SCAN

FSCAN

from focus to webfocus execution issues

MIGRATE

From FOCUS to WebFOCUSExecution Issues

Execution Issues to Watch For

Non-

Persistence

from focus to webfocus execution issues1

MIGRATE

From FOCUS to WebFOCUSExecution Issues

Execution Issues to Watch For

?

FOCUS

WebFOCUS

?

from focus to webfocus execution issues2

MIGRATE

From FOCUS to WebFOCUSExecution Issues

Execution Issues to Watch For

Non-Persistent Connection Issues

& and && variables

SET

DEFINE

JOIN

FILEDEF

DEFINE FUNCTION

from focus to webfocus execution issues3

MIGRATE

From FOCUS to WebFOCUSExecution Issues

Execution Issues to Watch For

Non-Persistent Connection Issues

HOLD/SAVE files

EXEC

-INCLUDE

FILTER

from focus to webfocus focus in the webfocus world

MIGRATE

INTEGRATE

INTEGRATE

DEVELOP

DEVELOP

MAINTAIN

MAINTAIN

From FOCUS to WebFOCUSFOCUS in the WebFOCUS World

FOCUS

WebFOCUS

Questions?