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
| Ticket | Details |
|---|---|
| 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
| Ticket | Details |
|---|---|
| 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
| Ticket | Details |
|---|---|
| 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
| Ticket | Details |
|---|---|
| 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
| Ticket | Details |
|---|---|
| 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 Point, Line, 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
| Ticket | Details |
|---|---|
| 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. |