Page History

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 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.
• 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.
• Aligned the existing SAML Bridge features with the more recent SAML implementation, including SP-initiated SAML workflow. 

JS API

• Added the 'Ask a Question' UI of Guided NLQ as an embeddable object via the JS API.
• 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. 
• 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.
• 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.
• Added the component Guided NLQ to the Licence Management page.
• Improved Code Mode to take full advantage of the JS API.
• Added an Open Report button to reports on published Stories which directs the user to the report's output page.
• 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.