List of changes in version 10.0
Overview
This article provides a list of the issues fixed and new functionality added in Dundas BI.
Version 10.0.0.1009
Behavior changes
| Ticket | Details |
|---|---|
| 93290 | For custom time provider extensions, the TimeDimensionProvider abstract class now has a new AddInterval abstract method signature to implement: public abstract DateTime AddInterval(ITimeHierarchyMember timeHierarchyMember, int intervalId, int offset); |
New functionality
| Ticket | Details |
|---|---|
| 93008 | SSL client certificates can now be set up separately in each PostgreSQL data connector. |
Fixed issues
| Ticket | Details |
|---|---|
| 89541 | Fixed an issue that could prevent data from showing correctly from an Excel file containing multiple columns with the same name. |
| 92898 | Fixed an issue that could cause publishing to unexpectedly take a long time and possibly result in errors in certain cases. |
| 92917 | Fixed an issue that would result in an error in certain cases involving filtering user-defined hierarchies placed on Slicers. |
| 92946 | Fixed an issue when using in-memory data cube storage that could result in dependent filters not displaying values correctly. |
| 93045 | Fixed an error reporting files not checked out to the caller that were displayed incorrectly and prevented publishing in some cases. |
| 93125 | The performance of the health check DBI0225 for tenant user projects has been improved for some cases. |
| 93167 | Fixed an issue that could prevent Custom Text set on a column in a table visualization from being exported correctly to Excel. |
| 93168 | Fixed an issue that could cause null values to be overwritten by another column's values when a chart is exported to Excel with the option to preserve its styling. |
| 93230 | Addressed cases where filtering by one formula measure could be applied before another formula measure's values were calculated. |
| 93258 | Fixed an issue where upgrading a Dundas BI instance may not complete in some cases where the Signing Certificate configuration setting has been set. |
| 93278 | Fixed an issue that could cause styling in Excel exports not to match the table visualization with certain combinations of state styles and alternating row styles. |
| 93281 | Fixed an issue that could cause data to unexpectedly be filtered by a relative time token differently for tenant users affected by time dimension overrides. |
| 93283 | Performance has been improved for operations involving ragged hierarchies. |
| 93290 | Fixed an issue that could cause data for the wrong month to be displayed for a period over period comparison measure for time dimensions set to use certain reporting calendar configurations. |
| 93295 | Addressed an issue that could cause slicer comparison measures to display data unfiltered by the custom attribute for a security hierarchy. |
Version 10.0.0.1006
Fixed issues
| Ticket | Details |
|---|---|
| 92472 | Fixed an unexpected 'unable to cast object' error when working with some data types from MySQL. |
| 92502 | Fixed an unexpected error occurring when setting up additional hierarchy links in certain cases after using the Unpivot and Calculated Element transforms. |
| 92671 | Improved query generation and performance for certain cases when accessing data from Google BigQuery. |
| 92731 | Fixed an error that could occur when exporting data to Excel in some cases when using a dynamic element filter to switch between hierarchies with different numbers of levels. |
| 92737 | Fixed an error incorrectly preventing a measure from being dragged onto an existing formula metric set that refers to multiple other metric sets after adding the measure to the original depending on the order in which the metric sets are referenced. |
| 92751 | Fixed hierarchy value filters incorrectly displaying as empty when connected to a parameter from a view contained within a repeating view such as a scorecard contained within another view. |
| 92782 | Addressed connectivity issues that could occur in certain cases when using JDBC drivers and result in errors. |
| 92924 | Fixed issues with accessing Dundas BI using Internet Explorer 11. Please note the expected limitations and anticipated future ending of support in the upgrade notes. |
Version 10.0.0.1004
Fixed issues
| Ticket | Details |
|---|---|
| 92096 | Fixed filtering unexpectedly being applied before ranking when using the RANK function in a data cube's Calculated Element transform. |
| 92118 | Column header text set to a space/whitespace is now preserved when exporting a table visualization to Excel. |
| 92146 | Fixed an issue preventing certain PostgreSQL database functions from being called correctly depending on the parameter values. |
| 92198 | Fixed an error that could occur in some cases when using a time dimension with a Fiscal calendar and a start hour other than midnight. |
| 92209 | Fixed an error that could occur when exporting a table visualization to Excel when the metric set is transposed and a cell has custom text set when the value is null. |
| 92276 | Fixed unexpected ranks assigned to measure values that are null/missing by the RANK function in a formula. |
| 92310 | Fixed Microsoft SQL Server aliases no longer working when Dundas BI is installed on Windows. |
| 92317 | Addressed an issue preventing dynamic hierarchies from being used as an alignment hierarchy argument in a formula. |
| 92323 | Fixed an issue with SharePoint apps added to SharePoint 365 resulting in a 404 error. |
| 92344 | Fixed formatting issues when copying and pasting data from a table visualization exported to Excel. |
| 92374 | Fixed the hierarchy levels list disappearing from the bridge parameters dialog in some cases. |
| 92568 | Fixed the Filter transform's Contains Any option to support string type data. |
| 92592 | Fixed an error preventing the filtering of hierarchy attributes in some cases. |
| 92633 | Addressed an issue where errors could prevent the use of certain JDBC drivers. |
| 92639 | Fixed issues such as 400 (bad request) errors when a large amount of claims data is provided by the identity provider when using federated authentication. |
| 92645 | Fixed an issue causing the alternating row style to be excluded in cells affected by states in table visualizations exported to Excel. |
| 92667 | Fixed an error that could prevent connecting to Azure Synapse using the Microsoft SQL Server data provider. |
Version 10.0.0.1002
New functionality
| Ticket | Details |
|---|---|
| 74255 | Responses over HTTPS emit SameSite=Lax when the Allowed Embedding Origins configuration setting is set to self to disallow cross-site embedding as a measure against CSRF attacks. |
Fixed issues
| Ticket | Details |
|---|---|
| 90327 | Data is no longer requested for repeating views such as reports and scorecards for template cells that are hidden and collapsed. |
| 91970 | Fixed an issue that could result in incorrect distinct count values from a data cube using other data cubes as input. |
| 92030 | Fixed an issue when deploying Dundas BI 10 to a virtual directory that could break links such as those used in navigation interactions by omitting the directory. |
| 92048 | Fixed a version parsing error that could prevent connecting to some versions of PostgreSQL in Dundas BI 10. |
| 92061 | Fixed incorrect behavior when re-running a data cube storage job that has not yet finished for a tenant with data connector overrides for its data source. |
| 92063 | Fixed an issue that could cause values to be read incorrectly from a PostgreSQL database if they do not fit within the range or precision of the .NET decimal type. For this change to take effect, right-click the data connector and choose Re-Discover, then the data cube SQL Select transform and choose Refresh. |
| 92072 | A new advanced configuration setting Database Bulk Copy Timeout can be customized if data cube storage jobs are taking an unexpected amount of time in order to stop them sooner. |
| 92112 | Fixed an issue where the grand total value could change incorrectly after expanding both row and column values while sorting by measure values. |
Version 10.0.0.1000
Behavior changes
| Ticket | Details |
|---|---|
| 76876 | Font properties set on filters/parameter controls or drop down list components now apply to the drop-downs/popups they display by default where in some cases they did not before. The Drop Down Style properties can be used to customize their styling to be different. |
| 84019 | The Microsoft Dynamics CRM data provider from previous versions is not available in version 10, but you can edit or create data connectors to use the new Microsoft Dataverse data provider to connect to Dynamics 365 online/in the cloud. Please see the upgrade notes for more information. |
| 87205 | Federated authentication using the OpenID Connect protocol requires configuration changes when using Azure Active Directory or when installing on Windows with a redirect/reply URI set up. With Dundas BI installed on Windows, if your identity provider required a redirect/reply URI, this was previously {Dundas BI Base URL}/AuthBridge/ and now must be changed to {Dundas BI Base URL}/AuthBridge/signin-oidc/{providerId} (e.g., https://dundas.example.com/AuthBridge/signin-oidc/MyProvider with Id set to MyProvider in your Federation Manifest). For Azure Active Directory, the Federation Manifest should be updated to change the ProtocolId from OpenIdConnect to MicrosoftIdentity, and the Properties section now requires only tenantId, clientId, and clientSecret - this is needed for receiving group names during authentication and to prevent warnings in Dundas BI logs. |
| 89191 | The MySQL and MemSQL data providers use a different driver that is now included with Dundas BI and doesn't need to be installed. Some available settings in data connectors using these providers have changed. |
|
79419 |
Dundas BI now runs on .NET 6 everywhere. When installed on Windows, some formatting of numbers and dates/times may have changed because .NET now uses the same ICU formatting as on Linux by default, and standard number formatting rounds midpoint values to the nearest even number. You can use custom numeric formats such as 0,0.0 to round away from zero instead, or you can call Math.Round in a formula or calculated element, for example: Math.Round($Measure$, 1, MidpointRounding.AwayFromZero) Custom extensions now need to target .NET Core or .NET 5+ as described in more detail in the upgrade notes. |
| 91090 | If you are using Npgsql directly from your own .NET code before starting the Dundas BI engine when using a PostgreSQL application database, you will currently need to set the Npgsql.EnableLegacyTimestampBehavior switch first. |
| 91102 | Calls to these REST API methods will need to be updated: GET /Export/Queued/ replaced by POST /Export/Queued/, POST /Session/CustomAttributes/{id}/ replaced by POST /Session/CustomAttributes/. The following methods will continue to work but are deprecated: DELETE /Session/{id}/ in favor of POST /Session/Delete/, GET /Session/{id}/ in favor of POST /Session/GetSession/, POST /Session/IPAddress/{id}/ in favor of PUT /Session/IPAddress/, GET /Session/IsValid/ in favor of POST /Session/IsValid/, PUT /Session/KeepAlive/{id}/ in favor of POST /Session/KeepAlive/. |
| 91252 | Docker containers now follow your restart policy, for example from your docker run command or Compose file. You should set a restart policy when in production if the services should restart automatically in case of a failure or expected events such as loading extensions. |
| 91549 | Sorting of ragged hierarchy members may have changed in certain cases as a result of fixes to base sorting on the highest requested level. |
| 91763 | If any custom files have been placed in the BIWebsite folder but outside of the wwwroot subfolder for an installation on Windows, after upgrading to version 10 these files will not be accessible from web browsers until moved within the wwwroot folder or its subfolders. It is also recommended to use App Styling or Static Resources options for custom files instead - for details, see White labeling the application. |
New functionality
| Ticket | Details |
|---|---|
| 53743 | Right-click/long-tap referenced files directly from the References dialog to open them or access other options. |
| 57373 | Access References from the toolbar/context menu in administration for custom attributes and tokens to find files that reference them or accounts & groups with values assigned. |
| 68711 | Monthly schedules for notifications and data cubes can be set up for multiple days of each month by day of the month or by first/last number of days. |
| 70146 91368 |
New Generic Web data provider can connect to various online data sources including web applications offering REST API services. |
| 73128 | A new option when sorting by a measure allows you to ignore hierarchy groupings and sort all rows independently without requiring a hierarchy containing unique values. |
| 74114 | The Quick Access Properties popup includes new options for changing horizontal text alignment and vertical alignment after clicking on an element containing text. |
| 74253 | Prevent browsers from embedding your Dundas BI instance on unwanted sites using the new Allowed Embedding Origins configuration setting. |
| 74859 | Right-click the Views or Programmatic Structures subfolders under a data connector to re-discover those structures in less time than for the entire data connector. |
| 75926 | Change the data provider used by an existing data connector when you need to switch to another type of driver or data source for accessing the same data structures. |
| 76876 | New options for customizing the appearance of drop downs & popups in filters and components. |
| 79404 | Administrators can click to download the logon history as a CSV file. |
| 79419 90591 |
Dundas BI now runs on .NET 6 on all platforms, providing performance improvements and enabling new functionality. |
| 79999 | New health check DBI0225 finds user projects and files with a tenant ID that doesn't match the account's tenant. |
| 80776 | When exporting to Excel and including parameter values, parameters set to a time-based token are resolved to the actual dates in effect at the time of export. |
| 82533 | New Border and Background properties for Drop Down List components similar to existing properties for filters. |
| 83248 | New API methods /DataCube/ClearDataResultCache/{id}/ (REST) and clearDataResultCache (JS) to programmatically clear all cached data results for the specified data cube. |
| 84019 | The new Microsoft Dataverse data provider connects to cloud versions of Microsoft Dynamics 365 using a new authentication method. |
| 84291 | Support added for installing Dundas BI directly to Debian 11. |
| 85374 | Support added for installing Dundas BI directly to Ubuntu 20.04 LTS. |
| 85675 | When publishing through the API, the PublishItemResult class now directly contains properties TargetItemId and TargetItemName. |
| 86035 | New tenant setting External Application URI Override allows for different URLs to be used for tenants' users in emails, shared links, and federated authentication. |
| 86974 | Ability to configure Dundas BI to be accessed as a path under a site rather than the root on Linux and Docker deployments. |
| 87205 | Federated authentication when Dundas BI runs on Linux now supports group names as claim values from Azure Active Directory using the new MicrosoftIdentity protocol. |
| 87746 | Exporting to Excel now excludes columns that were hidden in a table visualization (this is separate from the Exclude From Data Export setting in the Data Analysis Panel). |
| 88153 | When using the REST API, the session ID can now be specified using an Authorization request header with the Bearer authentication scheme (e.g., Authorization: Bearer <session ID>) and this is recommended rather than using a URI parameter. |
| 88213 | When configuring an MDX Select in a data cube, use double-click as a shortcut when selecting measures and dimensions to add to the right. |
| 88379 | Emails notifying of a license limit being exceeded include a link to the seat usage page of the affected instance especially in case there are multiple Dundas BI instances. |
| 89257 | Existing tenant data connector overrides are now only overwritten when the Data Connector Settings advanced option is selected when importing a data connector. |
| 89440 | The location of installation log files is now indicated directly by the Deployment Wizard when deploying on Linux. |
| 89520 | Elements on dashboards and other views that contain input controls can be assigned a Tab Index in the Properties window to disable or customize tab order when necessary. |
| 89593 | You can now customize the level caption for time dimension hierarchies in the Formatting section. |
| 89713 | Scheduled notification job run details now display separate events for each delivery recipient to let you know its progress in case it's prevented from completing. |
| 89868 | New Helm chart property dundas.bi.virtualDirectoryPath allows for accessing Dundas BI at a path under a site when deploying on Kubernetes. |
| 89953 | Distinct colors are populated by default when adding new discrete color rules for hierarchy values manually similar to those created automatically. |
| 90050 | New recommended option in the Re-Visualize menu to find and format potential outliers in charts using the OUTTAU formula. |
| 90055 | The new IHttpClientService can be accessed and used to obtain HttpClient instances in .NET 6+. |
| 90086 | The Azure Table / Azure Cosmos DB data provider has been updated to use the new Azure.Data.Tables library for up-to-date support. |
| 90107 | The [Level] keyword can now be used in text properties in sunburst and chord diagram visualizations similar to others. |
| 90115 | New Flatten JSON and Flatten XML transforms can be used in data cubes to turn JSON or XML text such as responses from web services into columns to analyze and visualize. |
| 90136 | The watermark shown for evaluation licenses now indicates the number of days remaining. |
| 90187 | A script editor interface is now provided when editing JavaScript resources in the App Styling administration page. |
| 90192 | A new extension manifest setting can specify assemblies that should be exempt from logging the message Error enumerating types from assembly... when they cannot be loaded. |
| 90225 | A new view ready jQuery event is raised on the SubCanvasViewContainer used to embed another view when the embedded view's ready event occurs. |
| 90246 | The Text Transform property is now available in the Properties window for the Menu component's items and item styles. |
| 90255 | Errors found in a localization are displayed to the user immediately when being added rather than only in the application logs. |
| 90336 | Dundas BI version numbers are displayed with different suffixes to distinguish them between the platforms on which they are installed (e.g., -w for Windows, -u for Linux). |
| 90387 | Use the new dt licenseActivation activate command with the dt command line tool to force a license refresh in case a new license is available in addition to initial license activation. |
| 90388 | A new Renew Activation toolbar option is available on the Licenses page when applicable to force a license refresh in case a new license is available. |
| 90394 | Logs now include query duration time for OLAP database sources when Query Audit is set to the Information level or higher in the Log Filter configuration setting. |
| 90425 | The Deployment Application and Deployment Console are now located in separate subfolders on Windows for compatibility with .NET 6. |
| 90451 | You can now drag a hierarchy to Measures multiple times to create multiple hierarchy count measures with different aggregators. |
| 90540 | Scrolling a table or chart now loads data from the cache in more cases than before if data caching has been bypassed or is outdated, until the next time the visualization is refreshed. |
| 90649 | New advanced settings added to JDBC data connectors to set a customized fetch size, for example to prevent all records from being loaded into memory at once for certain drivers. |
| 90707 | Ubuntu 20 is now used in Dundas Docker images. |
| 90714 | The performance of queries for distinct count over many records has been optimized against a single data provider when no totals are requested with no range member filtering set and with any member filtering below the provider-supported maximum number. |
| 90762 | The Tenants page has been updated for better use of space and to omit unneeded text. |
| 90786 91373 |
Keep Alive options have been added to the Oracle and PostgreSQL data providers. This can help when troubleshooting issues involving errors caused by connections terminated by firewalls, for example. |
| 91149 91595 |
A Single Schema option has been added to the PostgreSQL and MySQL data providers to avoid prepending the initially discovered schema name into queries and allow tenant data connector overrides to access different databases for each tenant with the same data structures. |
| 91697 | Measure values calculated for a Missing Data Output Rule set to Average against date/time data will result in a straight line drawn between non-missing data on line charts even with irregular intervals between the dates. |
Fixed issues
| Ticket | Details |
|---|---|
| 56806 | Symbol color rules that were previously applied in certain cases are no longer applied for map symbols created using Symbol Size data assigned to shapes. |
| 58571 | Charts with hundreds or more values plotted along a categorical axis and zoomed in to view a subset no longer skip labels in cases where they may have before. |
| 87294 | Fixed the Grand Total Column Style not being applied to the rest of grand total columns when data is un-assigned from Column Header in the Data Analysis Panel. |
| 89682 | The main partitioned table is now discovered from PostgreSQL databases rather than separate partitions. |
| 89721 | Localizing the name of a built-in parameter token now takes effect also for parameters that were previously set. |
| 89803 | Fixed state styles not consistently taking precedence over total styles in table visualizations as expected when applying to the entire row or to row headers. |
| 89950 | Fixed a vertical scrollbar missing from table visualizations when up to half of the last row is cut off by a horizontal scrollbar. |
| 89974 | Avoided a potential but unconfirmed issue where an App Styling resource may not load correctly in certain cases. |
| 90058 | Queries from a Manual Select are now included in the application logs when the Log Filter's Query Audit is set to Information or higher. |
| 90106 | In report labels displaying view parameter values, spaces are now included between multiple values and the localizable text Excluding precedes them when using inverted selection. |
| 90168 | State styles in table visualization columns can now be reordered because in a table visualization this determines which takes precedence when two or more set the same property when representing different state groups. |
| 90172 | Labels displaying the [TotalPages] value in reports viewed within the browser now append + when the final number of pages is not yet known. |
| 90198 | Fixed extra data point labels appearing in some cases for Line- or Area-based chart types when a marker is displayed because there is no neighboring data point. |
| 90324 | Fixed a vertical scrollbar that may be missing for a report viewed within a container component on another view after refreshing or updating its parameters. |
| 90447 | Fixed an unexpected error when accessing data from a table that uses the PostGIS extension for PostgreSQL. |
| 90519 | Fixed filter selections not being maintained when using the search box if the property option is selected to set the value immediately on change. |
| 90538 | Fixed cases where unexpected digits appear in chart or gauge axis/scale labels displaying values at certain fractional intervals. |
| 90626 | Fixed an issue where some visualizations may not have updated after changing a filter not connected to any repeated groups and then scrolling back up in a report, scorecard, or small multiple viewed directly from the browser. |
| 90730 | Fixed property settings on a chart axis' Rows no longer taking effect in view mode after no data or an error is returned. |
| 90873 | The selected measure is now still displayed as a dynamic measure's caption when no data is returned, applicable for example in a table visualization's column header. |
| 91042 | Fixed an error that could occur when displaying Boolean values from AWS Athena. |
| 91043 | Fixed an issue where basic measure filtering was not being applied before performing certain computations. |
| 91084 | Fixed issues where the chosen aggregator was not applied as expected when combining Week 53 of one year and Week 1 of the following into a single data point for plotting along a chart time axis. |
| 91116 | Support is now added for Pardot API v4. Use the advanced API Version setting in Pardot data connectors to choose. |
| 91131 | For current versions of Safari when viewing Dundas BI embedded on a page from a different domain, users can now click to enable Dundas BI and allow access to its own cookies for logon purposes without needing to disable cross-site tracking prevention. |
| 91140 | Custom hierarchy sorting settings now take effect for ragged hierarchy members with no children where they may not have before. |
| 91202 | Fixed measure captions to display according to the metric set settings rather than the data cube when transposed and no data is returned. |
| 91233 | Fixed an error that could prevent exporting to Excel for a view with a parameter linked to an adapter with no set parameter ID. |
| 91268 | Issues when using MySQL or MemSQL data and selecting Arabic values in filters have been resolved with new drivers used in this version. |
| 91284 | Fixed an error preventing replying to notes inside of a pop-up when the Use Accelerated Rendering advanced option is unchecked. |
| 91307 | Fixed an issue that could allow filters to unexpectedly list dates and times beyond the time dimension's set date range. |
| 91315 | Fixed unexpected errors appearing when clicking to reload extensions when Dundas BI runs on Linux. |
| 91322 | Fixed an error that could occur when trying to publish a file containing inactive subentry files such as metric sets that conflict with the target file. |
| 91325 | Fixed an issue where the delete button may not be visible for top/bottom overrides following long text in the custom hierarchy sorting dialog. |
| 91380 | Fixed incorrect aggregated values displayed for certain cases when using a Pivot transform. |
| 91384 | Addressed values not listed in filters according to users' custom attributes due to hierarchy caching when not using a security hierarchy in some cases where they were previously (a security hierarchy is recommended). |
| 91404 | ExportHelper JavaScript methods have been updated to fix an incorrect view being identified when passing a view in the options argument. |
| 91434 | Fixed an error that could occur when retrieving data in certain cases involving a left or right join and a parameter added to an upstream element. |
| 91632 | Fixed incorrect behavior and a JavaScript error occurring when editing a notification for a report, scorecard, or small multiple from a different page and editing its recipient parameter overrides. |
| 91641 | API calls to get hierarchy members now work as in some previous versions when passing a hierarchy file ID rather than a data cube ID with a member unique name obtained from a metric set where the hierarchy is in use. |
| 91737 | Fixed an issue preventing exporting a view's data to Excel that a user can access when a portion of it is from a container component for another view for which the user does not have read permission. |
| 91832 | Fixed incorrect distinct count values calculated for slicer comparison measures. |
| 91838 | Added missing guidance for redefining Join transform keys when necessary after an element is removed upstream. |
| 91873 | Fixed text from a table column state style not exporting to Excel when not set using keywords. |