List of changes in version 6.0

Overview

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

Version 6.0.0.1003

Fixed issues

TicketDetails
76923 Fix for a scenario where scheduled notification parameters are not being passed.
76975 Fix for a scenario where importing a DBIE file is taking too long.
76987 Fix for an issue where missing data rule "average" options do not work as intended.

Version 6.0.0.1002

Fixed issues

TicketDetails
76817 Fix for issue specific to certain Essbase cubes.
76923 Fix for an issue where scheduled notification parameters were not being used.

Version 6.0.0.1001

Fixed issues

TicketDetails
76245 Performance improvement when using TOP or BOTTOM with OLAP data and with a slicer present.
76284 Fixed an error that could occur when using a ragged hierarchy as a security hierarchy.
76529 Prevented the loading overlay from sometimes showing when loading maps with the Disable Loading Overlay property checked.

Version 6.0.0.1000

Behavior changes

TicketDetails
58585 The Google Analytics data provider from previous versions of Dundas BI is now deprecated and a new Google Analytics provider is available. The old provider will continue to work where used.
66479 Columns can only be customized in a data connector's Define Data Structure dialog, and not added, removed, or renamed. If needed, these are options in data cubes.
67321 The short link service now supports creating a single categorized short link for the specified category-account-file system entry combination. Existing short links with the same combination will be updated instead of creating a new one.
69640 When a chart has a series that is hidden, exporting to Excel will not contain the data unless the Export Tables Without Styles option is selected.
72061 Developers who have implemented a custom accounts provider will need to update their code as follows for the PasswordPolicyMaxAgeDays setting to work properly: handle the new LocalUserAccountData.PasswordNeverExpires and LocalUserAccountData.PasswordLastSetDate properties, and extend the UpdateDynamicAccountProperties() implementation to take the new DynamicAccountProperties.PasswordLastSetDate property into account when getting and/or saving an account.
72735 The slider's Slide actions (Changing event) now consistently occur before the Changed actions.
72773 You will now receive an error message if a data cube warehouse was never built after the last check-in rather than receive data directly from the source.
72859 Calls to get export files now use the REST API. The old method of getting an export file was removed. For more details, see Create an export and download a file.
73366 The TRENDFORE function in formulas can now extrapolate ('forecast') when the first argument is a measure, for example in a scatter plot. The forecast period can be set to zero if unwanted.
57870
/74406
When hierarchies are collapsed using Collapse All, they are now expanded one-at-a-time when expanding members.
74594 Expanding and collapsing the following hierarchy is now available on the last level of a multi-level hierarchy in a table, unless the Allow Collapsing Separate Hierarchies property is unchecked.
74991 Column headers in tables will appear if the Show Column Headers property was never unchecked in a case where they previously did not: when displaying only measures with the metric set transposed.
75173 Tenant accounts cannot become system administrators.
75263 Custom functions from Dundas BI extensions will need to be updated and recompiled to change FunctionInputFormat  to FunctionInputType, and FunctionResultFormat  to FunctionResultType.
75580 The REST call to POST /Group/AddMembers/{id}/ has changed to use accountIds instead of accounts, and groupIds instead of groups.
75741 The method for retrieving information about a an uploaded DBIE file has changed in the REST API from POST /Transfer/FileInfo/{id}/ to POST /Transfer/FileInfo/, and in the JavaScript API from GetTransferFileInfoById to GetTransferFileInfo(transferFile, includeAllDetails).
76409 The following formula functions will now calculate based on the entire set of rows unless a hierarchy is included as an argument: FIRST, LAST, CMLTOTAL, PERCENTTOTAL, PERCENTRANK, NORMALDIST, CORRELATION.

New functionality

TicketDetails
39809 A new small multiples view that repeats visualizations horizontally, vertically or both.
40983 Ragged hierarchies, which have the ability to suppress categories across a level in a hierarchy.
41482 Extra headers are auto-detected and left out from Excel, and additional ranges listed under Programmatic Structures.
41656 Database queries optimized when using the same hierarchy multiple times in a data cube/metric set.
42532 Expand small table visualizations to fit their rows in reports, scorecards, and small multiples.
44280 Layers window enhanced for easier renaming, locking & unlocking, highlighting elements or groups, moving to another layer.
45448 Styles can now be saved and applied to filter controls.
45930 New Recycle Bin in each user's Profile to recover deleted entities.
46323 New Merge transform to combine two columns that may include nulls into one.
47082 A warning is displayed before retrieving an unexpectedly large amount of data.
47960 Preview colors when choosing from the auto-complete popup in the Properties window.
49585 Customize many more aspects of filter control appearance in the Properties window.
51298 Health check to ensure warehouse tables exist for data cubes stored in the warehouse.
52379 Performance is improved when using a user hierarchy with data from a stored procedure.
52438 Added radar (spider) charts PointLine, and Area, with Radar Stacked Area and Radar Range available in series properties.
52631 Attributes can be added to hierarchies for selecting additional data that applies to each hierarchy member.
54189 Ability to use warehouse or in-memory data cube storage on a per-tenant basis when data connector overrides are used.
54893 New advanced editor available for adding formatting to email notification text.
55121 Added Include User Projects to advanced options when importing and exporting users.
56692 The original view options are restored when entering and exiting full screen.
57088 Creating a recursive/self-referencing/parent-child hierarchy is now possible by creating a Ragged hierarchy.
58166 The scheduler service can now be added to an existing Dundas BI instance already deployed.
58353 Option to keep the storage type of the data cube when publishing it from another project.
58585 New and improved Google Analytics provider available for data connectors.
58588 The Pivot transform can now pivot non-numeric values into separate columns.
58977 Ability to see the default values of inherited parameters on a metric set.
59284 Sticky (frozen) option to header templates in scorecards and reports.
61745 Added a Pardot data provider for data connectors.
61964 More query options available as parameters in data cubes when using an OData connector.
62463 Tenant administrators can create custom attributes for their users.
62482 The data cube storage selection is maintained when duplicating a project.
63664 New options on measure placeholders in formulas to refer to previous/next rows or columns, or change aggregators.
64572 Added the ability to choose specific files within a project to publish at once.
64762 Select transform settings are maintained when 're-wiring' by dropping a different data source on it.
64913 Added a dbi.config setting for changing the path used for saving temporary application data.
65052 Use Active Directory Password or Active Directory Integrated authentication with SQL Server Azure.
65132 Claims from federated authentication responses can be mapped to custom attributes to refer to.
65263 Added an API for creating custom delivery providers.
65531 Ability to log on as another user using an administrator account with the API.
65777 Ability to use managed service accounts in the Dundas BI deployment application.
66015 Colors and symbol locations update with animated transitions in Map and Diagram visualizations.
66187 Ability to query for available files for another user using the API.
66287 New property to hide a repeater group from a report.
66305 Quick Access Properties popup for customizing fonts and appearance, available to all user types.
66404 Sticky (frozen) property added to headers in responsive dashboards.
66577 Improved usability for formatting measures in metric sets and data cubes.
67125 Layers window indicates which element is selected.
67500 Use the Shared folder under Time Dimensions and Dashboards to access files from the global project.
67510 Rename option now listed next to each script action in the Properties window.
67589 The size of Dundas.BI.Deployment.dll is much smaller.
67616 New option <Add All Elements> when clicking to add elements in the Data Analysis Panel.
67709 Ability to select a time dimension and its attributes multiple times in a metric set.
68150 New DISTANCE function for formulas to calculate aerial distances.
68210 Ability to make a cell group that spans the entire row a header in responsive dashboards.
68365 Administration home page displays a message when an update is available for Dundas BI.
68698 Ability to connect to view parameters defined in the dashboard template currently applied.
68831 Ability to set up multiple scheduler services for high availability of scheduled cube storage, notifications, etc.
68949 Security hierarchies identified with a lock icon in the Explore window.
69475 Grand total column style added to table visualizations.
69534 Custom total formulas can now refer to total values without calling any functions (e.g., for the overall distinct count).
69640 Exporting to Excel excludes chart series that are hidden by default.
69673 Ability to define a custom date and time format with optional time zone for the export file name.
69852 State groups created without associating a measure are applied to table state styles when exporting to Excel.
70101 Dundas BI licenses may now auto-update themselves if available.
70180 Option for Auto Color/Size Rules to apply based on the entire range of values in reports, scorecards, and small multiples.
70191 New health check to clean up tenant overrides created for files that were deleted.
70374 Added the ability to clear personalization for multiple users using the API.
70594 The Dundas BI Deployment application can update itself when a new version is available.
70853 Improved scrolling experience and performance in tables and charts.
71023 Improved performance with OLAP data when sorting by member caption and using top/bottom measure filtering.
71084 New API method to retrieve job run events for multiple jobs.
71124 Added state styles for links in the relationship and tree diagrams.
71144 New health check to detect circular references between entities.
71156 Property added for hiding unknown members in a tree diagram.
71230 New file system service API method to get the checked-out references for multiple files.
71509 Refreshing a transform does not require the user to dismiss the resulting dialog.
71510 Added an API method to allow custom sorting on drop down values for a dynamic filter.
71656 Apply the default value to existing rows when adding a new column to a data input table.
71940 Property to prevent data labels from expanding to fit text in reports, scorecards, and small multiples.
72061 Ability to set password expiry days for a user.
72067 The current active project is now listed in the tooltip for Projects in the main menu.
72156 Added a native data connector to Snowflake.
72166 Delete multiple rows from data input tables at once on touch devices by first tapping to select them.
72229 Filter drop down pickers close automatically when scrolling.
72497 A search bar is now available in the Admin's Projects page.
72670 The dashboard template currently in use is now listed in the Properties window when the dashboard is selected.
72741 Ability to auto-create accounts when using federated authentication with an associated tenant by mapping it from claims.
72772 Improved error messages when an error occurs in the data connector or provider while retrieving data.
72859 Added a method to get export results through the REST API.
72908 Added the ability for users without the interactive logon privilege to be used when deploying.
72909 Ability to use keywords when setting state style text properties in table visualizations.
72920 Initial parameter mappings are created automatically when setting them up for navigation and popup interactions.
73199 Calendar and Calendar Range filters list the selected value when opened after re-opening the view.
73318 Ability to drop a file from the desktop onto a new hierarchy.
73344 More options when filtering to keep only/exclude selected data with multiple hierarchies.
73355 Option to create an account as API-only, which will not consume a license.
73557 Improved cross-origin resource sharing (CORS) behavior when embedding Dundas BI.
73868 Ability to hide measures when viewing a metric set using view overrides in JavaScript.
74053 Data retrieval is optimized when possible with hierarchies collapsed to avoid retrieving data for children.
74151 Added API method to query for the number of notifications.
74327 New API method for getting parameter tokens.
74652 New API methods for clearing selected data in table visualizations.
74850 You can now set thousands/millions/billions/trillions formats in each range override when formatting measures.
75007 New configuration setting SMTP Client Timeout.
75176 Option to Freeze The Header Rows when exporting to Excel.
75303 Added Processing Location setting to Google BigQuery data connectors.
76162 Ability to create custom application configuration settings that accept multiple lines of text.
76389 Ability for administrators to create notifications on behalf of another user with the API.

Fixed issues

TicketDetails
42846 Fixed an issue where clearing a property for a table column that displays visualizations does not take effect until data reloads.
63011 Fixed an issue where changing filters before the report finishes loading may not take effect.
68020 Opening popups with the In a browser pop-up setting should now work on every hover over.
70117 Addressed scenarios where selected hierarchy filter values may not be reflected in the database query.
71253 Fixed CYStart and CYEnd to work when formatting the Quarter level in fiscal time dimensions.
71474 Fixed an issue where some errors that prevented a project from being imported were not displayed correctly.
71767 Prevented an error from occurring when using the embed library and passing messages not formatted as JSON.
72512 Fixed renaming calculated elements not immediately taking effect in the data cube result.
72582 Prevented clicking a table's expander button from also triggering interactions.
72657 A hierarchy can now be dropped directly onto Measures in an empty metric set.
72746 Fixed an issue preventing the selected dimensions from displaying correctly in an MDX select transform with long dimension names.
72913 Fixed an issue where data stays brushed after letting go of a chart data point on touch devices.
73027 Fixed an issue where an aggregate transform may stop working after inserting another transform before it.
73034 Fixed the pinch-to-zoom gesture to work with responsive dashboards.
73105 Fixed an issue where the table may not load data when scrolling using JavaScript.
73114 Fixed errors that could occur when using the Python transform.
73145 Fixed syntax errors displayed when using script in a formula with certain spacing.
73211 Fixed saving and applying styles to work with hover over and selected font color properties of data labels.
73434 Fixed an issue where the Collapse All function may not work with formula measures present in the metric set.
73435 Fixed a problem with persisting data stored in a structure's Tag property when implementing a custom data provider.
73481 Fixed an issue where selecting every item in a filter may not work correctly if the All item is hidden.
73500 Removed derived measures from the list of elements when replacing the source cube for a metric set, which must be mapped automatically.
73641 Fixed an error preventing data retrieval when a very large number of parameter values are specified.
73759 Fixed the sort order of custom attributes when listed.
73831 Fixed applying values from filters connected to an update button when calling loadData on a view container instead of using the button.
73834 Prevented data from loading multiple times for filters connected with an update button to a view container and multiple view parameters per visualization.
74085 Fixed an issue preventing a custom unknown member caption from applying to all levels when multiple are displayed at once.
74107 Fixed rows of data appearing in a data result for a formula measure where its values are null and it is set to ignore nulls.
74153 The vUsageTracking view in the application database now returns the tenant ID correctly.
74214 Fixed interactions incorrectly triggered for column headers with one-click sorting enabled.
74339 Prevented another executable from potentially being launched on the server rather than the scheduler service.
74429 Fixed an issue where an embedded dashboard may not be able to be scrolled completely.
74584 Fixed an issue preventing a dashboard-level font setting from taking effect when displayed inside another dashboard.
74675 Fixed issues with passing query string parameters to a report displayed inside a dashboard.
74802 Fixed an issue that could cause an error after a Python transform is configured.
74858 Fixed an error that may occur when processing a data-driven notification.
74975 Prevented projects from being set to inherit privileges from their parent folder.
74976 Prevented result transform settings from being unnecessarily lost when re-connecting or deleting a Union transform in a data cube.
74992 Fixed an issue where additional columns may be hidden when exporting data to Excel from a table visualization with columns set as not visible.
75221 Fixed an issue where the first data bar may not be not visible in a table when displayed inside another dashboard.
75280 Fixed an error occurring on log on with a custom accounts provider that saved a custom attribute with no values.
75431 Fixed an issue where some hierarchy levels may not be displayed in the Set Up Hierarchy Links dialog for a data cube result element.
75440 Fixed using the Dundas BI API in a 32-bit process if the machine has 32 or more cores.
75450 Fixed an error occurring when selecting some tokens for a single DateTime placeholder for a stored procedure in a manual query.
75701 Fixed custom subtotal text displayed for the grand total when the first hierarchy is hidden and the table is displayed as a 'flat' table.
75763 Fixed dates in Excel header rows importing incorrectly.
75862 Prevented hovering over a chart's legend items from changing the selection when Hover To Select Points is disabled.
75867 Fixed extra columns appearing in tables in some cases when changing the level through script.
75871 Fixed color rules incorrectly being applied to chart data points instead of the selected style fill.
75889 Fixed incorrect error message displayed after updating an extension file in the Dundas BI web application.
75942 Fixed setting a view parameter from the query string when another view parameter is connected to the same metric set parameter.
76186 Fixed an error preventing sharing chart axis scales when a table containing data bars is present that is hidden or empty.
76204 Fixed an error preventing some SVG diagrams from Visio from being imported.
76308 Fixed an issue where a custom attribute value that does not exist in an OLAP dimension results in an empty data result.
76410 Prevented tile navigation controls from loading and potentially displaying errors when hidden.

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: 7am-6pm, ET, Mon-Fri