1 / 63

WebFOCUS for the layman Part 2

WebFOCUS for the layman Part 2. Steve Simon State Street Corporation. Who and what is our audience?. Business Analysts. WebFOCUS ‘newbie's’. Before we start, we shall have a quick review of:. Creating an adapter. Creating a synonym. Synonym. Data Adapter. Code. Master.

taite
Download Presentation

WebFOCUS for the layman Part 2

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. WebFOCUS for the laymanPart 2 Steve Simon State Street Corporation

  2. Who and what is our audience? Business Analysts. WebFOCUS ‘newbie's’.

  3. Before we start, we shall have a quick review of: Creating an adapter. Creating a synonym.

  4. Synonym • Data Adapter • Code • Master How do the parts fit together? Access Excel SQL Server

  5. What we shall examine during this hour Examining DRILL THROUGH reports. Examining GRAPHIC reports.

  6. Implementing the adapter

  7. Adapter WebFOCUS Excel ‘Garden hose’

  8. Creating the synonym

  9. The master file

  10. Mean while back at the ranch…

  11. Creating a drill through report

  12. Demo 1

  13. Creating the TOP level report

  14. SET MSG = OFF -RUN TABLE FILE MAXMININV$ SUM PRODUCTTYPENAME AS 'PRODUCT TYPE' PRODUCTSUBTYPENAME AS 'PRODUCT SUB TYPE' PRODUCTNAME AS 'PRODUCT NAME' BY PRODUCTTYPENAME NOPRINT BY PRODUCTSUBTYPENAME NOPRINT END

  15. Creating the TOP level report with DRILLTHROUGH enabled

  16. SET MSG = OFF -RUN TABLE FILE MAXMININV$ SUM PRODUCTTYPENAME AS 'PRODUCT TYPE' PRODUCTSUBTYPENAME AS 'PRODUCT SUB TYPE' PRODUCTNAME AS 'PRODUCT NAME' BY PRODUCTTYPENAME NOPRINT BY PRODUCTSUBTYPENAME NOPRINT ON TABLE PCHOLD FORMAT PDF OPEN ON TABLE SET STYLE * TYPE = DATA, COLUMN=PRODUCTNAME, DRILLTHROUGH=DOWN(PRODUCTTYPENAME PRODUCTSUBTYPENAME),$ UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ ENDSTYLE END

  17. Creating the LOWER level report

  18. TABLE FILE MAXMININV$ SUM INVENTORYLEVEL NUMBERONBACKORDER BY PRODUCTTYPENAME BY PRODUCTSUBTYPENAME BY PRODUCTNAME ON PRODUCTTYPENAME PAGE-BREAK HEADING CENTER "Product Type <PRODUCTTYPENAME " " " ON PRODUCTSUBTYPENAME SUBHEAD " ***** Product Subtype <PRODUCTSUBTYPENAME" FOOTING "" ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE=SUBHEAD, LINE=1, ITEM = 2, DRILLTHROUGH = FIRST(PRODUCTTYPENAME PRODUCTSUBTYPENAME), COLOR=RED,$ ORIENTATION=LANDSCAPE, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $.......... END STYLE END

  19. Demo 1 revisited

  20. Creating a graphic report with graphical features using the GUI

  21. Demo 2

  22. Creating a graphic report from existing code

  23. Oh yes!! And the code behind

  24. -* File MaxMinGraph1.fex TABLE FILE MAXMININV$ SUM INVENTORYLEVEL AS 'Current inventory' NUMBERONBACKORDER AS 'Number back ordered' BY PRODUCTTYPENAME AS 'Product Type Name' BY PRODUCTSUBTYPENAME AS 'Product SubType Name' BY PRODUCTNAME AS 'Product Name' HEADING " <+0> Summary Report" "Current Inventory and Backorders" WHERE PRODUCTNAME EQ 'Wolf Pack' OR 'Bear with Hive' OR 'Elvin Archer'; END

  25. Converting it to graphic format is extremely complex 

  26. -* File MaxMinGraph1.fex GRAPH FILE MAXMININV$ SUM INVENTORYLEVEL AS 'Current inventory' NUMBERONBACKORDER AS 'Number back ordered' BY PRODUCTTYPENAME AS 'Product Type Name' BY PRODUCTSUBTYPENAME AS 'Product SubType Name' BY PRODUCTNAME AS 'Product Name' HEADING " <+0> Summary Report" "Current Inventory and Backorders" WHERE PRODUCTNAME EQ 'Wolf Pack' OR 'Bear with Hive' OR 'Elvin Archer'; END

  27. Demo 3

  28. “Prettied Up”

  29. Demo 4

  30. “The ole pie”

  31. GRAPH FILE MAXMININV$ SUM INVENTORYLEVEL AS 'Current inventory' BY PRODUCTNAME AS 'Product Name' HEADING " <+0> Summary Report <+0> <PRODUCTTYPENAME" "Current Inventory and Backorders" WHERE PRODUCTNAME EQ 'Wolf Pack' OR 'Bear with Hive' OR 'Elvin Archer'; ON GRAPH SET LOOKGRAPH PIE ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET BARNUMB OFF ON GRAPH SET 3D OFF ON GRAPH SET VZERO ON ON GRAPH SET GRID ON ON GRAPH SET GRWIDTH 0 ON GRAPH PCHOLD FORMAT PNG ON GRAPH SET GRAPHSTYLE * setMarkerDisplay(true);

More Related