Transcript American Express & Information Builders A WebFOCUS

WebFOCUS 7.7x
New Features
Brian Larkins
Information Builders
Copyright 20011, Information Builders. Slide 1
7.7 New Features Manual
Copyright 2007, Information Builders. Slide 2
WebFOCUS 7.7x new features
You can download the New Features Document at:
http://documentation.informationbuilders.com/masterindex/html/cur_rel.asp
Copyright 2007, Information Builders. Slide 3
Accordion Report Enhancement
Copyright 2010, Information Builders. Slide 4
Developer Studio
Accordion Reports – by column
-* File accordianrpt.fex
TABLE FILE WORKSHOP
SUM
LineTotal
CostOfGoodsSold
BY PlantCode
BY Year
BY Quarter
BY Month
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 5
Developer Studio
Accordion Reports – by column
Copyright 2007, Information Builders. Slide 6
Developer Studio
Accordion Reports – by column
Copyright 2007, Information Builders. Slide 7
Developer Studio
Accordion Reports – by column
Copyright 2007, Information Builders. Slide 8
Developer Studio
Accordion Reports – by Row
-* File accordianrpt2.fex
SET EXPANDBYROW=ON
TABLE FILE WORKSHOP
SUM
LineTotal
CostOfGoodsSold
BY LOWEST PlantCode
BY LOWEST Year
BY LOWEST Quarter
BY LOWEST Month
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
OFF/ON/ALL
ON=expand highest level sort
fields on initial display
ALL=expand all sort fields on
initial display
Copyright 2007, Information Builders. Slide 9
Developer Studio
Accordion Reports – by Row
Copyright 2007, Information Builders. Slide 10
Developer Studio
Accordion Reports – by Row
Copyright 2007, Information Builders. Slide 11
Positioning ACROSS Titles
Copyright 2010, Information Builders. Slide 12
Developer Studio
Positioning ACROSS Titles
-* File acrosstitles.fex
SET ACROSSTITLE = ABOVE
TABLE FILE WORKSHOP
SUM
CostOfGoodsSold AS 'COGS'
LineTotal AS 'Sales'
BY PlantCode
ACROSS LOWEST Year
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BACKCOLOR='WHITE',
$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 13
Developer Studio
Positioning Across Titles
Copyright 2007, Information Builders. Slide 14
Developer Studio
Positioning Across Titles
-* File acrosstitles2.fex
SET ACROSSTITLE = ABOVE
TABLE FILE WORKSHOP
SUM
CostOfGoodsSold AS 'COGS'
LineTotal AS 'Sales'
BY PlantCode
ACROSS LOWEST Year
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BACKCOLOR='WHITE',
$
ENDSTYLE
END
Default is ABOVE
Copyright 2007, Information Builders. Slide 15
Developer Studio
Positioning Across Titles
Copyright 2007, Information Builders. Slide 16
Excel Enhancements
Copyright 2010, Information Builders. Slide 17
Excel Enhancements
 Excel 2007 support
 Developer Studio
 InfoAssist
 Report Assist
 Creates XLSX file
 Zipped file that is 1/3 the size of XLS files
 Excel 2000
 Overflow worksheets get around 65K row limit
Copyright 2007, Information Builders. Slide 18
Excel 2000
Generating over flow sheets
* File excel2000.fex
TABLE FILE WORKSHOP
SUM
LineTotal
BY PlantCode
BY Year
BY Quarter
BY Month
BY LOWEST CostOfGoodsSold
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET LINES 5000
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ROWOVERFLOW=ON,
$
ENDSTYLE
END
5000 lines per worksheet
Copyright 2007, Information Builders. Slide 19
Hide Null Columns in ACROSS reports
Copyright 2010, Information Builders. Slide 20
Hide Nulls ACROSS columns
 SET HIDENULLACRS=ON|OFF
 Hide ACROSS columns that are all null within each sort
break
Copyright 2007, Information Builders. Slide 21
Hide Nulls Across Columns
Standard HTML Across Report (DEFAULT)
Copyright 2007, Information Builders. Slide 22
Hide Null Across Columns
SET HIDENULLACRS=ON
Copyright 2007, Information Builders. Slide 23
TOC and Bookmarks in PDF documents
Copyright 2010, Information Builders. Slide 24
Bookmarks in PDF documents
Copyright 2007, Information Builders. Slide 25
Bookmarks in PDF documents
COMPOUND LAYOUT PCHOLD FORMAT PDF
OBJECT=BOOKMARKS, $
SECTION=S1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, $
PAGELAYOUT=1, $
COMPONENT=report1, TEXT='Sales By Product', TOC-LEVEL=1, BYTOC=2,
POSITION=(1 1), DIMENSION=(* *), $
COMPONENT=report2, TEXT='Sales By Region', TOC-LEVEL=1, BYTOC=2,
POSITION=(+0.00 +0.519), DIMENSION=(* *),
RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT,
POSITION-POINT=TOP-LEFT, $
END
SET COMPONENT=report1
TABLE FILE GGSALES
SUM DOLLARS/F8M
BY CATEGORY BY PRODUCT BY REGION BY ST
HEADING
"Sales by Product"
ON TABLE HOLD FORMAT PDF
END
SET COMPONENT=report2
TABLE FILE GGSALES
SUM DOLLARS/F8M
BY REGION BY ST BY CATEGORY BY PRODUCT
HEADING
"Sales by Region"
ON TABLE HOLD FORMAT PDF
END
COMPOUND END
Copyright 2007, Information Builders. Slide 26
TOC and Bookmarks in PDF documents
Copyright 2007, Information Builders. Slide 27
TOC and Bookmarks in PDF documents
COMPOUND LAYOUT PCHOLD FORMAT PDF
OBJECT=BOOKMARKS, $
OBJECT=TOC, NAME='text1', TEXT='<font face="ARIAL" size=10>Table of
Contents</font>',
MARKUP=ON, TOC-NUMBERING=ON, POSITION=(0.854 0.854), DIMENSION=(7.000
9.500),
font='ARIAL', color=RGB(0 0 0), size=10, METADATA=' TOCTITLE: Table of
Contents', $
SECTION=S1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, $
PAGELAYOUT=1, $
COMPONENT=report1, TEXT='Sales By Product', TOC-LEVEL=1, BYTOC=2,
POSITION=(1 1), DIMENSION=(* *), $
COMPONENT=report2, TEXT='Sales By Region', TOC-LEVEL=1, BYTOC=2,
POSITION=(+0.00 +0.519), DIMENSION=(* *),
RELATIVE-TO='report1', RELATIVE-POINT=BOTTOM-LEFT,
POSITION-POINT=TOP-LEFT, $
END
SET COMPONENT=report1
TABLE FILE GGSALES
……
END
SET COMPONENT=report2
TABLE FILE GGSALES
……
END
COMPOUND END
Added TOC
Object
Copyright 2007, Information Builders. Slide 28
Active Reports
Copyright 2010, Information Builders. Slide 29
Active Reports
Active Chart with WebFOCUS Syntax
-* File ar_graphcode.fex
GRAPH FILE WORKSHOP
SUM LineTotal
BY PlantCode
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH PCHOLD FORMAT FLEX
ON GRAPH SET STYLE *
TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=FLAT,$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 30
Active Reports
Active Chart with WebFOCUS Syntax
Copyright 2007, Information Builders. Slide 31
Active Reports
Active Chart with WebFOCUS syntax
-* File ar_graphcode.fex
GRAPH FILE WORKSHOP
SUM LineTotal
BY PlantCode
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH PCHOLD FORMAT APDF
ON GRAPH SET STYLE *
TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=FLAT,$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 32
Active Reports
Active Chart with WebFOCUS Syntax
Copyright 2007, Information Builders. Slide 33
Active Reports
Chart/Rollup tool for APDF and FLEX Report Outputs
Copyright 2007, Information Builders. Slide 34
Active Reports
Chart/Rollup in APDF and FLEX Report Outputs
Copyright 2007, Information Builders. Slide 35
Active Reports
Fusion Charts supported for Flash Active Reports
Copyright 2007, Information Builders. Slide 36
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=MSLine,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHARTTYPE=MSColumn3D,
TYPE=REPORT,
LINES-PERPAGE=20,
REPORTVIEW=FUSIONCHART,
CHARTTYPE=MSBar3D,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=MSArea,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Bubble,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Pyramid,
TYPE=REPORT,
LINES-PERPAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Radar,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Scatter,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Pie3D,
TYPE=REPORT,
LINES-PER-PAGE=20,
REPORTVIEW=FUSIONCHART,
CHART-TYPE=Funnel,
Active Reports
Code generated by Developer Studio
TABLE FILE GGSALES
SUM
GGSALES.SALES01.DOLLARS
GGSALES.SALES01.UNITS
BY GGSALES.SALES01.REGION
BY LOWEST GGSALES.SALES01.ST
BY LOWEST GGSALES.SALES01.PRODUCT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT FLEX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
ARGRAPHENGINE=FUSION,
$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 39
Active Reports
Collapsible Legends
Copyright 2007, Information Builders. Slide 40
Active Reports
Collapsible legends
Copyright 2007, Information Builders. Slide 41
Active Reports
Collapsible legends – From Dev Studio
Copyright 2007, Information Builders. Slide 42
Active Reports
Collapsible legends – the CODE
TABLE FILE GGSALES
SUM
GGSALES.SALES01.DOLLARS
BY LOWEST GGSALES.SALES01.PRODUCT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT FLEX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
REPORT-VIEW=CHART,
CHART-TYPE=BAR,
$
TYPE=REPORT,
OBJECT=LEGEND,
LEGEND-VIEW=DOCKING,
POSITION-POINT=BOTTOM-LEFT,
$
ENDSTYLE
END
Copyright 2007, Information Builders. Slide 43
HTML Composer Enhancements
Copyright 2010, Information Builders. Slide 44
HTML Composer Enhancements
 Create Rich Internet Applications (RIA)
 Create interactive web page experiences inside browser
 Generate exact look and feel of a Windows GUI
 Set RIA themes for a page and animation properties for

objects
Convert existing HTML Composer generated pages to RIA
Copyright 2007, Information Builders. Slide 45
HTML Composer
Basic HTML layout
Copyright 2007, Information Builders. Slide 46
HTML Composer
Document – RIA Themes
Copyright 2007, Information Builders. Slide 47
HTML Composer
RIA Themes
Copyright 2007, Information Builders. Slide 48
HTML Composer
Additional RIA Objects - Accordion Controls and Window Controls
Copyright 2007, Information Builders. Slide 49
HTML Composer
Window and Accordion RIA Objects
Copyright 2007, Information Builders. Slide 50
HTML Composer
Window and Accordion RIA objects
Copyright 2007, Information Builders. Slide 51
HTML Composer
Additional RIA Examples
Copyright 2007, Information Builders. Slide 52
HTML Composer
Additional RIA Examples
Copyright 2007, Information Builders. Slide 53
HTML Composer
Guided Report Forms
Copyright 2007, Information Builders. Slide 54
HTML Composer
Guided Report Forms
Copyright 2007, Information Builders. Slide 55
HTML Composer
Guided Report Forms
Copyright 2007, Information Builders. Slide 56
HTML Composer
Guided Report Forms
Copyright 2007, Information Builders. Slide 57
WebFOCUS Mobile
Copyright 2010, Information Builders. Slide 58
WebFOCUS Mobile
BrowsersDevice Specific Capabilities
 Device Independence
 http://mobile.ibi.com
 Try it right now!
 Any device
 Simple. Not really much else to say!
Copyright 2007, Information Builders. Slide
59
WebFOCUS Mobile
BrowsersDevice Specific Capabilities
Copyright 2007, Information Builders. Slide
60
WebFOCUS Mobile
Active Technologies Web App
 Active Technologies dashboards & reports provide
embedded analytics & visualization for Android, Apple, RIM &
other devices
 Automatic device detection supports specific devices’
gesturing, touch technologies
 Over 30 HTML5/JavaScript charts with interactivity &
animation properties available
Copyright 2007, Information Builders. Slide 61
WebFOCUS Mobile
Active Reports must be via Browser
WebFOCUS Mobile
Mobile Faves for iPad and iPhone: Native App from App Store
 Core Abilities of app:
 Connect to your WebFOCUS Mobile Favorites server and run any

online WeFOCUS reports, graphs and dashboards
 Save, annotate and catalog WebFOCUS Mobile Favorites BI
documents locally for offline analytic operations
 Subscribe and receive pushed WebFOCUS Mobile Favorites BI
documents automatically
 Open and catalog WebFOCUS BI documents received as email
attachments
 Use native Search abilities to find the BI document you want quickly
Combines values of native app and portable web content
 Single tap access to portable WF BI content
 Auto-login and local user settings
 Native Getting Started tutorials – including imbedded videos
Copyright 2007, Information Builders. Slide
63
WebFOCUS Mobile
Mobile Faves for iPad and iPhone
64
InfoAssist
Copyright 2010, Information Builders. Slide 65
InfoAssit
New Fusion Charts
66
InfoAssit
Slicers – drop downs Filters in embedded in reports
InfoAssit
InfoMini - scaled down “mini ribbons” embedded in reports
InfoAssit
InfoMini - scaled down “mini ribbons” embedded in reports
InfoAssit
InfoMini - scaled down “mini ribbons” embedded in reports
InfoAssit
InfoMini - scaled down “mini ribbons” embedded in reports
InfoAssit
InfoMini - scaled down “mini ribbons” embedded in reports
WebFOCUS 8
Just around the corner
Copyright 2010, Information Builders. Slide 73
WebFOCUS 8
Visual Discoverer integrated with InfoAssist
Copyright 2007, Information Builders. Slide
74
WebFOCUS 8
New BI Portal Initiative
Copyright 2007, Information Builders. Slide 75
WebFOCUS 8
WebFOCUS Enable – Widgets for dashboard and MRE components
Copyright 2007, Information Builders. Slide
76
WebFOCUS 8
Location Intelligence
 ESRI many years now: WebFOCUS 7.7
integrates with ESRI’s Flash-based map
viewer
 Google Maps several years now
 Coming in Release 8:
 Bing Maps: Easily integrate
Bing Maps with WebFOCUS via
standard controls in Developer Studio’s
HTML Composer
Copyright 2007, Information Builders. Slide 77
WebFOCUS 8
New Web Based Metadata Wizard
Copyright 2007, Information Builders. Slide
78
WebFOCUS 8
New Developer Studio – Rapid development, Auto Generation of Guided Ad Hoc Apps
Copyright 2007, Information Builders. Slide
79
Thank you !
Copyright 2007, Information Builders. Slide 80