Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Yellowfin 9.7.2 enhances the Guided NLQ and  and includes updates on the EULA. In addition, this release addresses some outstanding functionality issues.

...

Expand

Views

  • Improved the default text that appears in Guided NLQ when no views are available.

Infrastructure

  • Updated EULA documents.

Reports

  • Added an option for users to receive the results of Long Running Reports to their email as PDF, CSV, DOCX, or XLSX files

Fixes

Expand

Infrastructure

  • Resolved a potential Out of Memory error that could occur when upgrading to Yellowfin 9.7.
  • Upgraded Xstream from 1.4.18 to 1.4.19 to improve security.
  • Removed a duplicate, deprecated version of Backbone.JS library.
  • Upgraded the object-path library from version 0.11.5 to 0.11.8, which includes security fixes.
  • Upgraded the TwelveMonkeys ImageIO library from version 3.6 to 3.8.1, which includes security updates.
  • Upgraded TinyMCE to version 5.10.3.
  • Resolved an issue that would allow the last user of a role marked as Mandatory to be deleted.
  • Improved session logic to delete expired sessions in clustered and non-clustered environments.
  • Resolved an issue where a previously deleted LDAP user would not be accounted for in licensing counts if reinstated.
  • Upgraded PostgreSQL JDBC driver 42.2.14 to version 42.3.3 which includes security fixes.

Roles & Groups

  • Resolved an issue where the Draft User Group could not be deleted.

Reports

  • Resolved an issue that would cause the per-field Column & Row Headings formats to override those set-in report-wide formats, even if they were disabled.
  • Resolved an issue where switching between tabbed co-display reports would prevent reports from automatically updating.
  • Resolved an issue that would import only one Freehand query filter with a report containing two or more Freehand query filters with different data sources.
  • Resolved an issue that would cause a report to break when a Freehand SQL calculated field was used in the master query of an Intersect Sub Query.
  • Resolved an issue where using the Edit Details option from the Browse page to update a report name would break the link between the report and the parent view.
  • Resolved an issue that would prevent linked reports from exporting during a dashboard export.
  • Resolved an issue that would prevent the timezone converter from being applied to timestamp values is in Min/Max aggregated columns.
  • Resolved an issue that would cause some co-display reports to load without tabs if they had been previously loaded in the same report.
  • Resolved an issue that would return incorrect aggregations for Count, Count Distinct, and Average when used with Sparkline/Roll Up analytic functions.
  • Resolved an issue that would cause Jasper reports to print only the first page of a report.
  • Resolved an issue that would limit report sharing options to a link or PDF format only.
  • Resolved an issue where switching off the Display Empty Values column setting would prevent a cross-tab report from displaying any results.
  • Resolved an issue where the translations for folder and sub folder names in the Report Details dialog box would not display.
  • Resolved an issue that would not let a user validate a unique report name from the Edit Details dialog box of the Browse window.

Content Export

  • Resolved an issue where using a guest role without credentials to export to PDF would fail.
  • Resolved an issue where exporting an ETL process with input steps containing internal filters would cause an NPE error.
  • Improved the run time for printing reports via the Print Export dialog box.

Filters

  • Resolved an issue where applied filters would not persist on a dashboard if the user had previously navigated to a dashboard with a Left Nav filter panel.
  • Resolved an issue where using linked filters with a Freehand SQL view would prevent filter prompts from loading values.
  • Resolved an issue that would prevent Guided NLQ output from be restricted by any default access filters for users without the Access Filter role function.
  • Resolved an issue that would cause fields in view-level filters to appear multiple times in the Security Settings dialog box.
  • Resolved an issue that would cause date filters with the Pre-defined Period option enabled to lose their value upon adding or removing fields.
  • Resolved an issue that would omit report content in emails sent for long-running reports with access filters applied.
  • Resolved an issue that would cause duplicate cached filter values.

User Interface

  • Resolved an issue that could cause Drill Through popups to display at the wrong size.
  • Resolved an issue that would prevent some fonts from displaying when used in the Row & Column Headings column formatting option.
  • Resolved an issue that would cause an empty popup box when running a Signals job in a client org.
  • Resolved an issue that would prevent the input field in the Calculated Field Builder from clearing after use.
  • Resolved an issue where a theme created in a client org would appear in when logged in to other client orgs or the primary org.

Dashboards

  • Resolved an issue that would display usernames subscribed to Dashboard or Present content to guest users.
  • Resolved an issue that would prevent dashboard sub-tabs from scrolling when embedded.
  • Improved the text description for Default Dashboard Tabs on the User Group dialog box.
  • Resolved an issue where image widgets in dashboards and presentations would not be named by their uploaded image filename.
  • Resolved an issue that would cause a Null Pointer Exception when a user tried to load /PreDashboard.i4 after their session had expired.
  • Resolved an issue that would prevent filter values from being passed when drilling through to a dashboard.
  • Resolved an issue that would prevent the Dashboard Properties box from displaying the Apply Button Location option when a filter was set to Left Filter.
  • Resolved an issue that would cause the "Omit" and "Default Child Value" options to behave incorrectly when drilling through to a dashboard.

Signal

  • Resolved an issue that would cause an exception log message when sharing a Signal.
  • Resolved an issue where the Signal Analysis Run Time Taken would be Unknown and Status would still be shown as Running after the run has finished.

Charts

  • Resolved an issue where pie charts would not use the custom legend shape.
  • Resolved an issue where the first label to be rendered on a raster map would not show for a small area if the legend was turned off.
  • Resolved an issue where brushing over a time series chart area that did not include the full series would cause an error.
  • Resolved an issue where dimension tooltip values in cross tab charts would not be used for drill through links.

Imports

  • Resolved an issue that would prevent a transformation flow from being imported.
  • Resolved an issue that would prevent the get-import-content object from returning resourceCode for sub-folders in REST or SOAP calls.

Guided NLQ

  • Resolved a cache issue that would prevent predefined date periods from updating in Guided NLQ when changing the Financial Year Start Date date field.
  • Resolved an issue that would prevent field values from populating the NLQ dropdown fields.

Views

  • Resolved an issue that would cause the View Builder to automatically add unnecessary folders without any fields.

JS API

  • Resolved an issue that would prevent the internal JS API from loading stories correctly.

...

Expand

Infrastructure

  • Improved system performance when creating large presentations.
  • Optimized loading times for the Browse page by refactoring how restricted table columns are queried.
  • Improved how dashboards and presentations handle unknown widget types (eg, invalid data in the configuration database or when a dashboard or presentation is imported and the widget's plugin is not loaded in the target instance).
  • Upgraded the Log4j library to version 2.17.1.
  • Upgraded Apache XMLSec library to version 2.2.3.

Data

  •  Added database capabilities (0=1 and LIMIT) in queries when using CacheDB as the data source.

REST API

  • Added a RoleCode response value to the api/user/{userId} REST API request.

Views

  • Added a new Field Properties option for views in the browse page (learn more).
  • Enabled support for Optimized Views when retrieving available values for Grouped Data fields.

Content export

  • Added a ‘Keep Formatting’ option for XLSX exports.

Filters

  • Added horizontal filters as a new filter list widget type for dashboards and presentations, using dropdowns.
  • Added the option of using one or more whitespace characters as filter values for the Report InList filers.

Dashboards

  • Restored dashboard report refresh scheduling and report loader options for customizing, animation, color overlay, and overlay message. 

Reports

  • Added currency formatting options for reports.
  • Added formatting options for sub-total, section total, and grand total rows for column-based reports.
  • Added the ability to style individual column headers in a report.

Advanced functions

  • Added the ability to toggle between absolute and relative difference for the advanced function, Months to Now.
  • Reverted the default settings for the advanced function, Top/Bottom N Percentage of Total, to match earlier versions.

User Interface

  • Added the ability to delete a filter container from the global dashboard area using the Delete key.
  • Improved the display of the Guidelines fields in the Dashboard Properties panel.
  • Improved the field text labels for the Growth Truncate advanced function.
  • Added a Close button to the top of published presentations (learn more).
  • Enabled the ability to rename a presentation slide by double-clicking its name in the canvas editor (learn more)
  • Updated the options available on the Publish dialog box in the View Builder.
  • Added a scroll bar to the filter list on the view level Filter Formatting settings page.
  • Updated the Field Permissions field label within the View Builder.
  • Improved the buttons on the popup that appears when a user tries to edit a view concurrently.
  • Updated the sort sequence of chart drill through links to match the Related Content tab.
  • Improved the content of the decision help text displayed when typing a Guided NLQ query.
  • Changed "Financial Week" to "Business Week" (learn more) and NLQ no longer filters out "Business Week" when financial date periods are the same as calendar date periods.
  • Updated the incorrect wording on warning message popups from ‘dashboard’ to ‘presentation’.
  • Resolved a JasperReports pagination issue.

Translations

  • Corrected some Japanese language translations for view security options.
  • Provided language translations for the text label "Filters" in the Automation Settings dialog box.

...

Expand

Infrastructure

  • Resolved an issue that would keep a LDAP user in a Yellowfin group after being deleted on the host.
  • Resolved an issue that would create multiple user accounts if a new user logged in via LDAP multiple times in succession.
  • Resolved an issue that would prevent a super user from being able to edit a draft of a private report.
  • Resolved an issue that would prevent a report from being deleted if it had been manually removed from the database.
  • Resolved an issue with password case sensitivity for the administrator user created during installation.
  • Resolved an issue that would prevent reports from being deleted in a batch selection when Share Private Content was turned off for the user's role.
  • Resolved an issue where a personal content creator could create public reports with the "Save As" function.
  • Resolved a potential security issue that could expose access to Yellowfin pages if a user visited the reset password page.
  • Resolved an issue that would cause users to retain access to dashboards after being removed from a user group until the instance was restarted or the caches were cleared.
  • Resolved an issue that would prevent user group membership changes from being applied to group hierarchies in client organizations.
  • Resolved an issue that would reset view security permissions when editing the View Security settings.
  • Resolved an issue with some instances of nested groups where group membership would not be calculated correctly.
  • Resolved an issue that would let some users without Update or Delete rights see content via Guided NLQ queries for views with Read Restricted or Edit Restricted settings.

Logging

  • Resolved an issue where deleting a broadcast from a report would not create a record in the Event database table.
  • Resolved an issue that would incorrectly add an NPE error to the log file when a user with specific role functions opened a report.
  • Resolved an issue that would cause an incorrect IpSource value to be written to the Events table when accessing a dashboard via the JS API.

Installer

  • Resolved an issue that would cause updates to fail when using the silent installer to upgrade from versions 8.0.10.3, 8.0.10.4, 9.7.0.2 and 9.7.0.3.
  • Resolved an issue where setting a custom installer.warfilename in the custom.properties file would prevent a Yellowfin 9.7 installation from completing.

Data

  • Resolved an issue where MySQL Connector 8.0 would return all available tables rather than just the tables available in the selected database.
  • Resolved an issue that would cause SAML SSO to stop functioning — if it was set up in Yellowfin 9.6 without the Service Provider Private Key and Certificate — by making the two fields optional (learn more).

Imports

  • Resolved an issue that would omit translations for calculated fields during report import.

REST API

  • Resolved an issue with the GET /categories endpoint in the REST API 1.3 returning incorrect parentCategory links.
  • Resolved an issue that would cause version 1.2 REST API category requests to return results for version 1.3.

JS API

  • Resolved an issue that would prevent images from loading on the Guided NLQ UI when passing an element to the JS API loadNLQ function.

Web Services

  • Resolved an issue where the DELETECATEGORY web service would not delete a sub-folder.
  • Resolved an issue that would prevent SSO from working correctly in some circumstances due to an existing web session.
  • Resolved an issue that would prevent the SOAP web service from exporting using the new PDF exporter.

Views

  • Resolved an issue that would prevent a user from editing a CSV view if a date function was added to the view and saved.
  • Resolved an issue that would prevent drill through creation on reports based on a copied view.
  • Resolved an issue with the date functions Week Start, Week End and Week of Year each being out by a day when applied to Sundays when using PostgreSQL or Redshift.
  • Resolved an issue that would cause an error when copying a freehand SQL view from the view’s Model page.
  • Resolved an issue that would cause reports based on cached Freehand SQL views to fail.
  • Resolved an issue with CacheDB that would prevent returning data from a view created from a stored procedure.
  • Resolved an issue that would prevent some views from being copied or exported.
  • Resolved an issue that would prevent Last Modified details for a view from being recorded unless specific changes were made to that view.

Content Export

  • Resolved an issue that would prevent reports with cached filter hierarchies from being exported.
  • Resolved an issue that would prevent shrink to fit from working on reports with a chart or canvas to the left or right of the report table.
  • Resolved an issue that would prevent filter values from being applied on a tabbed child report when exporting to XLSX.
  • Resolved an issue that would prevent XLSX exports from opening in MS Excel if they were based on JasperReports-based reports.
  • Resolved an issue that would cause the slow export of reports with conditional format icons.
  • Resolved an issue that would prevent action buttons on a canvas dashboard from maintaining their size when being exported to PDF.
  • Resolved an issue that would cause PDF page size issues when exporting JasperReports-based reports.
  • Resolved an issue that would fail to render SVG images in JasperReports-based reports.

Broadcasts

  • Improved the broadcast schedule to use the data source timezone as the default for reports, and the system's default timezone for dashboards (which may contain reports with different timezones).
  • Resolved an issue where using mandatory filters in reports would disable the feature of advanced broadcast recipients.
  • Resolved an issue where one or more mandatory filters with no default value would prevent the Current Filter Values option from being selected in a report broadcast.
  • Resolved an issue where bookmarks could not be used as filters in report broadcasts.
  • Resolved an issue that would cause a report broadcast to fail when a timestamp field was used as a filter.
  • Resolved an issue that would prevent broadcast delivery rules from functioning correctly if a timestamp field contained a date.
  • Resolved an issue where private reports would not broadcast to validated users.
  • Resolved an issue that would prevent the Different From broadcast delivery rule from functioning correctly.

Dashboards

  • Resolved an issue that would prevent dashboards with interaction links from being re-imported when using the "Replace Existing" option.
  • Resolved an issue where a canvas with missing report fields would not load in edit mode.
  • Resolved an issue where creating a new story widget, then undoing its creation, then redoing its creation, would display an incorrect layout.
  • Resolved an issue that would cause formatted action links to append the primary org ID instead of the client org ID.

Reports

  • Resolved an issue where applying conditional formatting rules to the Total field would inadvertently apply them to the main report.
  • Resolved an issue that would cause an error when configuring Link To relationships for a drill through report.
  • Resolved an issue that would prevent drill through to a child report when the parent report filters contained null values.
  • Resolved an issue when building dashboards that would prevent branched reports from having different interaction settings from their parent report.
  • Resolved an issue that would prevent a report created from a view with Edit Restricted enabled from being deleted.
  • Resolved an issue where, after selecting and adding a value on the calculated field "Current day +/- X days”, the value displayed on the page would not be updated.
  • Resolved an issue that would prevent valid users from editing a report if an access filter without any values was applied.

Guided NLQ

  • Resolved an issue that would prevent Guided NLQ answers from being saved as reports when the Unique Report Names setting was switched on.
  • Resolved an issue that would cause the Guided NLQ Ask tool to be cut off during an animation.
  • Resolved an issue where a user could run a Guided NLQ query with an incomplete Where block.
  • Resolved an issue that would prevent calculated date fields from being enabled for Assisted Insights and Guided NLQ.
  • Resolved an issue where updating the Granularity option of an associated date field in a Guided NLQ query could prevent the user from completing the query.

Filters

  • Resolved an issue that would prevent filters from showing up when opening a report from the Open Report sidebar button.
  • Resolved an issue that would cause the Dynamic Filter option to erroneously appear on a view-level filter.
  • Resolved an issue that would cause a cached filter to contain unexpected values when an access filter was enabled in the main query and subquery.
  • Resolved an issue that would prevent the Not In List filter from functioning correctly with timestamps.
  • Resolved the issue where filters set to Cached On Demand would not load values unless they had been manually refreshed.
  • Resolved an issue that would cause a date filter with Max or Min aggregation to display the filter format options for numbers.
  • Resolved an issue that would prevent wildcard access filters from working correctly in OLAP-sourced reports.
  • Resolved an issue that would prevent minimum and maximum options from appearing in the list of values for a dashboard filter even though they appear in the original report's filter
  • Resolved an issue that would cause filters to be marked as unavailable after deleting the filter list to which it previously belonged.
  • Resolved an issue that would not pass values to a child report if the parent and child filter entry types were not the same.

Charts

  • Resolved an issue where pie charts would display incorrect colors if a metric was used as a colour.
  • Resolved an issue that would cause inconsistent results when exporting JavaScript charts containing SVG masks.
  • Disabled trends for stacked area charts due a third-party library issue.
  • Resolved an issue where charts would not render if the legend was too large.
  • Resolved an issue that would cause radar charts to display a reference line label after enabling the Hide Label option.
  • Resolved an issue with the Histogram Auto Binning feature that would cause some values to go missing when outliers were present.
  • Resolved an issue that would prevent a pie chart from displaying if the Explode Slice setting was selected.

User interface

  • Resolved an issue that would prevent the Create menu from functioning when set to display in the Left Side Navigation panel.
  • Resolved an issue that would cause the minus sign on a value to appear as a suffix when used with bar conditional formatting right align.
  • Resolved an issue with field conditional formatting rules where typing any decimal number starting with “-0.” would automatically remove the minus sign.
  • Resolved the issue where tasks from deleted discussion streams would no longer be actionable.
  • Resolved an issue that would prevent the ‘Suppress’ drill through popup option in Content Settings from functioning correctly.
  • Resolved an issue that would cause the report tab selection to shift when drilling down.
  • Resolved the issue where sub queries would be listed as drill throughs on the pop-up warning message that appears when a user tries to delete a report.
  • Resolved an issue where filter values containing certain symbols would not be passed through correctly as part of a dashboard drill through.
  • Resolved an issue that would cut off the Drill Anywhere popup when the linking field is close to browser’s window edge.
  • Resolved an issue that would hide report editing options on the Browse page for users with edit access.
  • Resolved an issue that would cause a system error when maximizing a Report Snapshot or Report Bookmark popup from the discussion stream.
  • Resolved an issue where translation text would be inadvertently displayed when multi-language was enabled.
  • Resolved an issue with stories where users’ long job titles would push down the position of the Like button.
  • Added input validation to the First and Last Name fields under Profile Settings.
  • Improved the display of license information on the license page.
  • Resolved an issue that would prevent the dropdown list of user groups from displaying.
  • Resolved an issue that would cause the ‘Above’ Page Slider option to display both above and below a report.
  • Resolved an issue that would prevent dashboard and presentation widgets selected as a group from being duplicated.
  • Resolved an issue that would cause keyboard commands in dashboard and presentation edit modes to stop working after their initial execution.
  • Resolved an issue that would display an unnecessary warning message when sharing a dashboard or report with JavaScript Charts.
  • Resolved an issue that would prevent freehand SQL reports from being displayed in advanced search results on the Export page.
  • Resolved an issue where refreshing a filter’s custom query in an appended query would delete the associated SQL.
  • Resolved an issue that would prevent locale-based sorting from being configured for client organizations.
  • Resolved an issue that would cause a blank space to appear at the bottom of report tables on dashboard table widgets.
  • Reinstated the "Related" checkbox from Automated Insights Setup and moved it to the Automated Settings dialog box.

Signals

  • Resolved an issue where importing views with "Replace Existing" enabled would not replace the related Signals jobs.
  • Resolved an issue that would prevent charts from loading in Signals.
  • Resolved an issue that would cause the Spike/Drop/Breakout signal to show on daily basis even if its granularity was set to be higher (eg, hourly).

Assisted Insights

  • Resolved an issue that would prevent users from selecting the maximum number of fields (12) for Assisted Insights.

Mobile

  • Resolved an issue with the styling of the report filters popup on the mobile app.

...

Expand

Infrastructure

  • Added a toggle to the Admin Console to enable Guided NLQ for each client organization (learn more).
  • Added new silent installer options MySQLDisableSSL, DatabaseConnectionString and AdminDatabaseConnectionString.
  • Upgraded require.js to version 2.3.6.
  • Upgraded the jsoup library to version 1.14.2.
  • Upgraded the Apache XML Graphics Commons library to version 2.6.
  • Upgraded the Apache Commons Compress library to version 1.21.
  • Upgraded the Apache log4j library to version 2.16.0.
  • Upgraded PDFBox libraries to version 2.0.24.
  • Upgraded the ClassGraph library to version 4.8.116.
  • Upgraded the XStream library to version 1.4.18.
  • Added a tool to update repository configuration values when Yellowfin is not running.
  • Added an advanced configuration option to customize the broadcast filename format.
  • Improved access permissions checking performance when loading content on the Browse page.
  • Improved session security for active users which redirects to the login page after an allotted time, unless user input is detected.

Roles & groups

  • Added new Guided NLQ role functions Guided NLQ User and Guided NLQ Manager (learn more).
  • Enabled Guided NLQ functions for roles with access to creating and updating reports, and updating views.

Data

  • Added ClickHouse DBMS support, including LIMIT support to Clickhouse DB queries, and enabled Clickhouse UUID columns to be identified and used in Yellowfin (learn more).
  • Added LIMIT support to Vertica sources.
  • Added support for RSA and ECDSA algorithms for JWT authentication.
  • Enhanced SSO for JWT and SAML to support dynamic sessions entry options (learn more).
  • Aligned the existing SAML Bridge features with the more recent SAML implementation, including SP-initiated SAML workflow (learn more). 

JS API

  • Added the 'Ask a Question' UI of Guided NLQ as an embeddable object via the JS API (learn more).
  • Added functionality to allow namespaces for events on JS API objects.
  • Added the ability to unbind event listeners via the event name function in the JS API.
  • Added functionality to LoaderEvents to allow listening for specific elements (learn more). 
  • Added the ability to override child loaders for individual reports, replacing them with a singular loader for the parent element.
  • Added loading status indicators for content loading via the JS API.
  • Implemented the ability to listen to and prevent drill through report interaction events via the JS API.
  • Added the ability to manually configure the display of a drill through child report toolbar via the JS API.
  • Added the option to display chart animations via the JS API (learn more).

REST API

  • Added a new report listing endpoint.
  • Added a favorite reports endpoint.

Views

  • Enhanced view exports to include Guided NLQ configurations, and added a warning when importing Yellowfin 9.7 views into older versions.
  • Added predefined date periods Last Quarter and This Quarter to Date.
  • Overhauled the look and feel of the view builder, and added new options for configuring performance, security, and automation.
  • Improved database validation functionality which reduces overall processing times when cloning views.
  • Replaced the word “business” with “financial” in predefined filter date period labels, and removed the word "calendar" from other predefined filter date period labels.

Advanced functions

  • Added a number of advanced functions including:
    • SPC - Functions (moving average, UCL, LCL, outliers).
    • SPC Step Change.
    • Difference and Growth Truncate.
    • Top/Bottom N Percentage of Total.
    • Top/Bottom N Rank.
    • Periodic Average.
    • Percentage Against Accumulative Column.
    • Accumulative Percentage Against Column.
    • Days Between Date with Offset.

Content export

  • Added a configuration option to customize default settings for export plugins.
  • Enabled URL hyperlinks when exporting crosstab reports to XLSX format.
  • Improved the display of presentations on PDF exports.

Reports

  • Added the ability to create an Append sub query joined to a report on view fields not used in the report (learn more).
  • Added conditional bar formatting support for cells with negative values.
  • Enhanced the report pagination links.

Charts

  • Added Average, Accumulation and Trend functions to several non-auto area, bar, and column charts.
  • Added the option to rename the total column on a waterfall chart (learn more).
  • Enhanced functionality for waterfall charts by adding a Start column to indicate the starting position of the chart (learn more).
  • Added a color field to waterfall charts (learn more).
  • Updated the default chart colors for new installs.
  • Improved the display of line charts by setting a default order for line shapes used to highlight data points in a series.
  • Resolved an issue that would prevent a combined series trend line from activating for auto horizontal bar charts with the same category and color dimensions.
  • Streamlined chart variance display options and added Simple Percentage as a new chart variance type (learn more).
  • Improved the display of charts with borders on dashboards.

Broadcast

  • Added a new function to allow plugins to filter out email addresses before they are sent by Yellowfin.
  • Improved functionality which prompts the user to retain or cancel a scheduled task when running the task manually on the same day it is scheduled.
  • Improved report broadcast scheduling to include the status of the report in the event of an error.

User interface

  • Added a Guided NLQ entry point to the Create menu in the main toolbar (learn more).
  • Added the component Guided NLQ to the Licence Management page.
  • Improved Code Mode to take full advantage of the JS API (learn more).
  • Added an Open Report button to reports on published Stories which directs the user to the report's output page (learn more).
  • Renamed the Add Filters button on the Filters pop-up to Save (learn more here and here).
  • Restyled the default Yellowfin login page.

Localization

  • Added support for language-specific separators for decimals and thousands when using numeric filters.

...

Expand

Infrastructure

  • Added the advanced configuration option SHOWLOWMEMORYEXPORTOPTION, which adds a toggle to the Export Settings dialog box for individual reports to override the global setting for low memory exports.
  • Resolved a configuration issue with upgrading Java from pre-July 2021 to a post-July 2021 version that would cause the yellowfin.war file to be redeployed, losing custom changes to the web application.
  • Resolved an issue that would cause GroupCache removal messages to be delivered to cluster nodes with incorrect data.
  • Resolved an issue that would cause Yellowfin WAR file redeployment when upgrading from certain versions of Java.

Performance

  • Improved import page load times for systems with a large number of content folders.
  • Improved loading times when entering export and import pages.
  • Improved loading times when expanding the User and Group sections of the Admin Console.
  • Improved rendering on the Browse page for users with access to a large number of folders.

Data

  • Enabled the recognition of Snowflake database table timestamp fields with time zones.
  • Resolved an issue that would prevent third-party database connectors from loading data.
  • Resolved an issue that would prevent a replacement database from importing as the correct database type when a license limit had been reached.
  • Extended the ReferenceDay table to include dates up to the year 2030.
  • Resolved an issue that would prevent the creation of views based on Intersystem IRIS stored procedures.

Roles & groups

  • Resolved an issue that would prevent correct role names from being displayed in group member list.
  • Resolved an issue that would process groups containing roles incorrectly when using the GroupFlattenTask function.
  • Resolved an issue that would revoke owner access to a private report when read access was given to another user via the share pop-up.
  • Resolved an issue that would prevent a user from editing and copying other users' public dashboards (learn more).
  • Resolved an issue with personal dashboard permissions that would log a user out of Yellowfin when exporting certain file types.

Web services

  • Resolved an issue in the LOADDASHBOARDTAB and LOADPARENTDASHBOARDTAB web services that would prevent dashboard filters from being returned in a web service report.

JS API

  • Resolved an issue that would prevent date sliders from functioning correctly via the JS API.
  • Resolved issues that would affect drill through functionality in the JS API.
  • Added a report interaction that disables the Open Chart Image tooltip option.

Views

  • Resolved an issue that would prevent UUIDs from populating a CSV file when attempting to translate a view.
  • Resolved an issue that would create new field UUIDs for fields within cloned views instead of copying the existing field UUIDs.

Content export

  • Resolved an issue that would cause certain JS charts to duplicate when exporting to PDF.
  • Resolved an issue that would prevent Stories with certain embedded videos from being exported to PDF.
  • Resolved an issue that would prevent SVG <image> tags from exporting to PDF.

Broadcasts

  • Resolved an issue that would cause a broadcast to fail when the report included sub queries with filters.
  • Resolved an issue that would prevent report broadcasts and emails from being sent if a report was filtered with the ‘Equal to’ or ‘Different from’ operand.
  • Resolved an issue that would display broadcast URLs incorrectly when custom parameters were defined for Co-Display reports.

Dashboards

  • Enhanced the Canvas Properties panel display functionality.
  • Resolved an issue that would prevent the FILTER<ID> and FILTER<UUID> parameters from functioning correctly when used with a dashboard.
  • Resolved an issue that would prevent view-level filter groups from having their cached values refreshed from the dashboard.
  • Resolved an issue that would prevent view-level cached filters from refreshing when a report was imported.

Reports

  • Resolved an issue that would prevent access filters from functioning correctly if a certain combination of cached filters were applied.
  • Resolved an issue where cached filter values would not display for imported reports.
  • Resolved an issue that would cause an error when attempting to edit a report with a cached filter query.
  • Added a configuration option for locale-based sorting to improve performance issues for diacritics (such as é and ö) (learn more).
  • Resolved an issue for cross tab reports which would prevent subtotals from displaying in the correct layout.
  • Resolved an issue that would prevent advanced functions from being used in drill through links.
  • Resolved an issue that would return empty data in a report that used a date parameter in a calculated field.

Charts

  • Improved the Auto-Hide Legend option to automatically hide chart legend items when they exceed a pre-configured amount (learn more).
  • Reinstated numeric axes as the default value for the Default Gridlines option on new installs.
  • Streamlined the Axis Title Text dropdown menu options.
  • Resolved an issue that would cause an error on certain selected chart series when linked by a conditional drill through.
  • Resolved an issue for numeric display charts that would display the default formatting prefix when using a percentage variance.
  • Resolved an issue that would prevent the correct display of the trend line color for a chart series or color selection.
  • Resolved an issue that would prevent the mean trend line color from saving.

User interface

  • Resolved an issue that could cause canvas reports in stories to be cropped.
  • Improved thumbnail generation to properly scale for better display on desktop and mobile app.
  • Resolved an issue that would cause a date slider display error on a chart after toggling to and from its table, if the table contained pagination buttons.
  • Resolved an issue that would cause a time slider display error on a published dashboard when using a tabbed Section Style in Section Formatting.
  • Resolved an issue that would cause an error after switching to code mode from preview mode, and prevent the use of the Delete Code Mode Content feature.
  • Resolved an issue that would cause the report to re-run on the chart builder page.
  • Resolved an issue that would cause the SSL Required field name in the Create Data Source dialog box to display as 'undefined'.
  • Resolved an issue that would prevent dependent filters from correctly updating their values in the story Filter panel.
  • Resolved an issue that would prevent users from closing the warning pop-up that would appear when deleting a drill through filter.
  • Updated the description text for List Size in Filter Formatting.
  • Resolved an issue that would prevent report cancellation requests when a user navigated away from the dashboard.
  • Resolved an issue that would prevent the Refresh tab from being hidden when saving a report, even when the Hide Report Refresh role function had been enabled.
  • Resolved an issue that would prevent the report column drop-down list from appearing after re-rendering.
  • Resolved an issue that would prevent the Row Highlight function on dashboard reports from highlighting the entire row.
  • Streamlined all approval notifications to match those for reports and views.
  • Streamlined the positioning of page sliders for dashboard reports.
  • Streamlined the report column pop-up options.
  • Updated the title of the Properties pop-up for associated reports and video widgets (learn more).
  • Updated the Yellowfin Community and Wiki links on the Admin Console, and in the installer and updater.

Mobile

  • Resolved an issue where single sign-on would not function for legacy versions of the Yellowfin app on iOS and Android.

...

Expand

Infrastructure

  • Improved the performance of the logic used to determine a user's access to dashboards.
  • Upgraded the JS library TinyMCE to version 5.8.2.
  • Upgraded the JSch library from 0.1.55 to 0.1.63 to support more ciphers.

Data

  • Improved the management of repository database connection resources on the Report Builder page.
  • Added additional database indexes to the repository database to accelerate queries running against tables related to dashboards and images.
  • Added an advanced configuration to control some Oracle data source objects and synonyms (learn more).
  • Added a validation filter condition to Teradata calculated field validation.
  • Removed legacy drivers for Big Query and Hive proxy JDBC, and updated the Hive connection wizard to accept the official Hive driver and to exclude the outdated DriverPath connection parameter.

JS API

  • Implemented the ability to listen to dashboard loading events via an object on the window.
  • Added the option to white label the JavaScript API from the Yellowfin configuration UI (learn more - see the General Settings table).
  • Improved CSS load speed within the JS API.

REST API

  • Added support for creating a login token from the REST API for the current user without requiring the current user's credentials (allowing REST API consumers to use the JS API or redirect to the web app without the user having to re-enter their credentials).

Reports

  • Added a new report layout option that enables scrollbars for canvas reports on dashboards if they don't fit their container.

Charts

  • Updated the tooltip for layered bar charts to display all bar values on hover, as well as the total for the entire bar.
  • Tweaked the code for parsing browser width and height to improve chart sizing on the page.

User Interface

  • Improved report loading speed by eliminating superfluous load requests.
  • Improved the vertical alignment between toggle filters and their label names to be vertically centered.
  • Improved the layout, content and sections of the Action Button Properties panel.

...

Expand

Infrastructure

  • Upgraded Tomcat to 9.0.50 for new installations.
  • Improved memory management during view save and load processes.
  • Improved the security of the Browse page.
  • Resolved individual potential vulnerabilities with:
    • content folder management;
    • the input area of report approval messages;
    • The approval step before publishing reports to private folders;
    • the availability of report detail summary information;
    • the reference code manager;
    • unauthorised user session access to the Admin Console;
    • the quick login functionality;
    • email templates;
    • storyboard slide editing settings and sharing;
    • image access and user profile image functionality;
    • attaching links and videos to comments.
  • Resolved an issue that would allow users to view a report with data from a restricted-access subquery view before the report’s first run.
  • Resolved an issue where creating a view from the MIPreReportInit.i4 page would fail.
  • Resolved a misconfiguration issue with the static resources identifier when loading a plugin.

Logging

  • Resolved an issue that would prevent an event from being recorded after moving a content item from Favorites on the Browse page.
  • Resolved an issue where the event table would not log events for exports to XLSX and CSV file types.

Data

  • Resolved an issue where DB connection pool deadlocks could occur, even when connection pooling was not in use, when the connection limit was reached.
  • Resolved a potential security issue that could arise during the testing of data source connections.
  • Resolved an issue that would cause an exception when a Salesforce data source launched pre-built content.
  • Resolved an issue where a view could not be changed to use a data source from a different database type.
  • Resolved an issue that would cause the Geometry data type to be misinterpreted when using an SQL Server data source.
  • Resolved an issue that would cause the access filter schedule to always use the Append refresh type.
  • Resolved an issue with view relationships where reordering table conditions would cause any other changes to be lost.
  • Resolved an issue with the View Builder that would cause the table filter to reset when viewing more than one page of search results.
  • Resolved an issue where calculated fields using custom functions with the DateTime data type would pass the date value only (no time value) into the SQL query.
  • Resolved an issue that would prevent OLAP Cube sub queries from working.
  • Resolved an issue where OLAP sub query filters would not add offsets to dynamic dates.
  • Resolved an issue that would prevent a dashboard from being exported if it contained a drill through to a  dashboard with a filter belonging to a report's sub query.
  • Resolved an issue that would prevent the deletion of a view created from a report.
  • Resolved an issue where saving stored procedures would not adhere to the Include Schema in SQL option, and improved functionality so that stored procedures can be saved without the schema component, enabling cross-schema datasource substitution.
  • Resolved an issue that would cause orphaned database records if view cloning failed.

Roles & groups

  • Resolved an issue that would prevent the role function Show Draft Dashboards from working as expected.
  • Resolved an access issue with the Hide Browse role function.
  • Resolved an issue that would cause members of client org user roles to be excluded from client groups that their roles had been added to.
  • Resolved an issue where users and user groups would not be deleted after the client org they belonged to had been deleted.
  • Resolved an issue that would prevent the User Group Members list from displaying more than ten users.
  • Resolved a potential security vulnerability when retrieving the list of discussion group members.

Installation

  • Reverted changes made in 9.6 to the Show Duplicate Records toggle in the View Builder for smoother upgrades.
  • Resolved an issue that would prevent the migration process from running on the target instance if no external URL had been set in the source instance.
  • Resolved an issue where if a problem produced the JDBC error message during Yellowfin installation, the error message would also display the DB password.
  • Resolved an issue where the database password would display when installing Yellowfin through the command line.
  • Resolved an issue that could cause some unexpected text in some messages on brand new Yellowfin instances with tutorial content installed.
  • Resolved an issue with using encrypted licenses with Yellowfin.

Data migration

  • Resolved an issue that would prevent files exported from older versions from being imported via the REST API.
  • When migrating dashboards from pre-9.0 releases to 9.5 or later releases, resolved an issue that would cause associated reports to disappear, or appear in the wrong location, after migration.
  • Added a migration job that updates the statuscode of contentmanagement records to OPEN when the statuscode is DRAFT.
  • Resolved an issue that could cause some content not in OPEN state to attach to export files as dependencies.
  • Resolved an issue that would cause a report with two or more custom query filters from a different data source to export with only one of those custom query filters.
  • Resolved a potential vulnerability with the handling of data source passwords during the import process.
  • Resolved an issue that would prevent filters on a dashboard with code mode from applying after import.
  • Resolved an import error on report views with deleted records.
  • Resolved an issue would ignore the selection of the custom query filter data source option during import.

JS API

  • Resolved an issue where setting the possible values via the JS API would not work correctly with a pop-up filter.
  • Resolved an issue that would prevent JavaScript charts from loading on embedded dashboards.

Content Export

  • Resolved an issue where switching export types via the Export popup would stop an export.
  • Resolved an issue where exports would sometimes erroneously fail with a ‘Content Has Changed’ message.
  • Resolved an issue that could prevent some multi-tab dashboards from exporting.
  • Resolved a layout issue that would cause exported co-display reports with sections to separate tiles from reports if the export didn’t fit on a single page.
  • Resolved an issue where canvas formatting would not be applied to report canvases on the Print Preview pop-up.
  • Resolved a PDF export issue that would cause tables to break incorrectly when the header and footer heights were vastly different values.
  • Resolved an issue that would prevent the Filter API from reporting the correct values when exporting to PDF.
  • Resolved an issue with static layout dashboards where a width greater than 1000px would not shrink to fit when exporting to PDF.
  • Resolved a PDF export issue that would prevent row-based report exports.
  • Resolved an issue that would prevent exports to PDF when CSRF Filters was enabled.
  • Resolved an issue where exporting reports to PDF using certain fonts would cause tables to break in unexpected places.
  • Resolved an issue that would prevent the correct layout of long report names or descriptions when exporting co-display reports to PDF.
  • Resolved an issue where row-based reports would render inconsistently when exporting to PDF.
  • Resolved an issue where PDF exports with Suppress Duplicates enabled would not export labels for custom-width columns.
  • Resolved an issue that would cause the bottom border to disappear on reports exported as PDF or DOCX with Suppress Duplicates turned on.
  • Resolved an issue that would prevent images in the header and footer of a report from exporting correctly to the DOCX file format.
  • Resolved an issue with DOCX exports including actual data values when a conditional format using icons is used
  • Resolved an issue with conditional formatting icons not being displayed on total and subtotal rows in DOCX, PDF and XLSX exports
  • Resolved the issue of conditional formatting icons not being available in XLSX exports.
  • Resolved an issue with conditional formatting legend missing for total and subtotal rows in XLSX exports

Broadcasts

  • Resolved some issues around content display within the new broadcast subject line filter tags including:
    • inconsistent date formatting/dynamic date display;
    • incorrect unicode character rendering; and,
    • empty subquery filter tag content.
  • Improved the format of broadcast email filter tags that contain multiple filter values.
  • Resolved an issue where filtering a report date field with the ‘In list’ operand, then using the date field in a broadcast filter tag, would prevent the broadcast from running.
  • Resolved an issue that would prevent reports with timestamp filters from broadcasting.
  • Resolved an issue that would flag a report broadcast schedule with Success even when it had failed to generate a PDF.
  • Resolved several issues around schedule management, including incomplete deletion of tasks related to a ref code, and tasks without descriptions not being searchable.
  • Resolved an issue that would cause inaccurate broadcast counts, which led to some EventCache performance enhancements.
  • Resolved an issue that would prevent broadcasts from running after upgrading to 8.0.10.1 or 9.6.

Dashboards

  • Modified the publishUUID migration job for dashboard and presentation canvasses so their changes are committed incrementally to the database.
  • Resolved an issue that would prevent filter linking between advanced functions on a dashboard.
  • Resolved an issue that would prevent advanced function filters and filter links from being imported or migrated during an upgrade.
  • Resolved an issue that would cause the preview/edit toggle mode to change when switching between tabs to a new sub tab with global content.
  • Resolved an issue where brushing would not be disabled for canvas sub tabs even when toggled off.
  • Resolved a timing issue that could cause the wrong report display type to be rendered in the dashboard canvas editor.
  • Resolved an issue where a drill up triggered from the report menu would not be reflected in the child report of a dashboard drill to drill report interaction link.
  • Resolved an issue that would prevent CSS on code mode dashboards from being removed from the page when the user left the tab.

Reports

  • Resolved an issue that would cause the Moving Average analytical function to use incorrect rows during calculation.
  • Resolved an issue that could prevent report data time/date fields from displaying according to the user’s set time zone.
  • Resolved an issue that would cause a report and any dashboard it was embedded on to endlessly load if it contained a drill through to a dashboard with a filter belonging to a report's sub query.
  • Resolved an issue that could skew the layout of report headers with Report Header Lock enabled.
  • Resolved an issue that would ignore text alignment in columns of set widths.
  • Resolved an issue that would cause a skewed display of filter panel titles in edit mode.
  • Resolved an issue that would prevent the Suppress Duplicates option from working on fields with subtotals set.

Filters

  • Resolved an issue that would cause date functions placed within filter groups to generate incorrect SQL.
  • Resolved an issue that would cause incorrect user prompt filter values for a report with Minus sub queries.
  • Resolved an issue that would allow the user prompt filters to trigger additional runs of a report already running.
  • Resolved an issue that would prevent dependent filters using the list entry style from resetting to the correct default filter values.
  • Resolved an issue that would cause filters to lose their insertion order when adding multiple sub queries.
  • Resolved an issue where filter links would not be updated after a dashboard was edited.
  • Resolved an issue where the Min/Max filter options would be missing for custom query filters on dashboards.
  • Resolved an issue that would prevent filters from resetting to their default values when the Dynamic Default Filter setting was enabled.
  • Resolved an issue that would ignore the number placed in the List Size field of the Filter Formatting panel.
  • Resolved an issue where checkbox filters would show unnecessary scroll bars by reimplementing the List Size parameter on dashboards to configure list and checkbox filter scroll bars.
  • Resolved an issue that would cause an error when dependent filters from multiple reports on a dashboard had their parent filter values changed at the same time.
  • Resolved some display issues with the left filter navigation panel, including buttons that would be hidden when switching modes and filter groups that would collapse on each other.
  • Resolved an issue with conditional drill through that would cause child filters to fail to link if they were created after the drill through was set up.

Charts

  • Added Null Behavior options to category-based charts.
  • Resolved an issue where the horizontal axis display name on a trellis vertical bar chart would use the vertical axis display name.
  • Resolved an issue that would prevent conditional colors from showing on a time series bar chart with a metric color field.
  • Resolved an issue that would block conditional formatting on an auto chart when coloring by the metric field if no color field was present on the chart.
  • Resolved an issue where importing an area chart on a cross tab or an area chart with dimension color would not import the opacity setting for an entire series.
  • Resolved an issue where a trend could be broken and wasn't being identified as a problem field within the report builder.
  • Resolved an issue on some charts that would cause multiple points from the same line to be selected on mouse hover.
  • Resolved an issue that would cause tooltips to appear in the wrong place when using animated charts.
  • Resolved an issue that would cause the tooltip on time series forecasts to hide data in certain languages.

Stories

  • Resolved an issue that would prevent a story’s screenshot from cropping on a large screen.
  • Resolved an issue where users who were not original contributors of story templates could not create new stories based on those templates.

User Interface

  • Resolved an issue that would prevent user details from being updated if they had a password expiry date set.
  • Resolved an issue where a dashboard could be added to the Favourites area multiple times.
  • Resolved an issue that would cause an empty toolbar to be displayed to users who had not selected a dashboard to load at login.
  • Resolved an issue that would prevent users from using the drag-and-drop functionality to move certain content items to and from folders on the Browse page.
  • Resolved an issue that would prevent changes to the Custom Share Email Sender config fields from being saved when client orgs are enabled.
  • Added an option to disable text encoding/escaping for the Action Button URL formatter (learn more).
  • Resolved an issue where canvas widgets could not be sent backwards or forwards on the canvas when grouped.
  • Resolved an issue that would cause the Publish pop-up to appear when changing tabs in the Model step of the View Builder.
  • Resolved an issue that could cause the Prepare step of a view to stop loading.
  • Resolved an issue where the toggle changes on the Performance section of the View Options panel would not be saved.
  • Resolved an issue where changing the canvas width via the Dashboard Properties panel would cause the sub tabs selector menu to disappear.
  • Resolved a positioning issue with the Action sub-section of the Properties panel on static layout dashboards.
  • Resolved an issue that would prevent the export of SQL when requested via the SQL Statement tab of the Information popup for a dashboard.
  • Resolved an issue where sticky global containers would not inherit the dashboard background color.
  • Resolved an issue that would prevent the Legend Title and Description formatting fields from updating on a report.
  • Resolved a display issue that could occur when hiding the first field in a cross-tab report.
  • Resolved an issue that would cause multiple scrollbars to appear on a report upon opening a dialogue box.
  • Resolved an issue that would prevent users from editing conditions with NULL/NOT NULL operators in the Conditional Formatting pop-up.
  • Resolved an issue where Jasper reports with multiple filters would incorrectly display duplicate filters.
  • Resolved an issue that would cause the Select All toggle on checkbox lists in the filter panel to stay on after resetting the filters.
  • Resolved an issue that would not allow users to change the entry style of a view-level filter on dashboards.
  • Resolved an issue that would prevent the date filter from functioning correctly upon clicking apply a second time.
  • Resolved an issue that would cause HTML characters to be displayed within the popup text when linking filters.
  • Resolved an issue that would cause the filter control panel to display out of bounds in some languages.
  • Resolved an issue that would cause the Reset link to be incorrectly greyed out instead of clickable.
  • Resolved an issue that would cause the left side nav filter panel to remain open after applying filter updates.
  • Resolved an issue with client orgs that would cause the left side navigation to disappear on dashboards that used a different navigation style setting to their parent org.
  • Resolved an issue that would allow zooming out to one level further than allowed on a GIS map.
  • Resolved an issue that would prevent changes to the Chart Series Settings panel from saving when there were too many categories on a chart.
  • Refreshed the Create New Presentation pop-up design including easier scrolling and visible theme titles.
  • Resolved an issue on published presentations that would allow a user to right-click on a slide to see the Edit option.

Translations

  • Improved some phrasing in our French UI.
  • Added short month names to the Thai translation so they are shown correctly on the calendar.

...

Expand

Infrastructure

  • Resolved an issue where, after exporting to PDF and sending via email, Yellowfin would continue to check for export activity.
  • Resolved a performance issue when rendering a large amount of cached filter values into a report or dashboard.
  • Resolved an issue that could sometimes cause high CPU usage when running reports and receiving export notifications.
  • Resolved a latency issue that would prevent chart color defaults in the Admin area from saving.
  • Removed unused jQuery resources after upgrades.
  • Resolved an issue where the command line installer would incorrectly state that it had installed the tutorial data.
  • Resolved an issue where upgrading from Yellowfin 7 would cause the Browse page to hang.
  • Resolved an issue that would cause an upgrade from Yellowfin 8.0.8 to halt if the license file could not be found.
  • Resolved an issue where a license with multicast disabled would affect the user's ability to use webservices when saving reports.
  • Resolved an issue where a license with concurrent mode disabled would give an incorrect licence breach warning.
  • Improved security by implementing a feature that allows the two-way encryption key to be replaced with a custom key.
  • Resolved a potential security vulnerability with the activity stream.
  • Resolved a potential security vulnerability when exporting reports to PDF and DOCX formats.
  • Resolved a potential security issue with the translation import/export page.
  • Resolved a potential security issue when adding users through the User Import window.
  • Resolved a potential security vulnerability in the Story Editor and its controls.
  • Addressed a potential XSS issue with custom header and footer includes.
  • Resolved a potential access control issue on private discussion streams.
  • Resolved an issue that would allow edit access to views stored in a secure folder.
  • Added a nonce to every application request to prevent duplicate submissions (learn more).
  • Resolved an issue that could cause an unexpected error when performing chart brushing when Yellowfin was installed on an HSQL configuration database.
  • Resolved an issue where Datasource Creation and Datasource Edit actions would fail when the datasource contained thousands of schemas.
  • Resolved an issue that would cause certain reference code synchronisation jobs to fail.
  • Resolved an issue where client orgs would not display Signals analyses based on the views from the primary org.

Data

  • Resolved an issue where applying a Boolean filter with a BigQuery data source would cause an error to appear.
  • Resolved an issue where BigQuery filters would throw SQL errors if they contained apostrophes.
  • Resolved an issue that would cause a "resource exhausted" error in the Google Sheets connector (learn more).

JS API

  • Resolved an issue with the Yellowfin JS API, which would overwrite any other copies of jQuery with the global copy included with the JS API.
  • Resolved an issue that could prevent CSS from loading within the JS API with certain proxy and firewall configurations.
  • Resolved an issue that would prevent signal lists from displaying properly when embedded in the JS API.

REST API/Web Services

  • Resolved an issue where the TESTIMPORTCONTENTNOVALIDATION web service call would still perform validation.
  • Resolved an issue where client organization substitute data sources would be hidden when using SOAP services and the REST API.
  • Resolved an issue with the SOAP web service function SAVECONFIGURATION which would not update for a few specific configurations.

Imports

  • Resolved an issue where importing an older report would fail if a chart had multiple reference lines with multiple colors defined.
  • Resolved an issue that would cause bulk user imports to fail on Yellowfin instances using Oracle databases.
  • Resolved an issue where filter links on a dashboard with code mode could break when imported.
  • Resolved an issue where importing code mode dashboards with images could lead to the wrong ID for some images, breaking their display.
  • Resolved an issue with transformation flows where a large delimited file could not be extracted.
  • Resolved an issue with ETL item import that could prevent reports from being editable.

Content Export

  • Resolved an issue where switching export types via the popup would stop an export.
  • Resolved an issue that would cause special characters in HTML fields to be exported to XLS as HTML entities (eg, “&aacute;” instead of “á”).
  • Resolved an issue where exporting a co-display tabbed report to some formats would export only the content from the first tab.
  • Resolved an issue where the “shrink to fit page width” setting would not shrink for co-display report exports.
  • Resolved an issue with some versions of Java that would prevent the PDF exporter from starting.
  • Resolved an issue where switching export types via the popup would stop an export.
  • Resolved some layout issues for PDF exports which would cause:
    • early page breaks on some pages;
    • excess whitespace when the “Scale to Fit Page Width” option was enabled;
    • certain images to be misplaced on a canvas when shrink to fit was enabled;
    • some SVG images to be rendered at low resolution;
    • some table borders to go missing;
    • the view summary to go missing when using a preferred PDF font;
    • the report title and description to be wrapped at report width (rather than page width);
    • blank PDFs when exporting the first slide in a presentation with the Export Slides ‘Current’ radio button selected;
    • some translated words on charts to appear in their original language; and,
    • row-based reports on dashboards to go missing.
  • Resolved an issue that could cause reports to export as blank PDFs on some Java versions.

Views

  • For customers upgrading to 9.6, we switched on the ‘Show Duplicate Records’ toggle for all drag and drop views to avoid excess preview processing times.
  • Resolved an issue that would stop a valid view-level calculated filter from being saved.
  • Resolved an issue with view-level cached filter group filters, which would not automatically link correctly when added to a filter list.
  • Resolved an issue that would prevent the Show Duplicate Records toggle from functioning in views.
  • Resolved an issue where a view-level Freehand SQL calculated filter could not be saved after editing.
  • Resolved an issue that would prevent the download of view summaries for SQL views.
  • Added an optional configuration for Yellowfin to create SQL statements with views created from an identical data source to resolve a 7.1 upgrade issue where queries would display incorrect data.

Dashboards

  • Resolved an issue that would prevent users with only the Personal Dashboard role function enabled from creating private dashboards.
  • Resolved an issue where cloning a view used by a report on a dashboard would not update the dashboard filter settings.
  • Resolved an issue where filters applied on the dashboard would be cleared after reloading the page.
  • Resolved an issue where an enabled Dependent Values option in a filter hierarchy would have no effect on the child filter value list when switching back to a dashboard tab with previously applied parent filters.

Reports

  • Resolved an issue that would cause a user to lose read access to reports if private report sharing was disabled in the user’s role.
  • Resolved an issue that would cause Freehand SQL reports to automatically suppress duplicate cells.
  • Resolved an issue where manually sorting the order of a table column would cause the new order to persist even after resetting it.
  • Resolved an issue where reports created by the Google Analytics connector would cause system errors.
  • Resolved an issue where nulls would only display as zeros on column totals when “Nulls as Zeros” column formatting was enabled for cross tab reports.
  • Resolved an issue with the Division By Column(s) advanced function which would treat a calculation result of zero as null.
  • Resolved an issue where a drill through to a report would not work after switching sub tabs and returning.
  • Resolved an issue that would prevent the display of a report drill through link when the target report used an advanced user prompt filter.
  • Resolved an issue where drill through report settings could not find sub query filters from the target report.

Filters

  • Resolved an issue where previously applied filter values would not be cleared when a bookmark was applied.
  • Resolved an issue that would prevent the option to use min/max values for cached filters from saving.
  • Resolved an issue that would prevent filter values from being obtained for reports created from Freehand SQL views with access filters enabled.
  • Resolved an issue with Drill Through to Dashboard that would cause both the values of a Between filter to be read as one value.
  • Resolved an issue that would prevent a drill through link from being set when using a default child value for a mandatory filter.
  • Resolved an issue where the operators ”In List” and “Not In List” would not accept a filter value of zero.
  • Resolved an issue where using action buttons to reset a “between” filter would not fully reset the filter results.
  • Resolved an issue where report filters would automatically replace custom regional decimal separators with default full-stops.

Charts

  • Resolved an issue where custom colors would not show on multi pie charts.
  • Resolved an issue where custom color series would not work on a cross tab-based chart when using a Date Part formatted value.

JS Charts

  • Resolved an issue where dynamically scaled JavaScript charts would fail to render correctly when published.
  • Resolved an issue that would cause JavaScript charts to disappear on the chart canvas.

Broadcasts

  • Resolved an issue where a broadcast would stop sending content to any remaining valid recipients after encountering a single failed delivery address.
  • Resolved an issue where broadcast schedule jobs would sometimes be marked as successful despite some of the reports failing to run.
  • Resolved a timing issue in the Task Scheduler which would cause duplicate task runs in a clustered environment.

User Interface

  • Resolved an issue where an "unsaved changes" warning would show when switching from the Email tab to another tab on the Configuration page in a newly added client organization.
  • Resolved an issue in user group management where clicking the Add button for a dashboard tab before selecting a tab would cause an error.
  • Resolved an issue that would cause the top button on the navigation menu to overlap with other buttons when a user’s profile was disabled.
  • Resolved an issue that would cause some specific escaped characters to be displayed.
  • Resolved an issue where the yellow Create button would disappear after opening the screenshot option from the activity stream.
  • Resolved an issue that would not the count stories and views in the favorites count on the timeline.
  • Resolved an issue that would cause the timeline Connections panel to omit the display of contacts followed.
  • Resolved an issue where license reminder values would not load correctly on the license reminder page.
  • Resolved an issue where a broken content folder could cause the New Folder pop-up to omit the Folder Hierarchy section.
  • Resolved an issue where the export search would not work if there was a broken content folder in the system.
  • Resolved an issue that would prevent client organisation reports from launching if CSRFFilter was enabled.
  • Resolved an issue where discussion streams could not be deleted.
  • Resolved an issue that would prevent comment and task deletion from discussions with list view layouts.
  • Resolved an issue where editing a task comment from the discussion panel would not open the popup for editing.
  • Resolved an issue with an incorrectly labeled button when saving views as drafts.
  • Resolved an issue where the field list in the Field Settings dialog box of the view builder would disappear after a failed attempt to delete a column.
  • Resolved an issue where changing an action button font could cause vertical misalignment.
  • Expanded the maximum width of custom formatting labels to prevent overlaps in other languages.
  • Resolved a hover icon display issue where the chart/report toggle icon on a dashboard would default to show the chart image.
  • Resolved an issue where presentations would be displayed upon login instead of the dashboard.
  • Resolved an issue where resizing a dashboard canvas with the drag handle would display on the screen but would not be saved.
  • Resolved an issue that could sometimes cause an error when loading a dashboard page.
  • Resolved an issue where displaying the page title, user and role information in the header would cause whitespace when viewing dashboards on an iPhone.
  • Resolved an issue where an unnecessary horizontal scrollbar would be present in Dashboard Edit mode.
  • Resolved an issue where selecting ‘shrink to fit’ on a dashboard tab would inadvertently set the dimensions to zero.
  • Resolved an issue where the word ‘Reports’ would incorrectly display when selecting other content types to add to a dashboard.
  • Resolved an issue where dashboards would not respect custom widths set for report columns (read more).
  • Resolved an issue that would cause long reports to overflow their bounding box on static layout dashboards when the Auto Height option was enabled.
  • Resolved an issue that would cause breadcrumbs to work incorrectly on a co-display report with drill through enabled.
  • Resolved an issue that would prevent filter list display names from being renamed or hidden in real time when editing dashboards.
  • Resolved an issue where drill through popups would not display in full-screen dashboard mode.
  • Resolved an issue that would cause report tabs with long translations in other languages to overlap in edit mode.
  • Resolved an issue where a secondary scroll bar would appear in the Create Simple Report View pop-up.
  • Resolved an issue where operands breadcrumbs would sometimes display incorrectly.
  • Resolved an issue that would cause subtotal rows to display the title text from the row above.
  • Resolved an issue where a row highlight color set in the report builder could not be removed.
  • Resolved an issue where the value list display limit would be ignored for checkbox filters.
  • Resolved an issue with a missing scrollbar for filters with more than twenty options displayed as radio buttons.
  • Improved the layout of long-width filters and their control buttons.
  • Resolved an issue where drill down to filter links would not refresh when drilling up multiple levels using breadcrumb navigation.
  • Improved the display of left-side filters on dashboards by realigning the magnifying glass.
  • Resolved an issue where filters could not be applied on a dashboard if the Apply button style was configured to be a link instead of a button.
  • Updated the descriptive texts for report filter settings, which were around the wrong way.
  • Resolved an issue that would cause text filters to set cursor focus to the bottom filter on page load.
  • Resolved an issue that would cause long-running reports to run without providing the user with options to cancel or to run it in the background (learn more).
  • Resolved an issue where the PDF export panel would not render correctly for the older (V1) PDF plugin.
  • Added a loading indicator to the report broadcast page while broadcast instances are loading.
  • Resolved an issue where broadcast failure notifications would not activate when enabled through the Administration settings.
  • Resolved an issue where story screenshots would render partially transparent.
  • Resolved an issue that would cause slide thumbnails to break when flicking through slides too quickly.
  • Removed an unnecessary warning for presentations without reports on the import/export page.
  • Updated some UI text inconsistencies on pop-up displays and when returning to a presentation from a report that would incorrectly display “Dashboard” instead of “Presentation”.
  • Resolved an issue where changing the UI language would not update the language or the total color on a waterfall chart.
  • Resolved an issue that would cause sectioned charts to appear without a scrollbar on dashboards, making all other sections of the report unreachable.
  • Resolved an issue which would cause long time zone text to overlap the down arrow next to it in step 2 of a Signals Analysis.

Translations

  • Updated the German phrasing for "Present" in our German translation file.
  • Resolved an issue where the run errors for broadcast failure messages would sometimes show a resource string rather than translated text.
  • Resolved an issue where delimiters would be displayed with translated text.

...

Expand

Infrastructure

  • Upgraded Jackson Databind libraries to 2.12.1.
  • Updated Tomcat to version 9.0.43.
  • Upgraded commons-io from 2.2 to 2.8.0.
  • Reinforced security in the dashboard approvals workflow.
  • Added a server configuration field to adjust the maximum upload file size (learn more).
  • Implemented a new JWT entry mechanism that will accept a JWT token and use the contents to provision a new session (learn more).
  • Improved JavaScript loading speed on some pages.
  • Improved performance when editing views by caching table metadata, which reduces latency when using large views or slow datasources.
  • Improved performance for Snowflake datasources.
  • Added an option to record unsuccessful login attempts for non-users in the Yellowfin event table (learn more).
  • Implemented a configuration item to blacklist certain event types from being added to the Event log.
  • Improved logging for ReportEditKey validation.
  • Added DB-level support for GMT offset timezones.

JS API

  • Added a new PublishUUID attribute that replaces the use of the WidgetUUID attribute in code mode/JS API/code widgets for new and updated widgets. This allows users to identify widgets in a more unique way with a persistent identifier across dashboard edits and versions (learn more here and here).
  • Scoped the CSS of embedded content to prevent our JS API styling from leaking into external pages (all elements are now children of app-report, app-dashboard, app-story or div.yfContainer).

REST API

  • Resolved a REST API issue where sometimes a server/database error could cause a 401 response to be returned instead of a 500 response.
  • Updated the version handling of all REST API endpoints (no change for consumers).

Content Export

  • Improved story PDFs when exported to large pages up to A0.
  • Implemented notifications for lengthy PDF export downloads, and improved the PDF download process to continue after navigating away from a page.
  • Added a security check to ensure that PDF export cannot be performed without the required role function.
  • Added the option to share a dashboard as a PDF via email.
  • Implemented the option to add dashboards to the export list via the Export dropdown menu.
  • Added the option to save the current settings of the export panel for PDF.
  • Added the option to select which sub tabs and slides to export via PDF.

Reports

  • Improved chart navigation by adding a Drill Up menu option to the pop-up menu after drilling down to the Other segment.

Filters

  • Added new options for determining whether other report filters are applied when caching filter values, and for limiting the complexity of the queries used to load cached filter values (learn more).
  • Added the choice to enable optional filter values for Freehand SQL (this requires proper parameterised SQL text), allowing users to enter a value into a user prompt, or leave it blank, for Freehand SQL filters.
  • Improved the robustness of filter loading when directing a user to a dashboard via SSO.
  • Improved the Dashboard Properties panel to include additional configuration options when the Left Filters toggle is enabled in edit mode.

UI

  • Added additional font sizes to drop downs for charts
  • Added input arrows to the numeric inputs within the background section of a canvas widget.
  • Added tooltips for:
    • the Copy and Delete tools within Present;
    • each blueprint report widget and changed their order; and,
    • the Broadcast tool for dashboards.
  • Added a button to exit full-screen mode for Present.
  • Improved the Properties panel for widgets to hide additional border options if no border style is selected.
  • Improved visibility of all canvas widgets during drag and drop by making the dragged widget semi-transparent.
  • Changed the widget action toolbar to pop up only when a widget is clicked on, rather than hovered over.
  • Changed the default focus of the pop-out Dashboard Properties panel to the Sub Tab section, and of the Present Properties panel to the Slide section.
  • Added the keyboard shortcut CTRL+A/CMD+A to select all widgets on a draft canvas.
  • Improved dashboard edit mode by suspending GIS map user tools, preventing accidental navigation and zooming (still available in previews and published dashboards).
  • Improved the text in the User Access dialog box for Present.
  • Improved the automatic filter linking popup confirmation message.
  • Updated the layout of descriptive text for the Rules field in the Conditional Formatting dialog box.
  • Improved field alignments and the appearance of the Schedule Manager and Dashboard Manager.
  • Improved the aspect of dashboard names in the dashboard tabs header so they occupy as much space as possible.
  • Improved spacing and layout of the Data Interactions dialog box for linked interactions and for the Signal Cache Settings dialog box.

Image Manager

  • Enhanced the Image Manager to accept uploads of a broad range of image file types, including animated GIFs (learn more).
  • Reimplemented the option to globally replace an image within the Image Manager (learn more).
  • Added the option to move an image between the My Images and Corporate Images repositories (learn more).
  • Streamlined the performance of how images are loaded in the Image Manager.

Signals

  • Resolved an issue where Signals could be filtered by job in Yellowfin version 9, but not in version 8.

...

Expand

Infrastructure

  • Resolved an issue that would cause an error when loading a user avatar that was set through the mobile app.
  • Resolved an issue where the custom Surname attribute would not be applied during the LDAP login process.
  • Resolved an issue where users from nested client org groups could not be contributing members to the parent group.
  • Resolved a memory leak when using paginated tables on a dashboard.
  • Resolved an issue that would cause background threads such as the Task Scheduler to hang.
  • Resolved an issue that would prevent an email server configuration from saving correctly if the encrypted SMTP server password contained special characters.
  • Resolved a potential XSS (cross-site scripting) vulnerability within the Datasource Name field when creating some types of data sources.
  • Resolved a potential XSS vulnerability within the local time code parameter on the Broadcast Management Page.
  • Resolved a security issue with BroadcastAjaxAction.
  • Resolved an issue with some internal AJAX calls that would cause the responses to strip security headers.
  • Resolved an issue that would hide client organization user groups from folder permissions.
  • Resolved an issue that could display the import page to non-admin users.
  • Resolved an issue that would cause pages to stop loading when the CSRF filter was enabled.
  • Resolved event logging issues for the report delete event (it would drop for report delete and all subquery deletes); the dashboard/present copy event (it would drop when the dashboard/presentation was edited); and the import/export present event (it would incorrectly register as a dashboard event).

JS API

  • Resolved an issue where button widgets with certain actions would break when included via the JS API.
  • Resolved an issue with tables embedded via the JS API that would not display pagination controls.
  • Resolved an issue that would prevent canvas reports from functioning correctly within v2 of the JS API.
  • Resolved an issue with report series selection in the JS API which would prevent the use of field names when applying series selection.

REST API

  • Resolved an issue that would cause the REST API to fail if the super user role was enabled.
  • Resolved an issue which would allow inactive users to access Yellowfin via the REST API.
  • Resolved an issue where org configurations could not be changed via the REST API.

Data

  • Resolved an issue that would prevent filters from being added to the dashboard when using particular databases.
  • Resolved an issue that would cause a syntax error when using the != operator with Teradata reports.
  • Resolved a transformation flow issue with the Date Component transformation step would display an error during configuration.

Imports

  • Resolved an issue with imports from Yellowfin 8 or earlier where the time unit selection would not be visible on dashboards.
  • Resolved an issue which has led to improving imports to rely less on names: for source matching, Source UUIDs are now used to match sources prior to matching on Source Name; and when replacing reports during import, custom query filter sources are now matched by UUID or Name, where they were not previously.
  • Resolved an issue where importing reports could cause either duplicate header image storage or a broken header image reference.

Content Export

  • Resolved an issue that would auto-enable the Secure PDF toggle when upgrading from Yellowfin 8.
  • Resolved an issue that would prevent images from being added to report headers and footers in XLSX exports.
  • Resolved an issue with PDF export where only a single record would be displayed when a table header was enabled on a dashboard canvas.
  • Resolved an issue that would prevent a report with a logo in the header from exporting if any rows were excluded in the export.
  • Resolved an issue that would cause PDF exports to fail in environments with proxy settings in the tomcat server.xml file.

Views

  • Resolved an issue in views where renaming an underlying column would not be reflected in views or reports.

Dashboards

  • Resolved an issue where users without public dashboard roles could not view private dashboards.
  • Resolved an issue where user group default dashboards would disappear when the dashboard was edited and published.
  • Resolved an issue that would cause applied filter styles to be lost when editing or copying a dashboard.
  • Resolved an issue that would create a malformed URL for a dashboard landing page when both multi tab was enabled and the request did not include the referer header.
  • Resolved an issue where paged reports would not display correctly on dashboards.
  • Resolved an issue where time series brushing linking would not work in preview mode.
  • Resolved an issue that would prevent certain brushing links from being applied to time series charts with advanced scientific notations.
  • Resolved an issue that would cause problems when code mode content is present while adding widgets to other sub-tabs in dashboards or slides in Present.

Reports

  • Resolved an issue that led to incorrect results for report calculated fields in crosstab reports.
  • Resolved an issue with calculated fields where the required closing bracket could not be added to some formulas.
  • Resolved a client issue where a calculated field would prevent a report from displaying results unless the fields were removed and re-added.
  • Resolved an issue that would prevent the creation of SSRS reports.
  • Resolved an issue that would prevent users from disabling autorun for reports.
  • Resolved an issue that would cause an empty list in the Search Filter Values popup on tabbed reports.

Filters

  • Resolved some issues in preview mode where duplicate content would appear in content containers.
  • Resolved an issue that would cause previously applied filter values to persist on the dashboard even after logging out, overriding any default filter values.
  • Resolved an issue that would prevent dashboards from loading when an incorrect filter ID was provided as part of the dashboard URL parameters.
  • Resolved an issue where filters that shared a dependency with a Custom Query Cached on Demand filter but had a different Value List Setup type would not display filter values.
  • Resolved some issues where Oracle error ORA-01795 would occur when selecting more than 1000 values for a filter or when adding an access filter to a data source with more than 1000 values.
  • Resolved an issue that would prevent a subquery from using the parent query’s parameters as filters in other views.

UI

  • Resolved an issue where the Show Duplicate Records checkbox would not display on the Configure Union Sub Query dialog box.
  • Resolved an issue where filter buttons would still be visible after setting the filter control panel to be hidden.
  • Resolved a dashboard issue where the display chart toggle would appear on reports without charts.
  • Resolved an issue where long column names in the view builder would cause the Edit Table link to be obscured.
  • Resolved an issue where the 'Delete' text would overlap another field in the Discussion Stream Settings window.
  • Resolved an issue with the screenshot tool which would not hide the comments box when capturing reports.
  • Resolved an issue in the Advanced Search dialog box that would cause the scroll bar to overlap the drop-downs.
  • Resolved an issue that would prevent reports from appearing in Favorites on the Browse page.
  • Resolved an issue that would cause the Create New Broadcast popup to be horizontally off-centre.
  • Resolved an issue that would cause the Browse page activity stream to be transparent until an item was selected.
  • Resolved an issue where the cursor would not be visible in metric filter fields.
  • Resolved an issue that would cause text widgets undo/redo functionality to stop being synchronized with the undo/redo buttons in canvas edit mode.
  • Resolved an issue that would prevent the creation of dashboards/presentations from the top toolbar after selecting Create New View.
  • Resolved an issue that, when editing a report and using the Modern SinglePanel left navigation filter, would prevent the pop-up entry-style filter from displaying.
  • Resolved some rendering and alignment issues with locked report headers in resized browser windows.
  • Resolved an issue that would prevent dependent filter values from rendering when displayed as radio buttons.
  • Resolved an issue that would cause dashboards to continually resize when viewed on mobile devices using pinch-to-zoom.

Translations

  • Updated the Dutch translations for 'Friday' and 'Fri' to 'Vrijdag' and 'Vr' respectively.
  • Updated the translation string for the 'Other' label and legend entry on pie charts.
  • Switched incorrect numerics for midnight and noon in Spanish (now ’00’ and ’12’ respectively).
  • Updated the dashboard translation file to include filter group names and filter list names.

...

Expand

Infrastructure

  • Improved system performance when creating large presentations.
  • Optimized loading times for the Browse page by refactoring how restricted table columns are queried.
  • Improved how dashboards and presentations handle unknown widget types (eg, invalid data in the configuration database or when a dashboard or presentation is imported and the widget's plugin is not loaded in the target instance).
  • Upgraded the Log4j library to version 2.17.1.
  • Upgraded Apache XMLSec library to version 2.2.3.

Data

  •  Added database capabilities (0=1 and LIMIT) in queries when using CacheDB as the data source.

REST API

  • Added a RoleCode response value to the api/user/{userId} REST API request.

Views

  • Added a new Field Properties option for views in the browse page (learn more).
  • Enabled support for Optimized Views when retrieving available values for Grouped Data fields.

Content export

  • Added a ‘Keep Formatting’ option for XLSX exports.

Filters

  • Added horizontal filters as a new filter list widget type for dashboards and presentations, using dropdowns.
  • Added the option of using one or more whitespace characters as filter values for the Report InList filers.

Dashboards

  • Restored dashboard report refresh scheduling and report loader options for customizing, animation, color overlay, and overlay message. 

Reports

  • Added currency formatting options for reports.
  • Added formatting options for sub-total, section total, and grand total rows for column-based reports.
  • Added the ability to style individual column headers in a report.

Advanced functions

  • Added the ability to toggle between absolute and relative difference for the advanced function, Months to Now.
  • Reverted the default settings for the advanced function, Top/Bottom N Percentage of Total, to match earlier versions.

User Interface

  • Added the ability to delete a filter container from the global dashboard area using the Delete key.
  • Improved the display of the Guidelines fields in the Dashboard Properties panel.
  • Improved the field text labels for the Growth Truncate advanced function.
  • Added a Close button to the top of published presentations (learn more).
  • Enabled the ability to rename a presentation slide by double-clicking its name in the canvas editor (learn more)
  • Updated the options available on the Publish dialog box in the View Builder.
  • Added a scroll bar to the filter list on the view level Filter Formatting settings page.
  • Updated the Field Permissions field label within the View Builder.
  • Improved the buttons on the popup that appears when a user tries to edit a view concurrently.
  • Updated the sort sequence of chart drill through links to match the Related Content tab.
  • Improved the content of the decision help text displayed when typing a Guided NLQ query.
  • Changed "Financial Week" to "Business Week" (learn more) and NLQ no longer filters out "Business Week" when financial date periods are the same as calendar date periods.
  • Updated the incorrect wording on warning message popups from ‘dashboard’ to ‘presentation’.
  • Resolved a JasperReports pagination issue.

Translations

  • Corrected some Japanese language translations for view security options.
  • Provided language translations for the text label "Filters" in the Automation Settings dialog box.

...

Expand

Infrastructure

  • Resolved an issue that would keep a LDAP user in a Yellowfin group after being deleted on the host.
  • Resolved an issue that would create multiple user accounts if a new user logged in via LDAP multiple times in succession.
  • Resolved an issue that would prevent a super user from being able to edit a draft of a private report.
  • Resolved an issue that would prevent a report from being deleted if it had been manually removed from the database.
  • Resolved an issue with password case sensitivity for the administrator user created during installation.
  • Resolved an issue that would prevent reports from being deleted in a batch selection when Share Private Content was turned off for the user's role.
  • Resolved an issue where a personal content creator could create public reports with the "Save As" function.
  • Resolved a potential security issue that could expose access to Yellowfin pages if a user visited the reset password page.
  • Resolved an issue that would cause users to retain access to dashboards after being removed from a user group until the instance was restarted or the caches were cleared.
  • Resolved an issue that would prevent user group membership changes from being applied to group hierarchies in client organizations.
  • Resolved an issue that would reset view security permissions when editing the View Security settings.
  • Resolved an issue with some instances of nested groups where group membership would not be calculated correctly.
  • Resolved an issue that would let some users without Update or Delete rights see content via Guided NLQ queries for views with Read Restricted or Edit Restricted settings.

Logging

  • Resolved an issue where deleting a broadcast from a report would not create a record in the Event database table.
  • Resolved an issue that would incorrectly add an NPE error to the log file when a user with specific role functions opened a report.
  • Resolved an issue that would cause an incorrect IpSource value to be written to the Events table when accessing a dashboard via the JS API.

Installer

  • Resolved an issue that would cause updates to fail when using the silent installer to upgrade from versions 8.0.10.3, 8.0.10.4, 9.7.0.2 and 9.7.0.3.
  • Resolved an issue where setting a custom installer.warfilename in the custom.properties file would prevent a Yellowfin 9.7 installation from completing.

Data

  • Resolved an issue where MySQL Connector 8.0 would return all available tables rather than just the tables available in the selected database.
  • Resolved an issue that would cause SAML SSO to stop functioning — if it was set up in Yellowfin 9.6 without the Service Provider Private Key and Certificate — by making the two fields optional (learn more).

Imports

  • Resolved an issue that would omit translations for calculated fields during report import.

REST API

  • Resolved an issue with the GET /categories endpoint in the REST API 1.3 returning incorrect parentCategory links.
  • Resolved an issue that would cause version 1.2 REST API category requests to return results for version 1.3.

JS API

  • Resolved an issue that would prevent images from loading on the Guided NLQ UI when passing an element to the JS API loadNLQ function.

Web Services

  • Resolved an issue where the DELETECATEGORY web service would not delete a sub-folder.
  • Resolved an issue that would prevent SSO from working correctly in some circumstances due to an existing web session.
  • Resolved an issue that would prevent the SOAP web service from exporting using the new PDF exporter.

Views

  • Resolved an issue that would prevent a user from editing a CSV view if a date function was added to the view and saved.
  • Resolved an issue that would prevent drill through creation on reports based on a copied view.
  • Resolved an issue with the date functions Week Start, Week End and Week of Year each being out by a day when applied to Sundays when using PostgreSQL or Redshift.
  • Resolved an issue that would cause an error when copying a freehand SQL view from the view’s Model page.
  • Resolved an issue that would cause reports based on cached Freehand SQL views to fail.
  • Resolved an issue with CacheDB that would prevent returning data from a view created from a stored procedure.
  • Resolved an issue that would prevent some views from being copied or exported.
  • Resolved an issue that would prevent Last Modified details for a view from being recorded unless specific changes were made to that view.

Content Export

  • Resolved an issue that would prevent reports with cached filter hierarchies from being exported.
  • Resolved an issue that would prevent shrink to fit from working on reports with a chart or canvas to the left or right of the report table.
  • Resolved an issue that would prevent filter values from being applied on a tabbed child report when exporting to XLSX.
  • Resolved an issue that would prevent XLSX exports from opening in MS Excel if they were based on JasperReports-based reports.
  • Resolved an issue that would cause the slow export of reports with conditional format icons.
  • Resolved an issue that would prevent action buttons on a canvas dashboard from maintaining their size when being exported to PDF.
  • Resolved an issue that would cause PDF page size issues when exporting JasperReports-based reports.
  • Resolved an issue that would fail to render SVG images in JasperReports-based reports.

Broadcasts

  • Improved the broadcast schedule to use the data source timezone as the default for reports, and the system's default timezone for dashboards (which may contain reports with different timezones).
  • Resolved an issue where using mandatory filters in reports would disable the feature of advanced broadcast recipients.
  • Resolved an issue where one or more mandatory filters with no default value would prevent the Current Filter Values option from being selected in a report broadcast.
  • Resolved an issue where bookmarks could not be used as filters in report broadcasts.
  • Resolved an issue that would cause a report broadcast to fail when a timestamp field was used as a filter.
  • Resolved an issue that would prevent broadcast delivery rules from functioning correctly if a timestamp field contained a date.
  • Resolved an issue where private reports would not broadcast to validated users.
  • Resolved an issue that would prevent the Different From broadcast delivery rule from functioning correctly.

Dashboards

  • Resolved an issue that would prevent dashboards with interaction links from being re-imported when using the "Replace Existing" option.
  • Resolved an issue where a canvas with missing report fields would not load in edit mode.
  • Resolved an issue where creating a new story widget, then undoing its creation, then redoing its creation, would display an incorrect layout.
  • Resolved an issue that would cause formatted action links to append the primary org ID instead of the client org ID.

Reports

  • Resolved an issue where applying conditional formatting rules to the Total field would inadvertently apply them to the main report.
  • Resolved an issue that would cause an error when configuring Link To relationships for a drill through report.
  • Resolved an issue that would prevent drill through to a child report when the parent report filters contained null values.
  • Resolved an issue when building dashboards that would prevent branched reports from having different interaction settings from their parent report.
  • Resolved an issue that would prevent a report created from a view with Edit Restricted enabled from being deleted.
  • Resolved an issue where, after selecting and adding a value on the calculated field "Current day +/- X days”, the value displayed on the page would not be updated.
  • Resolved an issue that would prevent valid users from editing a report if an access filter without any values was applied.

Guided NLQ

  • Resolved an issue that would prevent Guided NLQ answers from being saved as reports when the Unique Report Names setting was switched on.
  • Resolved an issue that would cause the Guided NLQ Ask tool to be cut off during an animation.
  • Resolved an issue where a user could run a Guided NLQ query with an incomplete Where block.
  • Resolved an issue that would prevent calculated date fields from being enabled for Assisted Insights and Guided NLQ.
  • Resolved an issue where updating the Granularity option of an associated date field in a Guided NLQ query could prevent the user from completing the query.

Filters

  • Resolved an issue that would prevent filters from showing up when opening a report from the Open Report sidebar button.
  • Resolved an issue that would cause the Dynamic Filter option to erroneously appear on a view-level filter.
  • Resolved an issue that would cause a cached filter to contain unexpected values when an access filter was enabled in the main query and subquery.
  • Resolved an issue that would prevent the Not In List filter from functioning correctly with timestamps.
  • Resolved the issue where filters set to Cached On Demand would not load values unless they had been manually refreshed.
  • Resolved an issue that would cause a date filter with Max or Min aggregation to display the filter format options for numbers.
  • Resolved an issue that would prevent wildcard access filters from working correctly in OLAP-sourced reports.
  • Resolved an issue that would prevent minimum and maximum options from appearing in the list of values for a dashboard filter even though they appear in the original report's filter
  • Resolved an issue that would cause filters to be marked as unavailable after deleting the filter list to which it previously belonged.
  • Resolved an issue that would not pass values to a child report if the parent and child filter entry types were not the same.

Charts

  • Resolved an issue where pie charts would display incorrect colors if a metric was used as a colour.
  • Resolved an issue that would cause inconsistent results when exporting JavaScript charts containing SVG masks.
  • Disabled trends for stacked area charts due a third-party library issue.
  • Resolved an issue where charts would not render if the legend was too large.
  • Resolved an issue that would cause radar charts to display a reference line label after enabling the Hide Label option.
  • Resolved an issue with the Histogram Auto Binning feature that would cause some values to go missing when outliers were present.
  • Resolved an issue that would prevent a pie chart from displaying if the Explode Slice setting was selected.

User interface

  • Resolved an issue that would prevent the Create menu from functioning when set to display in the Left Side Navigation panel.
  • Resolved an issue that would cause the minus sign on a value to appear as a suffix when used with bar conditional formatting right align.
  • Resolved an issue with field conditional formatting rules where typing any decimal number starting with “-0.” would automatically remove the minus sign.
  • Resolved the issue where tasks from deleted discussion streams would no longer be actionable.
  • Resolved an issue that would prevent the ‘Suppress’ drill through popup option in Content Settings from functioning correctly.
  • Resolved an issue that would cause the report tab selection to shift when drilling down.
  • Resolved the issue where sub queries would be listed as drill throughs on the pop-up warning message that appears when a user tries to delete a report.
  • Resolved an issue where filter values containing certain symbols would not be passed through correctly as part of a dashboard drill through.
  • Resolved an issue that would cut off the Drill Anywhere popup when the linking field is close to browser’s window edge.
  • Resolved an issue that would hide report editing options on the Browse page for users with edit access.
  • Resolved an issue that would cause a system error when maximizing a Report Snapshot or Report Bookmark popup from the discussion stream.
  • Resolved an issue where translation text would be inadvertently displayed when multi-language was enabled.
  • Resolved an issue with stories where users’ long job titles would push down the position of the Like button.
  • Added input validation to the First and Last Name fields under Profile Settings.
  • Improved the display of license information on the license page.
  • Resolved an issue that would prevent the dropdown list of user groups from displaying.
  • Resolved an issue that would cause the ‘Above’ Page Slider option to display both above and below a report.
  • Resolved an issue that would prevent dashboard and presentation widgets selected as a group from being duplicated.
  • Resolved an issue that would cause keyboard commands in dashboard and presentation edit modes to stop working after their initial execution.
  • Resolved an issue that would display an unnecessary warning message when sharing a dashboard or report with JavaScript Charts.
  • Resolved an issue that would prevent freehand SQL reports from being displayed in advanced search results on the Export page.
  • Resolved an issue where refreshing a filter’s custom query in an appended query would delete the associated SQL.
  • Resolved an issue that would prevent locale-based sorting from being configured for client organizations.
  • Resolved an issue that would cause a blank space to appear at the bottom of report tables on dashboard table widgets.
  • Reinstated the "Related" checkbox from Automated Insights Setup and moved it to the Automated Settings dialog box.

Signals

  • Resolved an issue where importing views with "Replace Existing" enabled would not replace the related Signals jobs.
  • Resolved an issue that would prevent charts from loading in Signals.
  • Resolved an issue that would cause the Spike/Drop/Breakout signal to show on daily basis even if its granularity was set to be higher (eg, hourly).

Assisted Insights

  • Resolved an issue that would prevent users from selecting the maximum number of fields (12) for Assisted Insights.

Mobile

  • Resolved an issue with the styling of the report filters popup on the mobile app.

...

Expand

Infrastructure

  • Added a toggle to the Admin Console to enable Guided NLQ for each client organization (learn more).
  • Added new silent installer options MySQLDisableSSL, DatabaseConnectionString and AdminDatabaseConnectionString.
  • Upgraded require.js to version 2.3.6.
  • Upgraded the jsoup library to version 1.14.2.
  • Upgraded the Apache XML Graphics Commons library to version 2.6.
  • Upgraded the Apache Commons Compress library to version 1.21.
  • Upgraded the Apache log4j library to version 2.16.0.
  • Upgraded PDFBox libraries to version 2.0.24.
  • Upgraded the ClassGraph library to version 4.8.116.
  • Upgraded the XStream library to version 1.4.18.
  • Added a tool to update repository configuration values when Yellowfin is not running.
  • Added an advanced configuration option to customize the broadcast filename format.
  • Improved access permissions checking performance when loading content on the Browse page.
  • Improved session security for active users which redirects to the login page after an allotted time, unless user input is detected.

Roles & groups

  • Added new Guided NLQ role functions Guided NLQ User and Guided NLQ Manager (learn more).
  • Enabled Guided NLQ functions for roles with access to creating and updating reports, and updating views.

Data

  • Added ClickHouse DBMS support, including LIMIT support to Clickhouse DB queries, and enabled Clickhouse UUID columns to be identified and used in Yellowfin (learn more).
  • Added LIMIT support to Vertica sources.
  • Added support for RSA and ECDSA algorithms for JWT authentication.
  • Enhanced SSO for JWT and SAML to support dynamic sessions entry options (learn more).
  • Aligned the existing SAML Bridge features with the more recent SAML implementation, including SP-initiated SAML workflow (learn more). 

JS API

  • Added the 'Ask a Question' UI of Guided NLQ as an embeddable object via the JS API (learn more).
  • Added functionality to allow namespaces for events on JS API objects.
  • Added the ability to unbind event listeners via the event name function in the JS API.
  • Added functionality to LoaderEvents to allow listening for specific elements (learn more). 
  • Added the ability to override child loaders for individual reports, replacing them with a singular loader for the parent element.
  • Added loading status indicators for content loading via the JS API.
  • Implemented the ability to listen to and prevent drill through report interaction events via the JS API.
  • Added the ability to manually configure the display of a drill through child report toolbar via the JS API.
  • Added the option to display chart animations via the JS API (learn more).

REST API

  • Added a new report listing endpoint.
  • Added a favorite reports endpoint.

Views

  • Enhanced view exports to include Guided NLQ configurations, and added a warning when importing Yellowfin 9.7 views into older versions.
  • Added predefined date periods Last Quarter and This Quarter to Date.
  • Overhauled the look and feel of the view builder, and added new options for configuring performance, security, and automation.
  • Improved database validation functionality which reduces overall processing times when cloning views.
  • Replaced the word “business” with “financial” in predefined filter date period labels, and removed the word "calendar" from other predefined filter date period labels.

Advanced functions

  • Added a number of advanced functions including:
    • SPC - Functions (moving average, UCL, LCL, outliers).
    • SPC Step Change.
    • Difference and Growth Truncate.
    • Top/Bottom N Percentage of Total.
    • Top/Bottom N Rank.
    • Periodic Average.
    • Percentage Against Accumulative Column.
    • Accumulative Percentage Against Column.
    • Days Between Date with Offset.

Content export

  • Added a configuration option to customize default settings for export plugins.
  • Enabled URL hyperlinks when exporting crosstab reports to XLSX format.
  • Improved the display of presentations on PDF exports.

Reports

  • Added the ability to create an Append sub query joined to a report on view fields not used in the report (learn more).
  • Added conditional bar formatting support for cells with negative values.
  • Enhanced the report pagination links.

Charts

  • Added Average, Accumulation and Trend functions to several non-auto area, bar, and column charts.
  • Added the option to rename the total column on a waterfall chart (learn more).
  • Enhanced functionality for waterfall charts by adding a Start column to indicate the starting position of the chart (learn more).
  • Added a color field to waterfall charts (learn more).
  • Updated the default chart colors for new installs.
  • Improved the display of line charts by setting a default order for line shapes used to highlight data points in a series.
  • Resolved an issue that would prevent a combined series trend line from activating for auto horizontal bar charts with the same category and color dimensions.
  • Streamlined chart variance display options and added Simple Percentage as a new chart variance type (learn more).
  • Improved the display of charts with borders on dashboards.

Broadcast

  • Added a new function to allow plugins to filter out email addresses before they are sent by Yellowfin.
  • Improved functionality which prompts the user to retain or cancel a scheduled task when running the task manually on the same day it is scheduled.
  • Improved report broadcast scheduling to include the status of the report in the event of an error.

User interface

  • Added a Guided NLQ entry point to the Create menu in the main toolbar (learn more).
  • Added the component Guided NLQ to the Licence Management page.
  • Improved Code Mode to take full advantage of the JS API (learn more).
  • Added an Open Report button to reports on published Stories which directs the user to the report's output page (learn more).
  • Renamed the Add Filters button on the Filters pop-up to Save (learn more here and here).
  • Restyled the default Yellowfin login page.

Localization

  • Added support for language-specific separators for decimals and thousands when using numeric filters.

...

Expand

Infrastructure

  • Added the advanced configuration option SHOWLOWMEMORYEXPORTOPTION, which adds a toggle to the Export Settings dialog box for individual reports to override the global setting for low memory exports.
  • Resolved a configuration issue with upgrading Java from pre-July 2021 to a post-July 2021 version that would cause the yellowfin.war file to be redeployed, losing custom changes to the web application.
  • Resolved an issue that would cause GroupCache removal messages to be delivered to cluster nodes with incorrect data.
  • Resolved an issue that would cause Yellowfin WAR file redeployment when upgrading from certain versions of Java.

Performance

  • Improved import page load times for systems with a large number of content folders.
  • Improved loading times when entering export and import pages.
  • Improved loading times when expanding the User and Group sections of the Admin Console.
  • Improved rendering on the Browse page for users with access to a large number of folders.

Data

  • Enabled the recognition of Snowflake database table timestamp fields with time zones.
  • Resolved an issue that would prevent third-party database connectors from loading data.
  • Resolved an issue that would prevent a replacement database from importing as the correct database type when a license limit had been reached.
  • Extended the ReferenceDay table to include dates up to the year 2030.
  • Resolved an issue that would prevent the creation of views based on Intersystem IRIS stored procedures.

Roles & groups

  • Resolved an issue that would prevent correct role names from being displayed in group member list.
  • Resolved an issue that would process groups containing roles incorrectly when using the GroupFlattenTask function.
  • Resolved an issue that would revoke owner access to a private report when read access was given to another user via the share pop-up.
  • Resolved an issue that would prevent a user from editing and copying other users' public dashboards (learn more).
  • Resolved an issue with personal dashboard permissions that would log a user out of Yellowfin when exporting certain file types.

Web services

  • Resolved an issue in the LOADDASHBOARDTAB and LOADPARENTDASHBOARDTAB web services that would prevent dashboard filters from being returned in a web service report.

JS API

  • Resolved an issue that would prevent date sliders from functioning correctly via the JS API.
  • Resolved issues that would affect drill through functionality in the JS API.
  • Added a report interaction that disables the Open Chart Image tooltip option.

Views

  • Resolved an issue that would prevent UUIDs from populating a CSV file when attempting to translate a view.
  • Resolved an issue that would create new field UUIDs for fields within cloned views instead of copying the existing field UUIDs.

Content export

  • Resolved an issue that would cause certain JS charts to duplicate when exporting to PDF.
  • Resolved an issue that would prevent Stories with certain embedded videos from being exported to PDF.
  • Resolved an issue that would prevent SVG <image> tags from exporting to PDF.

Broadcasts

  • Resolved an issue that would cause a broadcast to fail when the report included sub queries with filters.
  • Resolved an issue that would prevent report broadcasts and emails from being sent if a report was filtered with the ‘Equal to’ or ‘Different from’ operand.
  • Resolved an issue that would display broadcast URLs incorrectly when custom parameters were defined for Co-Display reports.

Dashboards

  • Enhanced the Canvas Properties panel display functionality.
  • Resolved an issue that would prevent the FILTER<ID> and FILTER<UUID> parameters from functioning correctly when used with a dashboard.
  • Resolved an issue that would prevent view-level filter groups from having their cached values refreshed from the dashboard.
  • Resolved an issue that would prevent view-level cached filters from refreshing when a report was imported.

Reports

  • Resolved an issue that would prevent access filters from functioning correctly if a certain combination of cached filters were applied.
  • Resolved an issue where cached filter values would not display for imported reports.
  • Resolved an issue that would cause an error when attempting to edit a report with a cached filter query.
  • Added a configuration option for locale-based sorting to improve performance issues for diacritics (such as é and ö) (learn more).
  • Resolved an issue for cross tab reports which would prevent subtotals from displaying in the correct layout.
  • Resolved an issue that would prevent advanced functions from being used in drill through links.
  • Resolved an issue that would return empty data in a report that used a date parameter in a calculated field.

Charts

  • Improved the Auto-Hide Legend option to automatically hide chart legend items when they exceed a pre-configured amount (learn more).
  • Reinstated numeric axes as the default value for the Default Gridlines option on new installs.
  • Streamlined the Axis Title Text dropdown menu options.
  • Resolved an issue that would cause an error on certain selected chart series when linked by a conditional drill through.
  • Resolved an issue for numeric display charts that would display the default formatting prefix when using a percentage variance.
  • Resolved an issue that would prevent the correct display of the trend line color for a chart series or color selection.
  • Resolved an issue that would prevent the mean trend line color from saving.

User interface

  • Resolved an issue that could cause canvas reports in stories to be cropped.
  • Improved thumbnail generation to properly scale for better display on desktop and mobile app.
  • Resolved an issue that would cause a date slider display error on a chart after toggling to and from its table, if the table contained pagination buttons.
  • Resolved an issue that would cause a time slider display error on a published dashboard when using a tabbed Section Style in Section Formatting.
  • Resolved an issue that would cause an error after switching to code mode from preview mode, and prevent the use of the Delete Code Mode Content feature.
  • Resolved an issue that would cause the report to re-run on the chart builder page.
  • Resolved an issue that would cause the SSL Required field name in the Create Data Source dialog box to display as 'undefined'.
  • Resolved an issue that would prevent dependent filters from correctly updating their values in the story Filter panel.
  • Resolved an issue that would prevent users from closing the warning pop-up that would appear when deleting a drill through filter.
  • Updated the description text for List Size in Filter Formatting.
  • Resolved an issue that would prevent report cancellation requests when a user navigated away from the dashboard.
  • Resolved an issue that would prevent the Refresh tab from being hidden when saving a report, even when the Hide Report Refresh role function had been enabled.
  • Resolved an issue that would prevent the report column drop-down list from appearing after re-rendering.
  • Resolved an issue that would prevent the Row Highlight function on dashboard reports from highlighting the entire row.
  • Streamlined all approval notifications to match those for reports and views.
  • Streamlined the positioning of page sliders for dashboard reports.
  • Streamlined the report column pop-up options.
  • Updated the title of the Properties pop-up for associated reports and video widgets (learn more).
  • Updated the Yellowfin Community and Wiki links on the Admin Console, and in the installer and updater.

Mobile

  • Resolved an issue where single sign-on would not function for legacy versions of the Yellowfin app on iOS and Android.

...

Expand

Infrastructure

  • Improved the performance of the logic used to determine a user's access to dashboards.
  • Upgraded the JS library TinyMCE to version 5.8.2.
  • Upgraded the JSch library from 0.1.55 to 0.1.63 to support more ciphers.

Data

  • Improved the management of repository database connection resources on the Report Builder page.
  • Added additional database indexes to the repository database to accelerate queries running against tables related to dashboards and images.
  • Added an advanced configuration to control some Oracle data source objects and synonyms (learn more).
  • Added a validation filter condition to Teradata calculated field validation.
  • Removed legacy drivers for Big Query and Hive proxy JDBC, and updated the Hive connection wizard to accept the official Hive driver and to exclude the outdated DriverPath connection parameter.

JS API

  • Implemented the ability to listen to dashboard loading events via an object on the window.
  • Added the option to white label the JavaScript API from the Yellowfin configuration UI (learn more - see the General Settings table).
  • Improved CSS load speed within the JS API.

REST API

  • Added support for creating a login token from the REST API for the current user without requiring the current user's credentials (allowing REST API consumers to use the JS API or redirect to the web app without the user having to re-enter their credentials).

Reports

  • Added a new report layout option that enables scrollbars for canvas reports on dashboards if they don't fit their container.

Charts

  • Updated the tooltip for layered bar charts to display all bar values on hover, as well as the total for the entire bar.
  • Tweaked the code for parsing browser width and height to improve chart sizing on the page.

User Interface

  • Improved report loading speed by eliminating superfluous load requests.
  • Improved the vertical alignment between toggle filters and their label names to be vertically centered.
  • Improved the layout, content and sections of the Action Button Properties panel.

...

Expand

Infrastructure

  • Upgraded Tomcat to 9.0.50 for new installations.
  • Improved memory management during view save and load processes.
  • Improved the security of the Browse page.
  • Resolved individual potential vulnerabilities with:
    • content folder management;
    • the input area of report approval messages;
    • The approval step before publishing reports to private folders;
    • the availability of report detail summary information;
    • the reference code manager;
    • unauthorised user session access to the Admin Console;
    • the quick login functionality;
    • email templates;
    • storyboard slide editing settings and sharing;
    • image access and user profile image functionality;
    • attaching links and videos to comments.
  • Resolved an issue that would allow users to view a report with data from a restricted-access subquery view before the report’s first run.
  • Resolved an issue where creating a view from the MIPreReportInit.i4 page would fail.
  • Resolved a misconfiguration issue with the static resources identifier when loading a plugin.

Logging

  • Resolved an issue that would prevent an event from being recorded after moving a content item from Favorites on the Browse page.
  • Resolved an issue where the event table would not log events for exports to XLSX and CSV file types.

Data

  • Resolved an issue where DB connection pool deadlocks could occur, even when connection pooling was not in use, when the connection limit was reached.
  • Resolved a potential security issue that could arise during the testing of data source connections.
  • Resolved an issue that would cause an exception when a Salesforce data source launched pre-built content.
  • Resolved an issue where a view could not be changed to use a data source from a different database type.
  • Resolved an issue that would cause the Geometry data type to be misinterpreted when using an SQL Server data source.
  • Resolved an issue that would cause the access filter schedule to always use the Append refresh type.
  • Resolved an issue with view relationships where reordering table conditions would cause any other changes to be lost.
  • Resolved an issue with the View Builder that would cause the table filter to reset when viewing more than one page of search results.
  • Resolved an issue where calculated fields using custom functions with the DateTime data type would pass the date value only (no time value) into the SQL query.
  • Resolved an issue that would prevent OLAP Cube sub queries from working.
  • Resolved an issue where OLAP sub query filters would not add offsets to dynamic dates.
  • Resolved an issue that would prevent a dashboard from being exported if it contained a drill through to a  dashboard with a filter belonging to a report's sub query.
  • Resolved an issue that would prevent the deletion of a view created from a report.
  • Resolved an issue where saving stored procedures would not adhere to the Include Schema in SQL option, and improved functionality so that stored procedures can be saved without the schema component, enabling cross-schema datasource substitution.
  • Resolved an issue that would cause orphaned database records if view cloning failed.

Roles & groups

  • Resolved an issue that would prevent the role function Show Draft Dashboards from working as expected.
  • Resolved an access issue with the Hide Browse role function.
  • Resolved an issue that would cause members of client org user roles to be excluded from client groups that their roles had been added to.
  • Resolved an issue where users and user groups would not be deleted after the client org they belonged to had been deleted.
  • Resolved an issue that would prevent the User Group Members list from displaying more than ten users.
  • Resolved a potential security vulnerability when retrieving the list of discussion group members.

Installation

  • Reverted changes made in 9.6 to the Show Duplicate Records toggle in the View Builder for smoother upgrades.
  • Resolved an issue that would prevent the migration process from running on the target instance if no external URL had been set in the source instance.
  • Resolved an issue where if a problem produced the JDBC error message during Yellowfin installation, the error message would also display the DB password.
  • Resolved an issue where the database password would display when installing Yellowfin through the command line.
  • Resolved an issue that could cause some unexpected text in some messages on brand new Yellowfin instances with tutorial content installed.
  • Resolved an issue with using encrypted licenses with Yellowfin.

Data migration

  • Resolved an issue that would prevent files exported from older versions from being imported via the REST API.
  • When migrating dashboards from pre-9.0 releases to 9.5 or later releases, resolved an issue that would cause associated reports to disappear, or appear in the wrong location, after migration.
  • Added a migration job that updates the statuscode of contentmanagement records to OPEN when the statuscode is DRAFT.
  • Resolved an issue that could cause some content not in OPEN state to attach to export files as dependencies.
  • Resolved an issue that would cause a report with two or more custom query filters from a different data source to export with only one of those custom query filters.
  • Resolved a potential vulnerability with the handling of data source passwords during the import process.
  • Resolved an issue that would prevent filters on a dashboard with code mode from applying after import.
  • Resolved an import error on report views with deleted records.
  • Resolved an issue would ignore the selection of the custom query filter data source option during import.

JS API

  • Resolved an issue where setting the possible values via the JS API would not work correctly with a pop-up filter.
  • Resolved an issue that would prevent JavaScript charts from loading on embedded dashboards.

Content Export

  • Resolved an issue where switching export types via the Export popup would stop an export.
  • Resolved an issue where exports would sometimes erroneously fail with a ‘Content Has Changed’ message.
  • Resolved an issue that could prevent some multi-tab dashboards from exporting.
  • Resolved a layout issue that would cause exported co-display reports with sections to separate tiles from reports if the export didn’t fit on a single page.
  • Resolved an issue where canvas formatting would not be applied to report canvases on the Print Preview pop-up.
  • Resolved a PDF export issue that would cause tables to break incorrectly when the header and footer heights were vastly different values.
  • Resolved an issue that would prevent the Filter API from reporting the correct values when exporting to PDF.
  • Resolved an issue with static layout dashboards where a width greater than 1000px would not shrink to fit when exporting to PDF.
  • Resolved a PDF export issue that would prevent row-based report exports.
  • Resolved an issue that would prevent exports to PDF when CSRF Filters was enabled.
  • Resolved an issue where exporting reports to PDF using certain fonts would cause tables to break in unexpected places.
  • Resolved an issue that would prevent the correct layout of long report names or descriptions when exporting co-display reports to PDF.
  • Resolved an issue where row-based reports would render inconsistently when exporting to PDF.
  • Resolved an issue where PDF exports with Suppress Duplicates enabled would not export labels for custom-width columns.
  • Resolved an issue that would cause the bottom border to disappear on reports exported as PDF or DOCX with Suppress Duplicates turned on.
  • Resolved an issue that would prevent images in the header and footer of a report from exporting correctly to the DOCX file format.
  • Resolved an issue with DOCX exports including actual data values when a conditional format using icons is used
  • Resolved an issue with conditional formatting icons not being displayed on total and subtotal rows in DOCX, PDF and XLSX exports
  • Resolved the issue of conditional formatting icons not being available in XLSX exports.
  • Resolved an issue with conditional formatting legend missing for total and subtotal rows in XLSX exports

Broadcasts

  • Resolved some issues around content display within the new broadcast subject line filter tags including:
    • inconsistent date formatting/dynamic date display;
    • incorrect unicode character rendering; and,
    • empty subquery filter tag content.
  • Improved the format of broadcast email filter tags that contain multiple filter values.
  • Resolved an issue where filtering a report date field with the ‘In list’ operand, then using the date field in a broadcast filter tag, would prevent the broadcast from running.
  • Resolved an issue that would prevent reports with timestamp filters from broadcasting.
  • Resolved an issue that would flag a report broadcast schedule with Success even when it had failed to generate a PDF.
  • Resolved several issues around schedule management, including incomplete deletion of tasks related to a ref code, and tasks without descriptions not being searchable.
  • Resolved an issue that would cause inaccurate broadcast counts, which led to some EventCache performance enhancements.
  • Resolved an issue that would prevent broadcasts from running after upgrading to 8.0.10.1 or 9.6.

Dashboards

  • Modified the publishUUID migration job for dashboard and presentation canvasses so their changes are committed incrementally to the database.
  • Resolved an issue that would prevent filter linking between advanced functions on a dashboard.
  • Resolved an issue that would prevent advanced function filters and filter links from being imported or migrated during an upgrade.
  • Resolved an issue that would cause the preview/edit toggle mode to change when switching between tabs to a new sub tab with global content.
  • Resolved an issue where brushing would not be disabled for canvas sub tabs even when toggled off.
  • Resolved a timing issue that could cause the wrong report display type to be rendered in the dashboard canvas editor.
  • Resolved an issue where a drill up triggered from the report menu would not be reflected in the child report of a dashboard drill to drill report interaction link.
  • Resolved an issue that would prevent CSS on code mode dashboards from being removed from the page when the user left the tab.

Reports

  • Resolved an issue that would cause the Moving Average analytical function to use incorrect rows during calculation.
  • Resolved an issue that could prevent report data time/date fields from displaying according to the user’s set time zone.
  • Resolved an issue that would cause a report and any dashboard it was embedded on to endlessly load if it contained a drill through to a dashboard with a filter belonging to a report's sub query.
  • Resolved an issue that could skew the layout of report headers with Report Header Lock enabled.
  • Resolved an issue that would ignore text alignment in columns of set widths.
  • Resolved an issue that would cause a skewed display of filter panel titles in edit mode.
  • Resolved an issue that would prevent the Suppress Duplicates option from working on fields with subtotals set.

Filters

  • Resolved an issue that would cause date functions placed within filter groups to generate incorrect SQL.
  • Resolved an issue that would cause incorrect user prompt filter values for a report with Minus sub queries.
  • Resolved an issue that would allow the user prompt filters to trigger additional runs of a report already running.
  • Resolved an issue that would prevent dependent filters using the list entry style from resetting to the correct default filter values.
  • Resolved an issue that would cause filters to lose their insertion order when adding multiple sub queries.
  • Resolved an issue where filter links would not be updated after a dashboard was edited.
  • Resolved an issue where the Min/Max filter options would be missing for custom query filters on dashboards.
  • Resolved an issue that would prevent filters from resetting to their default values when the Dynamic Default Filter setting was enabled.
  • Resolved an issue that would ignore the number placed in the List Size field of the Filter Formatting panel.
  • Resolved an issue where checkbox filters would show unnecessary scroll bars by reimplementing the List Size parameter on dashboards to configure list and checkbox filter scroll bars.
  • Resolved an issue that would cause an error when dependent filters from multiple reports on a dashboard had their parent filter values changed at the same time.
  • Resolved some display issues with the left filter navigation panel, including buttons that would be hidden when switching modes and filter groups that would collapse on each other.
  • Resolved an issue with conditional drill through that would cause child filters to fail to link if they were created after the drill through was set up.

Charts

  • Added Null Behavior options to category-based charts.
  • Resolved an issue where the horizontal axis display name on a trellis vertical bar chart would use the vertical axis display name.
  • Resolved an issue that would prevent conditional colors from showing on a time series bar chart with a metric color field.
  • Resolved an issue that would block conditional formatting on an auto chart when coloring by the metric field if no color field was present on the chart.
  • Resolved an issue where importing an area chart on a cross tab or an area chart with dimension color would not import the opacity setting for an entire series.
  • Resolved an issue where a trend could be broken and wasn't being identified as a problem field within the report builder.
  • Resolved an issue on some charts that would cause multiple points from the same line to be selected on mouse hover.
  • Resolved an issue that would cause tooltips to appear in the wrong place when using animated charts.
  • Resolved an issue that would cause the tooltip on time series forecasts to hide data in certain languages.

Stories

  • Resolved an issue that would prevent a story’s screenshot from cropping on a large screen.
  • Resolved an issue where users who were not original contributors of story templates could not create new stories based on those templates.

User Interface

  • Resolved an issue that would prevent user details from being updated if they had a password expiry date set.
  • Resolved an issue where a dashboard could be added to the Favourites area multiple times.
  • Resolved an issue that would cause an empty toolbar to be displayed to users who had not selected a dashboard to load at login.
  • Resolved an issue that would prevent users from using the drag-and-drop functionality to move certain content items to and from folders on the Browse page.
  • Resolved an issue that would prevent changes to the Custom Share Email Sender config fields from being saved when client orgs are enabled.
  • Added an option to disable text encoding/escaping for the Action Button URL formatter (learn more).
  • Resolved an issue where canvas widgets could not be sent backwards or forwards on the canvas when grouped.
  • Resolved an issue that would cause the Publish pop-up to appear when changing tabs in the Model step of the View Builder.
  • Resolved an issue that could cause the Prepare step of a view to stop loading.
  • Resolved an issue where the toggle changes on the Performance section of the View Options panel would not be saved.
  • Resolved an issue where changing the canvas width via the Dashboard Properties panel would cause the sub tabs selector menu to disappear.
  • Resolved a positioning issue with the Action sub-section of the Properties panel on static layout dashboards.
  • Resolved an issue that would prevent the export of SQL when requested via the SQL Statement tab of the Information popup for a dashboard.
  • Resolved an issue where sticky global containers would not inherit the dashboard background color.
  • Resolved an issue that would prevent the Legend Title and Description formatting fields from updating on a report.
  • Resolved a display issue that could occur when hiding the first field in a cross-tab report.
  • Resolved an issue that would cause multiple scrollbars to appear on a report upon opening a dialogue box.
  • Resolved an issue that would prevent users from editing conditions with NULL/NOT NULL operators in the Conditional Formatting pop-up.
  • Resolved an issue where Jasper reports with multiple filters would incorrectly display duplicate filters.
  • Resolved an issue that would cause the Select All toggle on checkbox lists in the filter panel to stay on after resetting the filters.
  • Resolved an issue that would not allow users to change the entry style of a view-level filter on dashboards.
  • Resolved an issue that would prevent the date filter from functioning correctly upon clicking apply a second time.
  • Resolved an issue that would cause HTML characters to be displayed within the popup text when linking filters.
  • Resolved an issue that would cause the filter control panel to display out of bounds in some languages.
  • Resolved an issue that would cause the Reset link to be incorrectly greyed out instead of clickable.
  • Resolved an issue that would cause the left side nav filter panel to remain open after applying filter updates.
  • Resolved an issue with client orgs that would cause the left side navigation to disappear on dashboards that used a different navigation style setting to their parent org.
  • Resolved an issue that would allow zooming out to one level further than allowed on a GIS map.
  • Resolved an issue that would prevent changes to the Chart Series Settings panel from saving when there were too many categories on a chart.
  • Refreshed the Create New Presentation pop-up design including easier scrolling and visible theme titles.
  • Resolved an issue on published presentations that would allow a user to right-click on a slide to see the Edit option.

Translations

  • Improved some phrasing in our French UI.
  • Added short month names to the Thai translation so they are shown correctly on the calendar.

...

Expand

Infrastructure

  • Resolved an issue where, after exporting to PDF and sending via email, Yellowfin would continue to check for export activity.
  • Resolved a performance issue when rendering a large amount of cached filter values into a report or dashboard.
  • Resolved an issue that could sometimes cause high CPU usage when running reports and receiving export notifications.
  • Resolved a latency issue that would prevent chart color defaults in the Admin area from saving.
  • Removed unused jQuery resources after upgrades.
  • Resolved an issue where the command line installer would incorrectly state that it had installed the tutorial data.
  • Resolved an issue where upgrading from Yellowfin 7 would cause the Browse page to hang.
  • Resolved an issue that would cause an upgrade from Yellowfin 8.0.8 to halt if the license file could not be found.
  • Resolved an issue where a license with multicast disabled would affect the user's ability to use webservices when saving reports.
  • Resolved an issue where a license with concurrent mode disabled would give an incorrect licence breach warning.
  • Improved security by implementing a feature that allows the two-way encryption key to be replaced with a custom key.
  • Resolved a potential security vulnerability with the activity stream.
  • Resolved a potential security vulnerability when exporting reports to PDF and DOCX formats.
  • Resolved a potential security issue with the translation import/export page.
  • Resolved a potential security issue when adding users through the User Import window.
  • Resolved a potential security vulnerability in the Story Editor and its controls.
  • Addressed a potential XSS issue with custom header and footer includes.
  • Resolved a potential access control issue on private discussion streams.
  • Resolved an issue that would allow edit access to views stored in a secure folder.
  • Added a nonce to every application request to prevent duplicate submissions (learn more).
  • Resolved an issue that could cause an unexpected error when performing chart brushing when Yellowfin was installed on an HSQL configuration database.
  • Resolved an issue where Datasource Creation and Datasource Edit actions would fail when the datasource contained thousands of schemas.
  • Resolved an issue that would cause certain reference code synchronisation jobs to fail.
  • Resolved an issue where client orgs would not display Signals analyses based on the views from the primary org.

Data

  • Resolved an issue where applying a Boolean filter with a BigQuery data source would cause an error to appear.
  • Resolved an issue where BigQuery filters would throw SQL errors if they contained apostrophes.
  • Resolved an issue that would cause a "resource exhausted" error in the Google Sheets connector (learn more).

JS API

  • Resolved an issue with the Yellowfin JS API, which would overwrite any other copies of jQuery with the global copy included with the JS API.
  • Resolved an issue that could prevent CSS from loading within the JS API with certain proxy and firewall configurations.
  • Resolved an issue that would prevent signal lists from displaying properly when embedded in the JS API.

REST API/Web Services

  • Resolved an issue where the TESTIMPORTCONTENTNOVALIDATION web service call would still perform validation.
  • Resolved an issue where client organization substitute data sources would be hidden when using SOAP services and the REST API.
  • Resolved an issue with the SOAP web service function SAVECONFIGURATION which would not update for a few specific configurations.

Imports

  • Resolved an issue where importing an older report would fail if a chart had multiple reference lines with multiple colors defined.
  • Resolved an issue that would cause bulk user imports to fail on Yellowfin instances using Oracle databases.
  • Resolved an issue where filter links on a dashboard with code mode could break when imported.
  • Resolved an issue where importing code mode dashboards with images could lead to the wrong ID for some images, breaking their display.
  • Resolved an issue with transformation flows where a large delimited file could not be extracted.
  • Resolved an issue with ETL item import that could prevent reports from being editable.

Content Export

  • Resolved an issue where switching export types via the popup would stop an export.
  • Resolved an issue that would cause special characters in HTML fields to be exported to XLS as HTML entities (eg, “&aacute;” instead of “á”).
  • Resolved an issue where exporting a co-display tabbed report to some formats would export only the content from the first tab.
  • Resolved an issue where the “shrink to fit page width” setting would not shrink for co-display report exports.
  • Resolved an issue with some versions of Java that would prevent the PDF exporter from starting.
  • Resolved an issue where switching export types via the popup would stop an export.
  • Resolved some layout issues for PDF exports which would cause:
    • early page breaks on some pages;
    • excess whitespace when the “Scale to Fit Page Width” option was enabled;
    • certain images to be misplaced on a canvas when shrink to fit was enabled;
    • some SVG images to be rendered at low resolution;
    • some table borders to go missing;
    • the view summary to go missing when using a preferred PDF font;
    • the report title and description to be wrapped at report width (rather than page width);
    • blank PDFs when exporting the first slide in a presentation with the Export Slides ‘Current’ radio button selected;
    • some translated words on charts to appear in their original language; and,
    • row-based reports on dashboards to go missing.
  • Resolved an issue that could cause reports to export as blank PDFs on some Java versions.

Views

  • For customers upgrading to 9.6, we switched on the ‘Show Duplicate Records’ toggle for all drag and drop views to avoid excess preview processing times.
  • Resolved an issue that would stop a valid view-level calculated filter from being saved.
  • Resolved an issue with view-level cached filter group filters, which would not automatically link correctly when added to a filter list.
  • Resolved an issue that would prevent the Show Duplicate Records toggle from functioning in views.
  • Resolved an issue where a view-level Freehand SQL calculated filter could not be saved after editing.
  • Resolved an issue that would prevent the download of view summaries for SQL views.
  • Added an optional configuration for Yellowfin to create SQL statements with views created from an identical data source to resolve a 7.1 upgrade issue where queries would display incorrect data.

Dashboards

  • Resolved an issue that would prevent users with only the Personal Dashboard role function enabled from creating private dashboards.
  • Resolved an issue where cloning a view used by a report on a dashboard would not update the dashboard filter settings.
  • Resolved an issue where filters applied on the dashboard would be cleared after reloading the page.
  • Resolved an issue where an enabled Dependent Values option in a filter hierarchy would have no effect on the child filter value list when switching back to a dashboard tab with previously applied parent filters.

Reports

  • Resolved an issue that would cause a user to lose read access to reports if private report sharing was disabled in the user’s role.
  • Resolved an issue that would cause Freehand SQL reports to automatically suppress duplicate cells.
  • Resolved an issue where manually sorting the order of a table column would cause the new order to persist even after resetting it.
  • Resolved an issue where reports created by the Google Analytics connector would cause system errors.
  • Resolved an issue where nulls would only display as zeros on column totals when “Nulls as Zeros” column formatting was enabled for cross tab reports.
  • Resolved an issue with the Division By Column(s) advanced function which would treat a calculation result of zero as null.
  • Resolved an issue where a drill through to a report would not work after switching sub tabs and returning.
  • Resolved an issue that would prevent the display of a report drill through link when the target report used an advanced user prompt filter.
  • Resolved an issue where drill through report settings could not find sub query filters from the target report.

Filters

  • Resolved an issue where previously applied filter values would not be cleared when a bookmark was applied.
  • Resolved an issue that would prevent the option to use min/max values for cached filters from saving.
  • Resolved an issue that would prevent filter values from being obtained for reports created from Freehand SQL views with access filters enabled.
  • Resolved an issue with Drill Through to Dashboard that would cause both the values of a Between filter to be read as one value.
  • Resolved an issue that would prevent a drill through link from being set when using a default child value for a mandatory filter.
  • Resolved an issue where the operators ”In List” and “Not In List” would not accept a filter value of zero.
  • Resolved an issue where using action buttons to reset a “between” filter would not fully reset the filter results.
  • Resolved an issue where report filters would automatically replace custom regional decimal separators with default full-stops.

Charts

  • Resolved an issue where custom colors would not show on multi pie charts.
  • Resolved an issue where custom color series would not work on a cross tab-based chart when using a Date Part formatted value.

JS Charts

  • Resolved an issue where dynamically scaled JavaScript charts would fail to render correctly when published.
  • Resolved an issue that would cause JavaScript charts to disappear on the chart canvas.

Broadcasts

  • Resolved an issue where a broadcast would stop sending content to any remaining valid recipients after encountering a single failed delivery address.
  • Resolved an issue where broadcast schedule jobs would sometimes be marked as successful despite some of the reports failing to run.
  • Resolved a timing issue in the Task Scheduler which would cause duplicate task runs in a clustered environment.

User Interface

  • Resolved an issue where an "unsaved changes" warning would show when switching from the Email tab to another tab on the Configuration page in a newly added client organization.
  • Resolved an issue in user group management where clicking the Add button for a dashboard tab before selecting a tab would cause an error.
  • Resolved an issue that would cause the top button on the navigation menu to overlap with other buttons when a user’s profile was disabled.
  • Resolved an issue that would cause some specific escaped characters to be displayed.
  • Resolved an issue where the yellow Create button would disappear after opening the screenshot option from the activity stream.
  • Resolved an issue that would not the count stories and views in the favorites count on the timeline.
  • Resolved an issue that would cause the timeline Connections panel to omit the display of contacts followed.
  • Resolved an issue where license reminder values would not load correctly on the license reminder page.
  • Resolved an issue where a broken content folder could cause the New Folder pop-up to omit the Folder Hierarchy section.
  • Resolved an issue where the export search would not work if there was a broken content folder in the system.
  • Resolved an issue that would prevent client organisation reports from launching if CSRFFilter was enabled.
  • Resolved an issue where discussion streams could not be deleted.
  • Resolved an issue that would prevent comment and task deletion from discussions with list view layouts.
  • Resolved an issue where editing a task comment from the discussion panel would not open the popup for editing.
  • Resolved an issue with an incorrectly labeled button when saving views as drafts.
  • Resolved an issue where the field list in the Field Settings dialog box of the view builder would disappear after a failed attempt to delete a column.
  • Resolved an issue where changing an action button font could cause vertical misalignment.
  • Expanded the maximum width of custom formatting labels to prevent overlaps in other languages.
  • Resolved a hover icon display issue where the chart/report toggle icon on a dashboard would default to show the chart image.
  • Resolved an issue where presentations would be displayed upon login instead of the dashboard.
  • Resolved an issue where resizing a dashboard canvas with the drag handle would display on the screen but would not be saved.
  • Resolved an issue that could sometimes cause an error when loading a dashboard page.
  • Resolved an issue where displaying the page title, user and role information in the header would cause whitespace when viewing dashboards on an iPhone.
  • Resolved an issue where an unnecessary horizontal scrollbar would be present in Dashboard Edit mode.
  • Resolved an issue where selecting ‘shrink to fit’ on a dashboard tab would inadvertently set the dimensions to zero.
  • Resolved an issue where the word ‘Reports’ would incorrectly display when selecting other content types to add to a dashboard.
  • Resolved an issue where dashboards would not respect custom widths set for report columns (read more).
  • Resolved an issue that would cause long reports to overflow their bounding box on static layout dashboards when the Auto Height option was enabled.
  • Resolved an issue that would cause breadcrumbs to work incorrectly on a co-display report with drill through enabled.
  • Resolved an issue that would prevent filter list display names from being renamed or hidden in real time when editing dashboards.
  • Resolved an issue where drill through popups would not display in full-screen dashboard mode.
  • Resolved an issue that would cause report tabs with long translations in other languages to overlap in edit mode.
  • Resolved an issue where a secondary scroll bar would appear in the Create Simple Report View pop-up.
  • Resolved an issue where operands breadcrumbs would sometimes display incorrectly.
  • Resolved an issue that would cause subtotal rows to display the title text from the row above.
  • Resolved an issue where a row highlight color set in the report builder could not be removed.
  • Resolved an issue where the value list display limit would be ignored for checkbox filters.
  • Resolved an issue with a missing scrollbar for filters with more than twenty options displayed as radio buttons.
  • Improved the layout of long-width filters and their control buttons.
  • Resolved an issue where drill down to filter links would not refresh when drilling up multiple levels using breadcrumb navigation.
  • Improved the display of left-side filters on dashboards by realigning the magnifying glass.
  • Resolved an issue where filters could not be applied on a dashboard if the Apply button style was configured to be a link instead of a button.
  • Updated the descriptive texts for report filter settings, which were around the wrong way.
  • Resolved an issue that would cause text filters to set cursor focus to the bottom filter on page load.
  • Resolved an issue that would cause long-running reports to run without providing the user with options to cancel or to run it in the background (learn more).
  • Resolved an issue where the PDF export panel would not render correctly for the older (V1) PDF plugin.
  • Added a loading indicator to the report broadcast page while broadcast instances are loading.
  • Resolved an issue where broadcast failure notifications would not activate when enabled through the Administration settings.
  • Resolved an issue where story screenshots would render partially transparent.
  • Resolved an issue that would cause slide thumbnails to break when flicking through slides too quickly.
  • Removed an unnecessary warning for presentations without reports on the import/export page.
  • Updated some UI text inconsistencies on pop-up displays and when returning to a presentation from a report that would incorrectly display “Dashboard” instead of “Presentation”.
  • Resolved an issue where changing the UI language would not update the language or the total color on a waterfall chart.
  • Resolved an issue that would cause sectioned charts to appear without a scrollbar on dashboards, making all other sections of the report unreachable.
  • Resolved an issue which would cause long time zone text to overlap the down arrow next to it in step 2 of a Signals Analysis.

Translations

  • Updated the German phrasing for "Present" in our German translation file.
  • Resolved an issue where the run errors for broadcast failure messages would sometimes show a resource string rather than translated text.
  • Resolved an issue where delimiters would be displayed with translated text.

...

Expand

Infrastructure

  • Upgraded Jackson Databind libraries to 2.12.1.
  • Updated Tomcat to version 9.0.43.
  • Upgraded commons-io from 2.2 to 2.8.0.
  • Reinforced security in the dashboard approvals workflow.
  • Added a server configuration field to adjust the maximum upload file size (learn more).
  • Implemented a new JWT entry mechanism that will accept a JWT token and use the contents to provision a new session (learn more).
  • Improved JavaScript loading speed on some pages.
  • Improved performance when editing views by caching table metadata, which reduces latency when using large views or slow datasources.
  • Improved performance for Snowflake datasources.
  • Added an option to record unsuccessful login attempts for non-users in the Yellowfin event table (learn more).
  • Implemented a configuration item to blacklist certain event types from being added to the Event log.
  • Improved logging for ReportEditKey validation.
  • Added DB-level support for GMT offset timezones.

JS API

  • Added a new PublishUUID attribute that replaces the use of the WidgetUUID attribute in code mode/JS API/code widgets for new and updated widgets. This allows users to identify widgets in a more unique way with a persistent identifier across dashboard edits and versions (learn more here and here).
  • Scoped the CSS of embedded content to prevent our JS API styling from leaking into external pages (all elements are now children of app-report, app-dashboard, app-story or div.yfContainer).

REST API

  • Resolved a REST API issue where sometimes a server/database error could cause a 401 response to be returned instead of a 500 response.
  • Updated the version handling of all REST API endpoints (no change for consumers).

Content Export

  • Improved story PDFs when exported to large pages up to A0.
  • Implemented notifications for lengthy PDF export downloads, and improved the PDF download process to continue after navigating away from a page.
  • Added a security check to ensure that PDF export cannot be performed without the required role function.
  • Added the option to share a dashboard as a PDF via email.
  • Implemented the option to add dashboards to the export list via the Export dropdown menu.
  • Added the option to save the current settings of the export panel for PDF.
  • Added the option to select which sub tabs and slides to export via PDF.

Reports

  • Improved chart navigation by adding a Drill Up menu option to the pop-up menu after drilling down to the Other segment.

Filters

  • Added new options for determining whether other report filters are applied when caching filter values, and for limiting the complexity of the queries used to load cached filter values (learn more).
  • Added the choice to enable optional filter values for Freehand SQL (this requires proper parameterised SQL text), allowing users to enter a value into a user prompt, or leave it blank, for Freehand SQL filters.
  • Improved the robustness of filter loading when directing a user to a dashboard via SSO.
  • Improved the Dashboard Properties panel to include additional configuration options when the Left Filters toggle is enabled in edit mode.

UI

  • Added additional font sizes to drop downs for charts
  • Added input arrows to the numeric inputs within the background section of a canvas widget.
  • Added tooltips for:
    • the Copy and Delete tools within Present;
    • each blueprint report widget and changed their order; and,
    • the Broadcast tool for dashboards.
  • Added a button to exit full-screen mode for Present.
  • Improved the Properties panel for widgets to hide additional border options if no border style is selected.
  • Improved visibility of all canvas widgets during drag and drop by making the dragged widget semi-transparent.
  • Changed the widget action toolbar to pop up only when a widget is clicked on, rather than hovered over.
  • Changed the default focus of the pop-out Dashboard Properties panel to the Sub Tab section, and of the Present Properties panel to the Slide section.
  • Added the keyboard shortcut CTRL+A/CMD+A to select all widgets on a draft canvas.
  • Improved dashboard edit mode by suspending GIS map user tools, preventing accidental navigation and zooming (still available in previews and published dashboards).
  • Improved the text in the User Access dialog box for Present.
  • Improved the automatic filter linking popup confirmation message.
  • Updated the layout of descriptive text for the Rules field in the Conditional Formatting dialog box.
  • Improved field alignments and the appearance of the Schedule Manager and Dashboard Manager.
  • Improved the aspect of dashboard names in the dashboard tabs header so they occupy as much space as possible.
  • Improved spacing and layout of the Data Interactions dialog box for linked interactions and for the Signal Cache Settings dialog box.

Image Manager

  • Enhanced the Image Manager to accept uploads of a broad range of image file types, including animated GIFs (learn more).
  • Reimplemented the option to globally replace an image within the Image Manager (learn more).
  • Added the option to move an image between the My Images and Corporate Images repositories (learn more).
  • Streamlined the performance of how images are loaded in the Image Manager.

Signals

  • Resolved an issue where Signals could be filtered by job in Yellowfin version 9, but not in version 8.

...

Expand

Infrastructure

  • Resolved an issue that would cause an error when loading a user avatar that was set through the mobile app.
  • Resolved an issue where the custom Surname attribute would not be applied during the LDAP login process.
  • Resolved an issue where users from nested client org groups could not be contributing members to the parent group.
  • Resolved a memory leak when using paginated tables on a dashboard.
  • Resolved an issue that would cause background threads such as the Task Scheduler to hang.
  • Resolved an issue that would prevent an email server configuration from saving correctly if the encrypted SMTP server password contained special characters.
  • Resolved a potential XSS (cross-site scripting) vulnerability within the Datasource Name field when creating some types of data sources.
  • Resolved a potential XSS vulnerability within the local time code parameter on the Broadcast Management Page.
  • Resolved a security issue with BroadcastAjaxAction.
  • Resolved an issue with some internal AJAX calls that would cause the responses to strip security headers.
  • Resolved an issue that would hide client organization user groups from folder permissions.
  • Resolved an issue that could display the import page to non-admin users.
  • Resolved an issue that would cause pages to stop loading when the CSRF filter was enabled.
  • Resolved event logging issues for the report delete event (it would drop for report delete and all subquery deletes); the dashboard/present copy event (it would drop when the dashboard/presentation was edited); and the import/export present event (it would incorrectly register as a dashboard event).

JS API

  • Resolved an issue where button widgets with certain actions would break when included via the JS API.
  • Resolved an issue with tables embedded via the JS API that would not display pagination controls.
  • Resolved an issue that would prevent canvas reports from functioning correctly within v2 of the JS API.
  • Resolved an issue with report series selection in the JS API which would prevent the use of field names when applying series selection.

REST API

  • Resolved an issue that would cause the REST API to fail if the super user role was enabled.
  • Resolved an issue which would allow inactive users to access Yellowfin via the REST API.
  • Resolved an issue where org configurations could not be changed via the REST API.

Data

  • Resolved an issue that would prevent filters from being added to the dashboard when using particular databases.
  • Resolved an issue that would cause a syntax error when using the != operator with Teradata reports.
  • Resolved a transformation flow issue with the Date Component transformation step would display an error during configuration.

Imports

  • Resolved an issue with imports from Yellowfin 8 or earlier where the time unit selection would not be visible on dashboards.
  • Resolved an issue which has led to improving imports to rely less on names: for source matching, Source UUIDs are now used to match sources prior to matching on Source Name; and when replacing reports during import, custom query filter sources are now matched by UUID or Name, where they were not previously.
  • Resolved an issue where importing reports could cause either duplicate header image storage or a broken header image reference.

Content Export

  • Resolved an issue that would auto-enable the Secure PDF toggle when upgrading from Yellowfin 8.
  • Resolved an issue that would prevent images from being added to report headers and footers in XLSX exports.
  • Resolved an issue with PDF export where only a single record would be displayed when a table header was enabled on a dashboard canvas.
  • Resolved an issue that would prevent a report with a logo in the header from exporting if any rows were excluded in the export.
  • Resolved an issue that would cause PDF exports to fail in environments with proxy settings in the tomcat server.xml file.

Views

  • Resolved an issue in views where renaming an underlying column would not be reflected in views or reports.

Dashboards

  • Resolved an issue where users without public dashboard roles could not view private dashboards.
  • Resolved an issue where user group default dashboards would disappear when the dashboard was edited and published.
  • Resolved an issue that would cause applied filter styles to be lost when editing or copying a dashboard.
  • Resolved an issue that would create a malformed URL for a dashboard landing page when both multi tab was enabled and the request did not include the referer header.
  • Resolved an issue where paged reports would not display correctly on dashboards.
  • Resolved an issue where time series brushing linking would not work in preview mode.
  • Resolved an issue that would prevent certain brushing links from being applied to time series charts with advanced scientific notations.
  • Resolved an issue that would cause problems when code mode content is present while adding widgets to other sub-tabs in dashboards or slides in Present.

Reports

  • Resolved an issue that led to incorrect results for report calculated fields in crosstab reports.
  • Resolved an issue with calculated fields where the required closing bracket could not be added to some formulas.
  • Resolved a client issue where a calculated field would prevent a report from displaying results unless the fields were removed and re-added.
  • Resolved an issue that would prevent the creation of SSRS reports.
  • Resolved an issue that would prevent users from disabling autorun for reports.
  • Resolved an issue that would cause an empty list in the Search Filter Values popup on tabbed reports.

Filters

  • Resolved some issues in preview mode where duplicate content would appear in content containers.
  • Resolved an issue that would cause previously applied filter values to persist on the dashboard even after logging out, overriding any default filter values.
  • Resolved an issue that would prevent dashboards from loading when an incorrect filter ID was provided as part of the dashboard URL parameters.
  • Resolved an issue where filters that shared a dependency with a Custom Query Cached on Demand filter but had a different Value List Setup type would not display filter values.
  • Resolved some issues where Oracle error ORA-01795 would occur when selecting more than 1000 values for a filter or when adding an access filter to a data source with more than 1000 values.
  • Resolved an issue that would prevent a subquery from using the parent query’s parameters as filters in other views.

UI

  • Resolved an issue where the Show Duplicate Records checkbox would not display on the Configure Union Sub Query dialog box.
  • Resolved an issue where filter buttons would still be visible after setting the filter control panel to be hidden.
  • Resolved a dashboard issue where the display chart toggle would appear on reports without charts.
  • Resolved an issue where long column names in the view builder would cause the Edit Table link to be obscured.
  • Resolved an issue where the 'Delete' text would overlap another field in the Discussion Stream Settings window.
  • Resolved an issue with the screenshot tool which would not hide the comments box when capturing reports.
  • Resolved an issue in the Advanced Search dialog box that would cause the scroll bar to overlap the drop-downs.
  • Resolved an issue that would prevent reports from appearing in Favorites on the Browse page.
  • Resolved an issue that would cause the Create New Broadcast popup to be horizontally off-centre.
  • Resolved an issue that would cause the Browse page activity stream to be transparent until an item was selected.
  • Resolved an issue where the cursor would not be visible in metric filter fields.
  • Resolved an issue that would cause text widgets undo/redo functionality to stop being synchronized with the undo/redo buttons in canvas edit mode.
  • Resolved an issue that would prevent the creation of dashboards/presentations from the top toolbar after selecting Create New View.
  • Resolved an issue that, when editing a report and using the Modern SinglePanel left navigation filter, would prevent the pop-up entry-style filter from displaying.
  • Resolved some rendering and alignment issues with locked report headers in resized browser windows.
  • Resolved an issue that would prevent dependent filter values from rendering when displayed as radio buttons.
  • Resolved an issue that would cause dashboards to continually resize when viewed on mobile devices using pinch-to-zoom.

Translations

  • Updated the Dutch translations for 'Friday' and 'Fri' to 'Vrijdag' and 'Vr' respectively.
  • Updated the translation string for the 'Other' label and legend entry on pie charts.
  • Switched incorrect numerics for midnight and noon in Spanish (now ’00’ and ’12’ respectively).
  • Updated the dashboard translation file to include filter group names and filter list names.

...