List of changes in version 8.0

Overview

This article provides a list of the issues fixed and new functionality added in Dundas BI.

Version 8.0.1.1001

Fixed issues

TicketDetails
87408 Fixed an issue causing external tables that do not match the specified schema to be included for Amazon Redshift data connectors.

Version 8.0.1.1000

New functionality

TicketDetails
78134 Federated authentication can now be used to log onto Dundas BI when installed on a Linux server.
83380 When exporting to Excel, additional measures added to bullet graph and data bar columns in tables are included when using default settings.
85754 More descriptive error messages are displayed when script in a calculated element transform results in an error.
86471 Dundas BI application and warehouse databases can now be upgraded automatically when starting a Dundas BI Docker image.
86611 Ability to query for the session ID associated with a logon token using .NET, REST, or JS APIs.
86694 Ability to connect to Excel files by URL, in addition to existing Excel Services and UNC path support.
86784 New Custom Colors configuration setting to add to the color dropdowns in the UI and include in exports to Excel. Sample configuration: [ { "name": "CorporateBlue", "value": "#0078D4" } ]
86904 Application logs now include user cancellations of long-running exports when the Log Filter configuration setting is set to Verbose for the Standard Export Provider.
86988 Exporting dates that are invalid in Excel now succeeds with a message in a warnings sheet in the resulting file.
86995 Support for running on Kubernetes on IBM Cloud expanded to Red Hat OpenShift.
87095 The X Virtual Frame Buffer service required for exporting when Dundas BI is installed on Linux is now installed as a prerequisite rather than as an additional step in the wizard.

Fixed issues

TicketDetails
85953 Fixed an issue where a table's total row styling was not applied when exporting to Excel.
86112 Fixed an issue that could cause an error when passing very long parameter values in a URL.
86242 Fixed an error that could occur when displaying custom totals and a collapsed hierarchy along a chart's time axis.
86252 Resolved an issue that could result in an incorrect number of records returned by the Top/Bottom data cube transform.
86336 Fixed an issue where column headers could be temporarily scrolled out of alignment with the rest of the table after expanding a column header value if its text does not fit within the set column width.
86510 Fixed an issue where some menu layers were not updating correctly for different page sizes when using multiple menu layers.
86595 Fixed an issue preventing hierarchy values from being displayed in visualizations such as data labels or gauges when the metric set is transposed.
86667 Addressed intermittent errors that could occur in some cases when Dundas BI is installed on Linux.
86702

Fixed an error that could occur and refer to an 'invalid byte sequence' when importing some shapefiles as map resources.

86738 Addressed custom tokens referenced by a project and exported not being included when importing in some cases, resulting in a displayed warning.
86848 Fixed an issue where an average value was not displayed in some cases when using data cube transforms that are processed in-memory and combining with other data.
86960 Prevented the Dundas BI web service from becoming unavailable with a 503 error message in a case involving filtering date/time data from an in-memory data cube.
86964 Fixed an error that could occur and a case where some values were not filtered out as expected when combining a time dimension hierarchy and attribute with a measure's missing data rules.
87023 Fixed an error displaying incorrectly when opening Data Preview for a data cube transform in some cases.
87026 Fixed an issue that could prevent filtering date/time data from a JDBC data connector by time values.
87070 Fixed an issue causing jobs not to be displayed or an error to occur when navigating to the list of recently failed jobs from the administration home page.
87119 Fixed an issue where data is included by default when exporting to Excel from a table visualization if it was removed from the column headers but set up to be displayed in tooltips instead.
87188 Resolved issues including scheduler service errors that could occur after upgrading an instance to a newer version of Dundas BI if it contained schedules with certain dates.
87227 Fixed an issue causing some data not to be exported to CSV when using dynamic measures or dynamic hierarchies.
87241 Fixed an incorrect time dimension caption displayed in filters when applying a data token.
87248 Fixed issues where dynamic hierarchy values may not be included when exporting to Excel with default settings.
87292 Fixed an issue that could prevent formulas from accessing the data corresponding to a dynamic hierarchy after changing it with a dynamic element filter.
87388 Fixed an error that could occur when connecting to some SQL Server Analysis Services tabular models.

Version 8.0.0.1002

New functionality

TicketDetails
86803 New timing details logged for Excel exporting when Standard Export Providers is set to Verbose in the Log Filter configuration setting.
86865 unixODBC is now included by default in Docker images for easier ODBC driver installation.

Fixed issues

TicketDetails
85832 Fixed an issue where some time dimension hierarchy levels were not exported to Excel with the correct format.
86282 Fixed column headers missing in some cases when exporting data with a dynamic hierarchy to Excel.
86349 Fixed options such as placing totals on the bottom not taking effect in scheduled data exports after editing and saving an existing notification.
86458 Fixed a performance issue when running data cube storage jobs on multi-tenant instances with many tenants and data connector overrides.
86585 Fixed incorrect aligment of missing data cells when exporting tables to Excel.
86660 Fixed an issue that could cause scheduled jobs to stop running and errors to appear in the logs when an account is disabled.
86736 Prevented custom color names defined in JavaScript from producing unreadable text when exporting tables to Excel.
86746 Updated the JRE installed on Dundas BI Docker images to more easily allow for newer JDBC drivers.
86748 Fixed an issue allowing the loading overlay to display when set not to in the call to dundas.export.ExportHelper.exportPPT.
86770 Fixed an issue preventing data cube element captions from being renamed in some cases.
86791 Fixed incorrect resizing of elements when editing dashboards or other views with the zoom level changed from 100%.
86833 Addressed an error that could occur when using the Top/Bottom data cube transform.

Version 8.0.0.1001

This version of Dundas BI was updated to display the new End User License Agreement.

Version 8.0.0.1000

Behavior changes

TicketDetails
83378 The options and parameters for the REST method AddParallelSlicerMeasure and JS method addParallelSlicerMeasure have changed.
84467 Select (All) as the opposite axis member to sort by these total values even when they aren't displayed. Data is also now sorted by another member when a selected opposite axis member is filtered out.
84724 Calls to the REST API need to specify 'application/json' as the content type where an incorrect content type may have been accepted previously. Exceptions that occur are now returned as JSON in cases where they may have previously been XML.
84807 On element statistics for a time hierarchy, the Minimum property has been renamed MinimumDate.
85195 When using federated authentication without deleteOtherSessions specified in the authentication URL query string, the Delete Other Sessions On Log On configuration setting is now used to determine whether sessions preventing logon from succeeding are deleted, which defaults to Delete (true).

New functionality

TicketDetails
22552 New data provider for connecting to Azure Table storage and Azure Cosmos DB.
41447 Ability to display values from data in state indicators in text or tooltips.
48844 New 13 Period calendar available for time dimensions.
54307 New properties for automatically zooming a chart to the end of an axis or into a date range.
63259 Pop-up context menu options added for metric sets, data cubes, and cube perspectives.
69312 Incremental builds are no longer suggested for data cubes without data sources that support parameters as required.
75666 New option to anonymize the values of a hierarchy in a data cube.
76261 Application diagnostics now list duplicated assemblies loaded because of an extension.
76918 The configuration setting for writing application logs to a file is now supported when deployed on Linux.
77161 Support for the throw keyword in DundasScript for exceptions with more descriptive error messages.
77530 Improved support for deploying Dundas BI using Docker containers including images provided on Docker Hub.
78242 New health check detects and suggests when auto-creation of user projects should be disabled.
78798 New attribute token for filtering by user account e-mail address.
79329 Application diagnostics now indicate how much memory allocated to caches is in use.
79334 Month With Extra Week setting added to configure time dimensions using the Reporting (Marketing) calendar.
79366 New states are now named for you automatically based on your conditions if the name is left blank.
79397 Set Allowed IP Addresses on user accounts and groups.
79539 The current project selected on the main menu and on the home screen filter are now kept in sync.
79590 Improved support for DBF files used as a data source allowing for values containing accents.
79667 New health check detects and deletes notification jobs for notifications that have been removed.
79699 The IBM DB2 data provider is now supported when Dundas BI is deployed on Linux.
81050 Ability to format weeks by its week number within each reporting month rather than within the year for time dimensions using the Reporting (Marketing) calendar.
81559 Improved and expanded list of column statistics shown in Data Preview for data cube transforms.
81740 Data cubes generated when auto-joining data from existing data cubes now incorporate the supported aggregators that were selected.
81767 New helper methods for easier exporting of content using JavaScript for dashboards, reports, and other views.
82458 Chromium is no longer installed to support exporting content from views when deploying to Linux.
83191 The Command key on Macs now works when selecting multiple elements on the canvas of a dashboard or other view.
83378 Slicer comparison measures now support filtering multiple slicers at a time.
83554 Multiple item styles at the same item depth now act as a palette when using a menu component.
83592 Updates to the Web localization resource now take effect at the server immediately without recycling the application pool.
83674 The Deployment Wizard on Linux now displays its version number when it runs.
83734 New Cache Lifetime setting available on each data cube.
83917 Support for DBF files as a data source is now available when Dundas BI is deployed on Linux.
84018 Support for JDBC drivers in data connectors is now available when Dundas BI is deployed on Linux.
84020 The Salesforce.com data provider is now supported when Dundas BI is deployed on Linux.
84097 Top & bottom overrides can be re-ordered instead of removing & re-adding them when customizing sorting on hierarchies.
84151 Call resetFireCount in script to reset a timer's fire count to zero.
84209 Exporting a table with hyperlink columns to Excel now includes clickable hyperlinks.
84231 Set up custom sorting on time dimension hierarchies to take effect in filters or by default in metric sets.
84233 Write integer literals in hexadecimal digits using the 0x prefix in DundasScript.
84241 Formula measures can now be selected when adding slicer comparison measures to compare its values against different slicer values.
84425 Application privileges are now categorized by type.
84522 New option when updating the notification content of an existing notification to update the previous parameter values, otherwise the originals are preserved.
84552 New Maximum/Minimum Relative Font Size properties when using the responsive font sizing option on responsive dashboards.
84575 Set the current value using tokens when using a play axis filter and optionally show its token menu.
84581 Usability improvements when selecting tokens from filters set to use the project's default time dimension.
84622 New option Not Equal To available as the operator when adding state conditions for customizing the appearance of certain data.
84669 A sheet containing warnings is now included when exporting to Excel if a limitation applies such as too many rows/columns.
84714 Usability improvements when upgrading Dundas BI and choosing whether to allow the existing license to be updated automatically.
84728 New health check verifies that the application database matches the expected schema.
84742 Ability to access application diagnostics from the federated authentication bridge web application.
84752 New optimizations make every page load faster.
84952 New option in administration to filter jobs by Last Run Result.
85057 Added support for version 8 of Red Hat Enterprise Linux.
85413 New APIs for refreshing information for existing accounts from Active Directory on IAccountService (.NET) and /Account/ (REST).
85636 New licensing option to allow multi-tenant instances according to a maximum number of tenants.
85650 State indicators now display annotations/notes added to its data.
85752 Deploy Dundas BI to Kubernetes with Helm charts.
85913 Ability to specify search path (schema) for Amazon Redshift data connectors.

Fixed issues

TicketDetails
66195 A warning is now displayed when exporting a user project without its account since the account is required when importing.
78237 Fixed an issue where a smaller range of data than expected is displayed by default when importing certain Excel files but other options can be found in the Explore window.
80236 Legends no longer list a chart series with no label when all series values are filtered out.
82536 User accounts are no longer locked out after changing or resetting the password.
82581 Fixed an issue that could cause the Unused Warehouse Tables health check fix to fail and leave unused tables if there was a timeout error.
82940 Fixed a missing notification from the Deployment Application when a restart is required after installing the .NET Framework prerequisite.
83514 Fixed an issue that could prevent a hierarchy from being renamed in a data cube's output elements.
83938 Fixed an issue that could prevent new columns from being discovered added after originally connecting to SharePoint Excel Services.
84148 Fixed an issue with date trimming functions affecting hour and minute levels when connecting to MemSQL.
84167 The Dundas embed library file is now included when deploying on Linux.
84482 The web.config file in the Dundas BI web application now includes a section specifying default maximum request length settings for data connectors for easier configuration.
84547 Fixed an issue that could cause group header text in tables to be shifted upwards and cut off in certain cases.
84559 Fixed an issue that could prevent data from being exported correctly to Excel with styles excluded or to CSV when some data is excluded from data export.
84608 Fixed an issue preventing a ragged hierarchy's values from being sorted correctly when set to show Leaf Members and the top or bottom measure values.
84665 Fixed dynamic hierarchies not listed in the popup suggestions when typing into the formula bar.
84698 Fixed an issue that could prevent a hierarchy from being sorted according to a custom member property in some cases.
84724 Fixed incorrect errors and XML formatting returned in response to requesting content as XML from the REST API.
85139 Fixed an unclear error message displayed when automatically creating accounts without enough floating seats.
85210 Fixed an issue that could prevent some members from being listed in filters from Google Analytics data.
85249 Fixed an issue that could prevent exporting animated content from completing.
85461 Arrows positioned in the middle of curved links on relationship diagrams are now displayed correctly following changes in newer versions of Chrome and Edge browsers.
85578 Fixed an error when selecting the option to back up existing databases when deploying or upgrading an instance using certain editions of Microsoft SQL Server.
85600 Fixed an issue that could cause filters to be incorrectly blank in certain cases when using custom attributes with a security hierarchy.
85655 Fixed an issue that may cause the last logon time not to update for a tenant member account assigned a floating seat.
85656 Addressed an issue where date columns in a flat table were not exported to Excel as sortable dates.
85905 Fixed inconsistent spacing that could be displayed left of column headers compared with the rows in  flat tables in reports, scorecards, and small multiples.
85980 Fixed an issue where not all rows were imported from certain Excel files created outside of Excel.
86023 Prevented an issue affecting extensions that access context.Session resulting in an unexpected error when using federated authentication.
86046 Fixed an issue preventing the creation of shortlinks using the embed library when deployed on Linux.
86122 Fixed an issue preventing errors from being logged when dropping old warehoused data from Dundas BI's warehouse database.
86151 Fixed an issue that could cause data points to be left out of a chart incorrectly when using a dynamic hierarchy with a large number of data points.
86173 Fixed an issue that could result in no data displayed in certain formula visualizations when using the invert option on a filter.
86198 Improved the compatibility of some web fonts specified in Font Family properties when exporting tables to Excel and preserving its styling.
86257 Fixed an issue that could cause headers to be out of alignment and values unexpectedly missing in some cases when exporting to Excel with measures set as hidden when re-visualizing.

See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri