IBI Overhead Transparency Template - PowerPoint by tum19250

VIEWS: 104 PAGES: 41

									                   FOCUS in a WebFOCUS World:
                     From FOCUS to WebFOCUS




                                              Walter F. Blood
                          Technical Director, FOCUS Division
                                        Information Builders
                                                    Fall, 2009


    1                                                            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
2
    From FOCUS to WebFOCUS
    The Same, Yet Different


     WebFOCUS                           FOCUS


      Interactive Web         Batch/Interactive

      Reporting based         Transaction based
      Graphic-rich            Green-screen

      Point-n-Click           Editor based



3
    From FOCUS to WebFOCUS
    Four Levels
    WebFOCUS                     FOCUS
                        M
                        I
                        G
                 I
                        R    I
                 N
                        A    N
                 T
         D              T    T   D
                 E
         E              E    E   E
                 G
         V                   G   V
                 R
     M   E                   R   E
                 A                   M
     A   L                   A   L
                 T                   A
     I   O                   T   O
                 E                   I
     N   P                   E   P   N
     T                               T
     A                               A
     I                               I
     N                               N

4
    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
              3. Current application investment               M
     A                                                        A
     I        assurance                                       I
     N                                                        N
     T                                                        T
     A                                                        A
     I                                                        I
     N                                                        N

5
    From FOCUS to WebFOCUS
    Active FOCUS Development

    For users who are actively developing FOCUS
    applications--

               New features to enhance the
           D
               development process
                                                  D
           E                                      E
           V      EXL2K, PDF                      V
           E                                      E
           L      Dynamic reformatting            L
           O                                      O
           P      XFOCUS database and MDI         P
                  FOCLOG
                  Performance Improvement

6
    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
TABLE FILE CAR                        Dynamic
SUM RC0ST/F5 DEALER_COST/CFORMAT                 F10.1
BY COUNTRY
                 Static
END
                                                    D10
     COUNTRY         RCOST       DEALER_COST
     ENGLAND         32485           37853.0
                                                     P10.2
     FRANCE           3721             4,631
     ITALY           39999          41235.00          I9
     JAPAN            5299              5512
     W GERMANY       51895        $54,563.00       D10.2M



7
    From FOCUS to WebFOCUS
    XFOCUS Database Comparison Chart
         FOCUS DATABASE                       XFOCUS DATABASE
                         4K Page Size    16K page size; 2X as many pages
              Alpha fields up to A3964   Alpha fields up to A4096
         Up to 2-Gig per physical file   Up to 16-Gig per physical file
            Up to 255 2-Gig partitions   Up to 1022 16-Gig partitions
           Up to ½ Terabyte total size   Up to 16 Terabytes total size
       Segment names up to 8 chars       Segment names up to 64 chars
     Index field names up to 12 chars    Index field names up to 66 chars
       Page 1 contains FDT and data      Page 1 dedicated to FDT


     More records per page               Reduced I/O
        More pages per file              Fewer partitions
                 Larger files            TRUE DATA WAREHOUSE

8
    From FOCUS to WebFOCUS
    XFOCUS – Replacing Legacy Files

            Converting is easy!
                  Just REBUILD!

    FILE=filename, SUFFIX=FOCUS
    SEGNAME=                          DUMP


           FILE=filename, SUFFIX=XFOCUS
           SEGNAME=                          LOAD



9
     From FOCUS to WebFOCUS
     High Performance Multi-Dimensional Index – MDI
      MDI provides                             MDI has been
     virtually instant            CAR         in use for years
       access to the                          in our FUSION
      data you need                               product




         MODEL

                                            COUNTRY


     MDIs can have more than 3 dimensions


10
     From FOCUS to WebFOCUS
     High Performance Multi-Dimensional Index - MDI


     MASTER = CAR,$          ACCESS FILE
      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               FOCUS                FOCUS               FOCUS
       Online User         Batch Job            Online User         Batch Job


                           Memory                                   Memory
          Memory
                                                Memory
                     FIN         FIN                          FIN
                                               FIN


                             LOG FILE
                              (character flat file)
                                                       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        Log Not       Error          Write
                    Accessible     writing      contention
                                    to log        to log
14
     FOCLOG – A New Product is Born
     Analyze Activity Using WebFOCUS Tools




     WebFOCUS Reports            Dashboard, Graphics
              Excel, HTML, PDF               Visual Discovery




15
     From FOCUS to WebFOCUS
     FOCLOG




                   LPAR 1     LPAR 2


                               FOCLOG

                              How much
                               FOCUS
                               usage?
     LPAR 3     LPAR 4


16
     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

                                        HOLD Files currently
        DB2            FOCUS            remove all structure
                                   ON TABLE HOLD
       Oracle          XFOCUS


                          VSAM       DB2      Oracle


                         VSAM       FOCUS   XFOCUS


20
     Structured HOLD Files
     Now Retain the Structure
                                                                        Plain
                                                                        HOLD File
      FOCUS Database                                               A B C D
                                  TABLE FILE
                    A             PRINT A B C D
                                  IF C EQ 5
               B         C        ON TABLE HOLD [ FORMAT HSA ]
                                  END                         Structured
               E         D                                                   A
                                                                             HOLD File
                                                                         B     C   C=5
                HOLD FORMAT options
     HSA HSBBinary HSXXml HREL HFOC
     Hier Seq Alpha Hier Seq Hier Seq Hier Relational Hier Focus               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
                                         B       C
                                         E       D



22
     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
               A             PRINT A.F1 B.F2 D.F3
                             IF C.F4 EQ 5
        B             C      ON TABLE SET EXTRACT *
                             FIELDS =ALL,$
                             ENDEXTRACT
        E             D       ON TABLE HOLD FORMAT ALPHA
                             END

23
     From FOCUS to WebFOCUS
     Active FOCUS Development

     For users who are actively developing FOCUS
     applications--

                WebFOCUS features to enhance the
            D
                development process
                                                   D
            E                                      E
            V       Stylesheets                    V
            E                                      E
            L                                      L
            O
                    FORECAST                       O
            P                                      P
                     FML Hierarchies



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



25
      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      Method
         CATEGORY     PERIOD     UNITS     COST        MOVAVE
         --------     ------     -----   ------     ---------
         Coffee           01     61666   801123     801,123.0     Max number of
                          02     54870   682340     741,731.5    points to average
                          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
           Predictions
                        {
         beyond real data
                            14
                            15
                                     0
                                     0
                                              0
                                              0
                                                    719,879.4
                                                    705,729.9




26
     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    1
      ON TABLE SET STYLE *
                                                   Month          Month
      GRID=OFF,$
          Caption              TOP                 Actual         Budget
     END -------             DOWN                  ------         ------
            Profit Before Tax                   -320,109.      -498,750.
              Gross Margin        3 LEVELS    -4,146,295.    -4,305,000.
                Sales Revenue                -10,722,253.   -10,605,000.
     INDENT       Retail Sales                -8,448,964.    -8,400,000.
                  Mail Order Sales            -1,167,419.    -1,155,000.
       ON
                  Internet Sales              -1,105,870.    -1,050,000.
      LEVEL     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.




27
     From FOCUS to WebFOCUS
     DATETRAN Subroutine
                     For the ultimate control in date formatting
     ALPHA
                              Month and day translation
     MAXIMUM                  Language
     DATA SIZE                Zero suppression and ordinal suffixes
                              Date delimiters and punctuation
                         SMART DATE
     DEFINE FILE DTFILE                                   LANGUAGE
                         FORMAT
     DTDATE/YYMD = LEGACYDATE;
     FMTDATE/A15=DATETRAN (DTDATE,’(YYMD)’, ‘Btdo’,’EN’, 15, ‘A15’);
     END
     TABLE FILE DTFILE       SMART DATE          DATETRAN
     PRINT FMTDATE AMOUNT    FIELD ONLY          FORMAT
     BY INOVICE
     END                    INOVICE FMTDATE                AMOUNT
                            ------- -------                -----
                            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                       GRAPH FILE CAR
     SUM DCOST BY COUNTRY                 SUM DCOST BY COUNTRY
     ON TABLE HOLD FORMAT VISDIS          ON TABLE HOLD FORMAT PPT
     END                                  END




     Download data to pc and analyze in   Download as slide to pc and add to any
            Visual Discovery                   PowerPoint presentation


29
     From FOCUS to WebFOCUS
     Integrating FOCUS and WebFOCUS
     For users who are integrating FOCUS applications with
     WebFOCUS

                     I
                                         I
                     N
                                         N
                     T
               Existing features to enhance the
                     E
                                         T
                                         E
                     G
               development process -Functionality
                                         G
                     R
                                         R
                     A Heavy lifting
                                         A
                     T
                                         T
                     E
                         Formatting      E


                         Services


30
     From FOCUS to WebFOCUS
     Integrating FOCUS and WebFOCUS
     For users who are integrating FOCUS applications with
     WebFOCUS

                     I
                                         I
                     N
                                         N
                     T
               Existing features to enhance the
                     E
                                         T
                                         E
                     G
               development process       G
                     R
                                         R
                     A FOCUS Email Option
                                         A
                     T
                                         T
                     E
                         WebFOCUS Reporting
                                         E        Agent




31
     From FOCUS to WebFOCUS
     Migrating FOCUS to WebFOCUS
     For users who are                    migrating FOCUS
     applications to              M
                                           WebFOCUS
                                  I
                                  G
                                  R
                                  A
                                  T
       Existing features that   enhance
                                  E
                                          the
       migration process
                            Common code
                            Common FOCUS Language
                            Common Data Interfaces


32
     From FOCUS to WebFOCUS
     4th Degree - Migrating FOCUS to WebFOCUS
     For users who are                  migrating FOCUS
     applications to           M
                                         WebFOCUS
                               I
                               G
                               R
                               A
                               T
                               E
       Existing features that require attention in
       the migration process
                                 Interactive Issues
                                   Execution Issues



33
     From FOCUS to WebFOCUS
     Language Issues

      Language Issues to Watch For
                            M
                            I
                            G
                            R
                            A
       -CRTFORM             T        WINFORM
                            E
       CRTFORM                        HTML
        PROMPT                         XML
        WINDOW                        SCRIPT



34
     From FOCUS to WebFOCUS
     Language Issues

      Language Issues to Watch For
                            M
                            I
                            G
                            R
                            A
       OS command           T        OS command
                            E
       OS RUN                        OS RUN
       ALLOCATE                      FILEDEF
       DYNAM                         SCRIPT
                                     APP

35
     From FOCUS to WebFOCUS
     Language Issues

      Language Issues to Watch For
                            M
                            I
                            G
      TALK                  R
                            A
      Technologies          T
                            E
      MODIFY                         MAINTAIN
      ANALYSE                        FORECAST
      TED                            NOTEPAD
      FSCAN                          SCAN


36
     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
                                       FOCUS
                             E




                                      WebFOCUS


38
     From FOCUS to WebFOCUS
     Execution Issues

      Execution Issues to Watch For
                              M
       Non-Persistent   Connection
                              I      Issues
                              G
                              R       & and && variables
                              A
                              T       SET
                              E
                                      DEFINE
                                      JOIN
                                      FILEDEF
                                      DEFINE FUNCTION


39
     From FOCUS to WebFOCUS
     Execution Issues

      Execution Issues to Watch For
                              M
       Non-Persistent   Connection
                              I      Issues
                              G
                              R       HOLD/SAVE files
                              A
                              T       EXEC
                              E
                                      -INCLUDE
                                      FILTER




40
     From FOCUS to WebFOCUS
     FOCUS in the WebFOCUS World
     WebFOCUS                          FOCUS
                          M
                          I
                          G
                   I
                          R        I
                   N
                          A        N
                   T
           D              T        T   D
                   E
           E              E        E   E
                   G
           V                       G   V
                   R
      M    E                       R   E
                   A                       M
      A    L                       A   L
                   T                       A
      I    O                       T   O
                   E                       I
      N    P                       E   P   N
      T                                    T
      A                                    A
      I                                    I
      N                                    N

41

								
To top