WebFOCUS 8207.01 Release Notes


The following topic provides all the information that you need to know about this release of WebFOCUS.

Have questions? Click Send Us Feedback (on the right) and we'll be in touch!

Release and Gen Information
Release Date Gen Information WebFOCUS Server
Friday, December 20, 2019 wf121119b Gen 7 8207 gen 1906

 


New Features
Description

Customizing Path for the Getting Started Carousel

You can now configure the Getting Started carousel to point to a different workspace in your repository. This can be achieved by customizing the Default List Repository Path setting in the Administration Console. Update the path to reflect the name of your chosen workspace, save your changes, and reload the Home Page. The top carousel changes to display the workspace
you selected. The title linked to the name assigned to the workspace becomes the new title of the Carousel. The following image shows an example of a custom carousel in the Home view of the Home Page.

Customizing Path for the Getting Started Carousel

Note: If you point to a non-existent workspace or replace the path with a blank space in the Default List Repository Path setting, the Getting Started carousel will not display. You can always restore the default path automatically by clearing the value assigned to this setting, saving the change, signing out and signing back in to reload the Home Page.

Description

User Language Preference

Users can now customize their language preference from the User Menu of the Home Page. Click your user icon in the upper-right corner of the Home Page, click Preferences, and then choose a language from the My Preferences dialog box, as shown in the following image.

User Language Preference

 

Description

Adding Insight-Enabled Charts to a Visualization

When you add an Insight-enabled chart to a visualization assembled from existing content, the Insight icon appears in the upper-right corner of the chart, as shown in the following image.

Adding Insight-Enabled Charts to a Visualization

When you run the visualization and click the Insight icon, the Insight chart opens in a new browser tab and displays the Insight toolbar, allowing you to interact with the chart at runtime with full Insight functionality.

Description

Dynamic Grouping Enhancements

When creating dynamic groups in WebFOCUS Designer using the Create groups and Edit groups dialog boxes, you can use drag actions to modify groups. You can drag one value onto another to create a group with those two values, drag a value into an existing group to add it to the group, drag a group onto an ungrouped value to add the value to the group, drag a group into another group to combine them, or drag a value from one group into another group to move it to that group. You can also now edit a dynamic group field once it has been added to your content by right-clicking it in a bucket, in addition to the field list. These features make it easy to create and edit your dynamic groups.

For more information, see Using Dynamic Grouping for Dimension Field Values.

Description

Changing the Size of the Hole in a Ring Pie Chart

When creating a ring pie chart in WebFOCUS Designer, you can change the size of the hole in the middle, or remove it entirely, giving you more control over the appearance of your chart. When you create a ring pie chart, select the Format tab, and then select Series from the area menu. When All Series is selected, the Hole Size property appears in the Shape section. Set a size, as a percent of total diameter, for the ring pie hole. The total value text inside the hole shrinks or expands to fit in the space. If you set the hole size to 0, the ring pie chart becomes a standard pie chart, with no total value text displayed, as shown in the following image.

Changing the Size of the Hole in a Ring Pie Chart

Description

Field List Expands to First Field

When creating content in WebFOCUS Designer, the field list in the Resources panel now expands to the first available field by default once a data source is selected. If there are multiple nested folders at the top of the business view, they are expanded, by default, one-byone, starting from the top, until the first fields are visible. Additional folders within the last expanded folder are not expanded once fields are visible. This makes it easier to access fields in a data source without requiring the user to manually expand multiple folders, while still keeping most folders closed to avoid the need for excessive scrolling.

Description

WebFOCUS Designer Browser Tab Name

When editing a previously saved visualization in WebFOCUS Designer, the name of the browser tab is taken from the title of the visualization. This makes it easy to identify which visualization is being edited on each tab, particularly when multiple instances of WebFOCUS Designer are open. Prior to saving, a browser tab in which WebFOCUS Designer is running is named Designer.

Description

Using the Outline to Access the Source Syntax of a Single Chart or Report

When creating a new visualization in WebFOCUS Designer, the outline is now available for stand-alone content items. This allows you to view the WebFOCUS Language source syntax of stand-alone content items, which significantly facilitates troubleshooting. Select Outline on the sidebar and right-click the chart or report listed in the outline, then click View source code. The source syntax displays in a read-only text editor. You can copy the syntax, download the chart or report as a .fex file, and search through the syntax using the options on the toolbar. To return to the canvas, click the X in the upper-right corner of the page.

Description

Extended Chart Series Colors for Default Themes

By default, WebFOCUS includes three themes: Designer 2018, Light, and Midnight. These themes specify styling properties for charts, reports, and pages. For charts, one of these properties is a set of series colors. Series colors represent different values of a dimension field added to the Color bucket. When the number of series values in a chart exceeds the number of specified series colors, those colors are repeated in the specified order with increasing lightness applied with each cycle.

To delay the repetition of series colors, additional series color values have been added to each of the default themes, increasing the number of specified series colors from 6 to 12. The following image shows the same chart with 12 series values, using each of the three default themes.

Extended Chart Series Colors for Default Themes

Description

Union, Join, and Select Editors Open as Nearly Full-Screen Windows

In prior releases, the Join Editor, Union Editor, and Select Editor opened as panes on the Data Flow Workspace. Now, they open as popup windows on top of the Data Flow Workspace and are almost full-screen size, as shown in the following image.

Union, Join, and Select Editors Open as Nearly Full-Screen Windows

This provides more room to see and edit the onscreen elements than when they were confined to a small pane on the bottom of the screen.

Description

Limiting the Number of Automatic Join Pairs in Tables Without Keys

When you join files or tables without keys, the join created automatically based on matching field names is now limited to three pairs of join fields, to avoid attempting a join on an excessive number of fields, especially when joining a table to itself. For example, the following image shows the default automatic join pairs for two tables with the same fields.

Limiting the Number of Automatic Join Pairs in Tables Without Keys

You can always add additional pairs or remove pairs, as needed.

This limit does not affect joins on tables with keys, where all of the key fields are joined.

Description

Previewing a File When Uploading

When you upload a file, you can preview the file to make sure that you uploaded the one that you wanted. You can also make some adjustments to the data before loading it to a target, as shown in the following image.

Previewing a File When Uploading

When preparing the data:

  • The headers and sample content are shown. By default, formatted data is shown, with the generated data types identified. You can click the Raw button to see unformatted data.
  • The number of header rows is determined by scanning the file, but it can be changed as required.
  • For an Excel Worksheet, there is an option read the file as a cross-tab.
  • The derived data type is shown for each field. You can change the basic data type.
  • You can, optionally, change or assign a geographic role.
  • A field name is shown for each field, either from the header, when available, or generated as the name FIELD with an index (FIELDx). You have the option to rename the field.
  • You can also change the name of the metadata object (synonym) that is created and, for workbooks with multiple worksheets, choose which ones to load.
  • You can click the More button to access additional file options.

After you load the data, the page that opens has a Preview button, as shown in the following image.

Previewing a File When Uploading

If you click Preview, you open the same preview pane, with the same options that were available in the Prepare step.

You can click Reload, to reload the data, if necessary.

Description

Redesign of Business View Icons

When editing a Business View, the buttons now have icons that are more standard and clear, and are grouped in a more logical configuration, as shown in the following image.

Redesign of Business View Icons

The first group of buttons control the Business View:

  • The Reset Default button (Reset icon)  recreates the default Business View.
  • The Flatten button (Flatten icon) lists all measure fields under a single measure group and all dimension fields under a single dimension, with no children.
  • The Create Template Folders button (Create Template Folders icon) creates empty basic folders when there is no Business View already defined.
  • The Hide All button (Hide all icon) removes the Business View. A Create Default button (Create Default icon) appears so you can create the default Business View.

The second group of buttons provide options for the window:

  • The Display button (Display icon) lets you show Folders and Columns or just Folders, or opens a window with a modeling view of the folders.
  • The Find button (Find icon) opens a search box in which you can enter characters. All component names that contain those characters are highlighted.
  • The Choose Columns button (Choose columns icon) has two options. Choose Columns opens a dialog box for selecting the attributes in the synonym that you want to display. Reset Columns returns the display to the default columns.
Description

New Privilege Allows Users to Create WebFOCUS Designer Content from Business Views

The new Add Designer Content from Business View (opDesignerBV) privilege allows the use of enhanced Business Views as a source for content created in WebFOCUS Designer. This new privilege helps administrators replace the use of direct access to metadata sources stored in Metadata Files with controlled access to metadata through Business Views and Reporting Objects when creating content in WebFOCUS Designer.

Description

Numeric Fields Classified as Dimensions by Default Based on Field Names

When uploading a data file, or when creating a data flow or default Business View, if the name of a numeric field implies that it is more likely to be a dimension than a measure, it is classified as a dimension by default. For example, fields ending with _ID such as ORDER_ID are now classified as dimensions by default.

This allows you to create content that more accurately represents your data.

Description

Using Columns While Selecting a Data Source

The Select Data Source dialog box, which displays when you select data for your visualization in WebFOCUS Designer, now features a column selector. In this dialog box, you can customize the number and type of columns, sort each column by clicking the title, and search for a specific data source. This enhancement is especially useful when you are working with a large number of data sources. An example of the new Select Data Source dialog box is shown in the following image.

Using Columns While Selecting a Data Source

Description

Sample Data Shows Warning Messages

When generating sample data in the Synonym Editor or a Data Flow, if problems occur reading the data, an indicator that there are messages displays on the screen, as shown in the following image.

Sample Data Shows Warning Messages

If you click this indicator, you can see the actual messages, as shown in the following image.

Sample Data Shows Warning Messages

Description

Sampling Shows Warning Messages

When sampling is enabled in a data flow and any errors occur reading the data, a warning indicator displays on the synonym node that has the sampling errors. Hovering over the indicator shows the messages, or a partial list, depending on the length and number of the messages, as shown in the following image.

Sampling Shows Warning Messages

To open a window with the complete list of messages, you can right-click the synonym and click Show Errors, as shown in the following image.

Sampling Shows Warning Messages

A window opens showing the complete list of messages.

The Reports pane also shows the indicator.

If you click that indicator, the message window opens.


Fixes
  • A Stacked Line visualization is not sorted properly when using a date field with the Mrt month format. (190117048)
  • A configuration option is now available to select between Bulk load or WebFOCUS native load (TABLE) for repository archive. (180813120)
  • Implement Hyperstage version 2018.1p1 for Windows to avoid a system reboot when the following error occurs: boost::interprocess::intermodule_singleton initialization failed (191029015, 191104099)
  • A request that contains a fully qualified DEFINE field resulted in an error: FOC003 THE FIELDNAME IS NOT RECOGNIZED: SEGMENT.FIELDNAME (190723037)
  • JSON array notation is not set when ACCESS_PROPERTY=(ARRAY_ITEM) is set in the Metadata and proper statements are sent in the request. Support has been added for handling single quotation marks in the JSON sample within Document Sample for Create Synonym. (191028106)
  • Running a dashboard that submits multiple requests against a Vertica database can result in a JSCOM3 crash due to the number of concurrent requests to the Vertica JDBC driver or JVM. (191004040)
  • Creating the default Business View for an OData synonym removes the REFERENCE= key when the synonym is saved. (191016029)
  • Issues occur when trying to use the adapter for Presto with SSL. (191023162, 200429022)
  • If a filter control on the page requires a default value that begins with leading zeros, the leading zeros are not saved, causing the filter not to work correctly in some situations. For example, if an employee ID is an A10 field, and the control is set with a default value of 00000100, only 100 will be saved. (190917022)
  • The entered titles in a Designer page are not shown if the page is stored in a folder which contains a German Umlaut like ä ö or ü. (191104075, 191209013, 191202174, 191205055, 191129028)
  • A warning message is not thrown when exiting a page after JavaScript or Cascading Styling Sheet is changed. (191118034)
  • When creating a DEFINE field that has a new line that starts with an asterisk (*), if that character is added using the shift-8 key on the computer keyboard, rather than using the asterisk (multiplication) from the keypad in the Define tool, the second line, beginning with the asterisk, is removed if you save and reopen the procedure. (180427017)

Upgrade Notes

This version of WebFOCUS is for new application and development only. 


Known Issues
  • The canvas of WebFOCUS Designer for this release is an interactive canvas based on AHTML. When creating a report, page and row break settings are not supported on this canvas for this release. If you select any other output format, such as HTML, PDF, PPTX, or XLSX, you will see these breaks at runtime. These output format options are available for stand-alone content items only. This will be resolved with the introduction of the non-interactive
    document canvas in a future release.
  • When an Insight-enabled chart created in the 8207.00 version of WebFOCUS Designer is added to a visualization as external content, the Insight icon does not appear on the chart when the page is run, so Insight features cannot be accessed. Resave the chart in WebFOCUS Designer 8207.01 or later to make Insight available when the chart is added to a visualization.
  • When working with the Cell menu in an interactive report, the filtering functionality does not work as expected.
  • When saving an artifact (from or of and interactive report, chart or dashboard), the output file name is ARsave.html rather than ARhtml.html.
  • If you create a report or chart in ARVERSION=2 (In-Document Analytics) and you set the output format to PDF Analytic Document, an error occurs when you run it. If you change the option in Procedure Settings to Legacy, the report or chart is produced correctly.
  • If you are working with an In-Document Analytics chart in landscape mode on an Android mobile device and you switch to portrait mode, your content displays in fullscreen mode. Your chart displays at the bottom. If you run your content in new window mode, your In- Document Analytics chart does not display in fullscreen mode, displaying the chart on the right.
  • HIDENULLACRS, which hides across columns that have null or zero values in the entire column, is not supported with interactive content using the new Designer style of In- Document Analytics capabilities.
  • If you add an existing ARVERSION=1 report to an AHTML document set to ARVERSION=2, it fails at run time, displaying JSON text on the screen instead of the expected report output.
  • If you are working with a procedure (.fex) and you change the ARVERSION to ARVERSION=2, global filters do not display when you run the procedure.
  • Fully-developed content sharing capabilities are not available in release 8207.
  • In a scatter plot chart or bubble chart, multiple measure fields on the horizontal and vertical axes generate separate axes, resulting in a grid of scatter plots for each combination of measure fields. In WebFOCUS Designer, if you create a scatter plot chart or bubble chart with multiple measures in the Vertical or Horizontal buckets, only the axis for the first measure in each bucket displays on the canvas. When you run the chart, all measure fields in the Vertical and Horizontal buckets are shown as separate axes, as intended.
  • Both the db_collation.sh file and the db_collation.bat file generate the "Main WARN Error while converting string [] to type," error message in the Command Prompt window at the end of their run. This message has no impact on the functionality of this post-installation utility, and it completes the run successfully.
  • The load_repos.sh file generates the "WARNING: sun.reflect.Reflection.getCaller Class is not supported. This will impact performance," error message in the Command Prompt window at the end of its run. In addition, the db_inplace_update.sh, WFReposUtilCMDLine.sh, and update_repos.sh files generate the "Main WARN Error while converting string [ ] to type," error message in the Command Prompt window at the end of their run. These messages have no impact on the functionality of these post installation utilities, and each one completes its run successfully.

System Requirements

This release is now certified and has been tested with Google Chrome version 78, Firefox Quantum version 70, and Microsoft Edge version 44. For additional browser details, see Browser Information