Transcription
WebFOCUS Release GuideRelease 8.2 Version 01 and HigherJuly 23, 2019
Active Technologies, EDA, EDA/SQL, FIDEL, FOCUS, Information Builders, the Information Builders logo, iWay, iWaySoftware, Parlay, PC/FOCUS, RStat, Table Talk, Web390, WebFOCUS, WebFOCUS Active Technologies, and WebFOCUSMagnify are registered trademarks, and DataMigrator and Hyperstage are trademarks of Information Builders, Inc.Adobe, the Adobe logo, Acrobat, Adobe Reader, Flash, Adobe Flash Builder, Flex, and PostScript are either registeredtrademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.Due to the nature of this material, this document refers to numerous hardware and software products by theirtrademarks. In most, if not all cases, these designations are claimed as trademarks or registered trademarks by theirrespective companies. It is not this publisher's intent to use any of these names generically. The reader is thereforecautioned to investigate all claimed trademark rights before using any of these names other than to refer to the productdescribed.Copyright 2018, by Information Builders, Inc. and iWay Software. All rights reserved. Patent Pending. This manual, orparts thereof, may not be reproduced in any form without the written permission of Information Builders, Inc.
Contents1. WebFOCUS Release Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7Functionality . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7Browser Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Web Browsers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88.2.x Notes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9Mobile Browser Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10Accessibility Compliance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12WebFOCUS Client Supported Operating Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12WebFOCUS Support Statement for Java 2 Platform, Standard Edition (J2SE) . . . . . . . . . . . . . . . . . 13WebFOCUS Application Server Minimum JVM Version Requirement. . . . . . . . . . . . . . . . . . . . .14Supported RDBMS and Drivers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Supported Web and App Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16WebFOCUS SOAP Web Services Minimum Axis Version Requirement . . . . . . . . . . . . . . . . . . . . . . . .16Localization (NLV) and NLS Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16National Language Support (NLS) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17Localized Version Support (NLV) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17WebFOCUS and Reporting Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17WebFOCUS Client and ReportCaster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20App Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21WebFOCUS Open Portal Services - Supported Portals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21Release, Gen Maintenance, HotFix Availability Information WebFOCUS Client and App Studio . . 21WebFOCUS Reporting and Microsoft Office Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22WebFOCUS Reporting Formats and Microsoft Product Association. . . . . . . . . . . . . . . . . . . . . 23WebFOCUS EXL2K and PPT Formats and Microsoft Office Suite Support. . . . . . . . . . . . . . . . 23Microsoft Office 2003 Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24WebFOCUS EXL2K and PPT Formats and Microsoft Office Viewer Products Support. . . . . . .24Usage Consideration When Using Hyperlinks to Run WebFOCUS Reports . . . . . . . . . . . . . . . 24WebFOCUS DOC Format. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Recommended Reading. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25Additional Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252. WebFOCUS 8.2.01 and Higher Release Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . 27Active Technologies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27WebFOCUS Release Guide3
ContentsSupport for a Floating-Point Value on a WHERE Filter. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Menu Update. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28Coordinated Fields and NOPRINT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Title for Coordinated Field Drop-Down List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28App Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Installation and Configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28Environments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Messages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33HTML Page Migration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33HTML Canvas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Report Development. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38Business Views Plus (BV ). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44Business Intelligence Portal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44Managed Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45WebFOCUS Charts and Graphs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45HTML5 Upgrade. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45WebFOCUS Graph API Upgrade. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46WebFOCUS Embedded Business Intelligence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47InfoAssist . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47General Enhancements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47Enhancements to Charting. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48Magnify Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50Lock Files Remain in Lucene Version 4. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50ReportCaster . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50WebFOCUS Infrastructure and Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51WebFOCUS Language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58Change to Default Processing of Joins to Flat Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58Expression Handling: Rounding With Internally Used Packed Fields. . . . . . . . . . . . . . . . . . . . .58Raised Limit for RECAP Phrases in Non-FML TABLE Requests. . . . . . . . . . . . . . . . . . . . . . . . . 59Conversion of Alphanumeric Strings to Numbers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59Change to Use of Prefix in JOIN AS Commands. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60Report With Data Visualization Bar Graphs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 624Information Builders
ContentsUpgrading HTML Pages for Modern Browsers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Converting WebFOCUS StyleSheet Syntax to CSS Tags. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Document Type Designation to Identify Browser Mode. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .65Change to AnV Fields When Output to a Delimited Format. . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Changes to the HTMLEMBEDIMG and HTMLARCHIVE Commands (HTML/DHTML). . . . . . . . 66DHTML Output Format. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Change to ACROSS Column Limit. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Enhancement for JPG Compression. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66Changes to Report Backcolor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Change to the HTMLCSS Command (HTML/DHTML). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Enhancement to the SET EXTENDNUM Command. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Numeric Precision in XLSX Workbooks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69XLSX FORMULA and EXL2K FORMULA. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70Locale Settings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Conditional Styling With Borders. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Error Messages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .71DST. With NOPRINT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Execution of Compound Reports. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Changes to Default MATCH FILE Processing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Using &Variables as Dialogue Manager Labels. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Change in Results With WHERE TOTAL, Multi-Verb, and MAX. . . . . . . . . . . . . . . . . . . . . . . . . .72NATVFLG 2 causes VALIDATE error . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72WebFOCUS Release Guide5
Contents6Information Builders
Chapter1WebFOCUS Release InformationThis topic describes relevant release information for WebFOCUS Release 8.2 Version 01and higher.In this chapter:FunctionalityBrowser InformationWebFOCUS Client Supported Operating SystemsWebFOCUS Support Statement for Java 2 Platform, Standard Edition (J2SE)Supported RDBMS and DriversSupported Web and App ServersWebFOCUS SOAP Web Services Minimum Axis Version RequirementLocalization (NLV) and NLS LimitationsWebFOCUS Open Portal Services - Supported PortalsRelease, Gen Maintenance, HotFix Availability Information WebFOCUS Client and AppStudioWebFOCUS Reporting and Microsoft Office SupportAdditional ResourcesFunctionalityThe following is a functionality support limitation in WebFOCUS Release 8.2 Version 01 andhigher:Accessibility - support limited to HTML and PDF formats. For additional information, seeAccessibility Compliance on page 12.The following functionality is supported as of WebFOCUS Release 8.2 Version 01M (May2017):App Studio Source ControlWebFOCUS Release Guide7
Browser InformationMagnifyOpen Portal ServicesPlease also review the WebFOCUS 8.2 WebFOCUS and App Studio Consolidated Featuresstate
See the WebFOCUS Release Notes for detailed information on known issues and documentation updates. See WebFOCUS 8.2.01 and Higher Release Considerations on page 27 for detailed information on expected functionality changes and configurations required for some product features. For information regarding earlier releases, see the Technical Support page. .
