List of changes in version 4.0

Overview

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

Version 4.0.2.1005

New functionality

TicketDetails
65707 Performance improvement for OLAP data retrieval.

Fixed issues

TicketDetails
66513 Using a date filter when the UTC time zone is not a round hour (such UTC+9:30) returns incorrect results.
66430 Unable to import to an existing project when there is a mismatch in the current revision.
66691 Unable to see project subfolders when using the SharePoint web part.
66852 Re-sizing the view port hides an adapter if it was initially hidden on the dashboard. 

Version 4.0.2.1000

Behavior changes

TicketDetails
65059 The Federated Authentication Bridge now installs as a virtual directory under the primary Dundas BI application. A separate application is no longer required.
65816 The Cascading Member filter control now limits the search to only the current level.

New functionality

TicketDetails
63002 The Microsoft SQL Server Analysis Services data connector now supports Azure Analysis Services.
65230 Federated authentication is now possible even without sticky sessions on the load balancer.
66193 Dundas BI now honors the values of the X-Forwarded-Host, X-Forwarded-Proto, and X-Forwarded-Port HTTP headers when generating redirect URLs. If these headers are not present, the application will default to the value of the External Application URL property. Furthermore, the X-Forwarded-For header is now considered when computing the caller's IP address, along with a Trusted Proxy IP Addresses configuration setting to be used for the load balancer.

Fixed issues

TicketDetails
60860 Adding a note when using a date range filter produces an error.
65129 Script checkboxes do not function as expected when used on a stacked bar chart with multiple series and the Legend Sort Order set to Auto or Reverse. 
65184 Scripts and positioning info are removed from the visualization when using Edit Full Screen. 
65314 Unable to handle date tokens from a bridge parameter when using a calendar range filter.
65324 The Dundas BI Embed Library fails to authenticate when using Mozilla Firefox version 45.
65385 The option Disable No Data Indicator does not take effect at the moment of dashboard check in.
65389 The Dundas BI Embed Library cannot create a loaded callback and a ready callback for the same embedded application.
65451 Stroke properties are not applied on a stacked area chart with a Fill color. 
65586 Job date times are not formatted to the session culture.
65597 SVG diagrams with polygons may be imported incorrectly.
65706 Unable to modify or delete annotations without the context menu privilege.
65730 Unable to filter by a time dimension with a Month of Year hierarchy.
65760 Changes to the parameter type and default value of a parameter placeholder do not save.
65761 The Dundas BI Embed Library cannot retrieve dashboards when using cross-origin resource sharing (CORS) in combination with secure socket layer (SSL). 
65805 Exporting to Excel without styles introduces additional space before hierarchy members.
65820 Health check DBI0100 produces an incorrect result when Dundas BI is installed outside of a domain.
65840 Dundas BI tag compresses JSON files from other IIS applications.
65848 Controls move out of template cells when switching back to Edit mode.
65897 Unable to use Windows Client logon in the SharePoint Web Part when Dundas BI is located in a subfolder.
65977 Embedding a dashboard ignores its Disable data auto loading setting.
66014 Exporting to PowerPoint while using zoom generates empty charts.
66100 Hierarchy members with the same name but different unique ID are not displayed properly when collapsed in a table visualization.
66102 Removing a user from the Global projects prevents them from searching files in other projects.
66121 Changing the view parameter using a script refreshes the filter control incorrectly.
66182 Adding the time dimension on Columns to the time axis of a chart produces an error. 
66220 Expanding some hierarchy members in a flat table produces an error in some circumstances.
66400 Importing a project from Dundas BI 4.0.1.1000 to a later revision produces an error.

Version 4.0.1.1004

Behavior changes

TicketDetails
65245 If a password is present in the connection string for the data warehouse, it now takes precedence over a password specified in the Data Warehouse Password configuration setting. 

New functionality

TicketDetails
65199 When logged on as an administrator, the server name is now visible in the About window.
65230 Federated authentication is now possible even if the load balancer does not handle sticky sessions.
65457 A configuration setting has been introduced to disable the storage of performance statistics.

Fixed issues

TicketDetails
62806/65499 Unable to use SQL Server authentication for a tenant data connector override.
64483 Missing Data Style is not applied when exporting to Excel.
64556 Duplicating a project causes formula visualization metric sets to lose hierarchies.
64938 Modifying the time dimension to be a single level prevents data visualizations with hierarchy level customizations from being exported to Excel. 
65160 Hierarchies removed from the columns of a table are included in an export to Excel.
65351 Unable to use a Union transform for two stored procedures with bridge parameters.
65443 Unable to build multiple warehouse data cubes concurrently.
65446 Unable to get data from a data cube that relies on multiple warehoused data cubes.
65537 The DBI2030 health check fails if a notification is related to a deleted metric set.
65555 Unable to migrate Dundas BI databases to Microsoft Azure.
65568 Health check fails if Dundas BI fails to locate a library referenced by a custom extension.
65591 Using a minimum or maximum aggregator fails when null values are present in the source data.

Version 4.0.1.1000

Behavior changes

TicketDetails
64137 The REST API GetEffectiveValuesForGroup and GetEffectiveValuesForAccount are now GET methods instead of POST.
64323 Anonymous accounts now ignore personalization settings.
64445 The Hierarchies folder now includes a Shared folder linking to the Global project. Conversely, the Cube Perspectives folder no longer includes a Shared folder.

New functionality

TicketDetails
62928 Expanded hierarchy levels are now indented when exporting to Excel.
64493 Data visualizations on reports and scorecards now offer context menu options to change level, drill, expand and collapse, filter, sort, as well as correct and change value.
64560 Federated Authentication now provides an event hook for a successful authentication, which allows an extension to add or remove claims.

Fixed issues

TicketDetails
57449  Filter controls show all the hierarchy members when using OLAP security hierarchies.
61697  Scripts on the Mouse Move action interfere with scripts on the Click action for Linear Gauge data visualizations on Internet Explorer 11.
63817  Numeric text formats are not applied on Excel exports.
63827  Unable to add notes when an implicit date/time filter is present.
64126 Script checkboxes for chart legends are not visible.
64199  Unable to remove a failed silent installation. 
64203 Working with a data connector containing tens of thousands of structures may cause the application database to generate errors.
64325  The data connector option Select Structure is slow when handling many structures.
64353  Unable to specify relationships in Salesforce data.
64383  Unable to add a hierarchy level directly from the data connector's View folder.
64462  Select transforms based on MySQL tables are disconnected during import.
64516  Clicking the text next to a checkbox does not check it.
64595  The Import REST method does not check for null and empty values in the UNC path. 
64718 The server name associated with a forest defaults to the forest name instead of being derived from the domain corresponding to the user/group being queried.
64823  Custom logon URL uses an incorrect return URL after the logon.
64833  The Click action does not trigger on map symbols with size rules when using Google Chrome.
64837  The built-in admin account counts toward the Developer seat license quota.
64859  Setting the interval position on major tick marks to Between Values makes the chart axis un-editable.
64961 Create a new application database is not working in the latest version of SQL Azure.

Version 4.0

Behavior changes

TicketDetails
N/A The default value of the View Usage Tracking Data Maximum Age configuration setting has been changed from 30 days to 120 days.
N/A The Dundas.BI.Data.DataProviders.Reader method protected void Dispose(bool disposing) has been changed from abstract to virtual. Anyone who implemented a custom data provider should change the reader implementation and make all the derived classes call the base method.
N/A The logic for the auto-generation of file names has been changed. There will now be a space between the text and the number in newly-created items, and copied items will receive a "- Copy" suffix.
48483 The WindowsAccount subclass has been removed. Three new classes were added: ExternalAccount, ExternalUserAccount, and ExternalGroupAccount. WindowsUserAccount and WindowsGroupAccount now inherit from ExternalUserAccount and ExternalGroupAccount respectively.
55355 The default export content in scheduled notifications has been changed from Excel to PDF.
55524 The option Use default time dimension now uses the default time dimension of the current view's project rather than the active one.
57525 Windows accounts no longer separate the name into separate Domain and Principal properties. WindowsDomainName and WindowsPrincipalName have been also removed from the API. All account types need to have the name specified in the Name field.
58714 Time Zone localization strings have been moved from web.xml: Account.cshtml, Group.cshtml, and Schedule Rule Dialog.
58363 The methods GetGroupMembershipForAccount and GetGroupMembershipForGroup had been removed. The method GetMemberOf has been introduced instead.
60125 The publishing functionality now requires items to be checked in.
60139 The export JavaScript files have been renamed to dundas.export.xxx.js, these files include the exporthelper, exportrequest, exportresult, pdfpropertyids, and exportservice.
60546 A return URL is always included in the query string of the custom logon page redirect URL. If the initial request did not include a return URL, the root URL of the Dundas BI web application will be sent. Furthermore, the return URL will always be an absolute URL.
60693 Tenant users have been restricted from creating content in projects not associated with their tenant.
60857 The system requirements now include a Microsoft .NET framework of 4.5.2 or higher and Visual C++ redistributable to support the Chrome Embedded Framework (CEF) export provider.
61023 Transform dialogs that do not offer the option to cancel no longer produce warnings when clicking elsewhere.
61041 The Secure option in custom attributes has been renamed to Server-only.
61982 The JavaScript API getTransferFileById has been changed to getTransferFileInfoById and now defaults to a lightweight mode, which takes an ID and can be expanded using an optional object with the property includeAllDetails. Similarly, the REST API [GET] Transfer/Import/{id} has been changed to [POST] Transfer/FileInfo/{id}, which takes the optional class GetTransferFileInfoOptions with the IncludeAllDetails flag.
62544 The method by which Dundas BI distinguishes between Teradata macros from stored procedures is now different. This change will require re-discovering the data connector after the initial upgrade if any Teradata macros are being used.
63648 Application privileges are no longer selected by default when creating an account or group.

New functionality

TicketDetails
38691 Maps now support data brushing.
39343 Access scripts via layers.
39937 Define the intersection point for chart axes.
40387 Automatically reconnect filters when undoing a deletion.
40921 Show map labels only on elements with data.
40989 Log to see the queries Dundas BI is sending to the database.
41909 Add annotations (notes) to Treemap visualizations.
41538 View inherited custom attributes for an account or group.
42258 Select row headers in the Bound Visual list when setting up a navigation.
42290 Add notes to a Gauge data visualization.
42519 Automatically create header controls when adding a label to the repeater area of a report or scorecard.
42545 Display body areas between child groups in a report or scorecard.
42634 Control the maximum file upload size.
42876 Export and import the System Everyone group.
42885 Re-wire the data flow.
44898 Apply measure formatting to chart axes.
45382 Configuration setting to specify which accounts will get an email notification when a job fails.
45642 Control the visibility of a series using the legend item checkbox.
46256 Emails will be logged in the Email channel when the Email Delivery Type is set to Test.
46266 Select from available values for custom accounts, groups, or group membership providers.
46427 Apply row header text wrapping.
46597 Add annotations (notes) to pie charts.
46935 Double-tap to zoom.
47138 Users now receive a message when dashboard functionality requires rebuilding the data cube.
47923 Define default center point and zoom level in map data visualizations.
47951 Connect to EXASolution databases.
48287 Customize notifications per recipient.
48483  Set up federated authentication. 
48521 Test bridge parameter scripts from the Data Cube Designer.
48651 Apply states to Treemap visualizations.
48633 Support SVG files from Visio in diagrams.
48725 Use hierarchies in formulas.
48742 Support for multiple field for shape names from ESRI files.
48765 Apply the group header text border through the entire header.
48840 Auto-refresh the Jobs and Job Details pages.
48934 Time dimensions with more granular levels, including hour, minute, and second.
49039 Set up a state styles for an entire row.
49506 Health check for the tenant and group foreign keys.
49573 A submit button appears in filters when Set value immediately on change is disabled.
49648 Set the corner text for a transposed table.
49698 Group header format options.
49864 Allow HTML formatting on a text column.
50780 Hide Grand Total when using Single Indented Column.
51091 Export logs from the Dundas BI user interface.
51130 Data Input transform.
51142 Data connector folders for Programmatic Structures and Functions are now created during discovery.
51162 Top-align corner text in a table.
51192 Enter a Name in the Allowed Data Providers.
51311 Specify a tenant when duplicating a project.
51630 Sort accounts.
51696 Auto-select the target project when republishing.
51949 Align row header text in a table.
52083 Show Gauge measure values.
52561 Connect to Vertica databases. 
52594 Import/export project files through the command line.
52596 Install a license through the command line.
52614 Add and manage tenant accounts.
53007 Freeze table columns.
53018 Set the bound visual of an interaction to any bound visual rather than the whole control.
53025 Show only sorting options or only filtering options in the Sort and Filter menu.
53349 Sankey diagram data visualization.
53418 getDisplayedText method for data labels.
53585 Support transform attributes in SVG diagrams.
53662 New Re-Visualizing and Re-Visualized actions.
53784 Apply the mouse cursor property to individual columns in a table.
54333 Blank data visualizations now display an icon representing the type of visualization.
54434 Override the tooltip mouse delay for data visualizations.
54471 Prevent column resizing in tables.
54572 Restrict a session to a specific IP address.
54638 Bypass custom attribute security for admins.
54726 Improve the performance of hover over interactions.
54845 Resolved potential vulnerability issue by hiding the session ID from the query string and applying Secure, HttpOnly, and HostOnly when using HTTPS.
54889 Select the appropriate filter type automatically with Smart filters.
55264 Health check to find overly-fragmented App Db indexes.
55316 Set the configuration value for non-core modules via the command line.
55420 Filter by time.
55428 Support for dundasImageResource image path in table image columns.
55558 Export and Import tenants using the Dundas BI user interface.
55698 The cursor changes to a pointer over the Seat Usage, to indicate the numbers are clickable.
55755 Automatically configure the default PDF export page size based on the user's session culture.
55892 Improved search and filtering performance for the Shown Members option.
55952 Prevent My Project from being created automatically during first logon.
55999 A "splash screen" appears while the data and the dashboard are loading.
56304 Start jobs from the Job Details page.
56554 Enable authentication from multiple Active Directory forests.
56573 Align text in table column headers.
56600 The Jobs and Job Details pages now indicate the schedule status of the job.
56645 Check for missing third-party drivers via the health check.
56685 Display both years when a fiscal year is in two calendar years.
56845 Customize the logon page by tenant.
56930 Use a JSON key instead of the p12 key for Google data providers.
57005 Create Azure SQL Databases or Amazon DB2 during installation.
57068 Add annotations (notes) to data labels.
57167 Connect the link width in relationship diagrams to data.
57252 Rearrange nodes and auto-zoom to fit relationship diagrams.
57287 Display round numbers for size and color rules.
57305 Navigate to the default view option.
57320 Total count labels on the Accounts, Groups, Sessions, and Tenants pages.
57413 Change the cursor when hovering over a data point.
57525 Log on with Windows User Principal Name (UPN).
57589 Use the Dundas BI ember library.
57592 Download uploaded data connector and image files.
57594 Smart data visualizations.
57607 Health check to determine whether the Scheduler service is down.
57608 Set the width of the Single Indented Column.
57648 Display subtotals in the frozen total rows when scrolled out of view.
57727 Limit the maximum width of an adapter in a header cell of the template.
57761 Redesigned dock location and the ability to set the maximum width and height for adapters.
57791 Upgraded JSON.NET to version 9.0.1.
57845 Show only menu and task bar when opening the view.
57951 Wrap text for a column header when a hierarchy is used.
58208 As an admin, see the tenant ID in the file system properties.
58296 Manage user notifications.
58363 View inherited groups for accounts.
58423 Set the indent width of the Single Indented Column.
58435 Publish into a tenant project.
58452 Rollback to a database backup if an upgrade failed.
58856 Configure the default time zone.
58704 Advanced options for Missing Data Rules.
58708 View performance information for embedded items.
58714 View the Valid Until and Time Zone session properties in the admin user interface.
58960 Highlight table rows on hover on all admin pages.
58972 Style a tile as Selected.
59144 Usage Tracking to includes the Tenant ID.
59198 View tooltips with aggregator description when configuring a data cube node.
59199 Curved link type in relationship diagrams.
59217 Use API to get the value of a configuration setting for non-admin users.
59254 Discover and add only tables selected in the data connector.
59265 Change the Cell Value Change animation to slide up or down according to the change.
59433 Treemaps now support data brushing.
59609 Show the column hierarchy dimension in the table corner.
59624 View other adapter boundaries when moving an adapter.
59625 Select all adapters within a template area.
59626 Quick sizing of multiple adapters.
59627 Align adapters to center horizontally or vertically.
59628 Hide or hide if empty on report template areas.
59634 Add or delete template areas to reports.
59636 Add metadata to reports.
59638 Set report width by paper size.
59640 Repeat group header on a new page.
59641 Map the repeater to parameters in an embedded dashboard.
59644 Visual indicators of page breaks in a report.
59752 View a list of data points not shown on the map.
59801 Add a password to protect the data warehouse connection string.
59819 The method Job/Run/{id}/ now returns the Job Run ID for the started job.
59826 Navigate to instances from the deployment application.
59862 Rebuild data cube from the context menu.
59689 The list of adapters in a layer are now grouped by template area.
59962 Relationship diagrams now support data brushing.
60033 Hold Shift to ignore drop zones on a control.
60102 Set the default view from the Customize Home area.
60341 Restrict admin sessions to specific IP address ranges.
60390 Recommended data connections when dropping a metric set onto a map visualization.
60639 Improved performance when using the keyboard to move adapters.
60899 Automatically convert elastic seats when a floating seat is available.
61160 Correlation matrix formula for formula visualizations.
61178 Use tokens with the operators in a Filter transform.
61357 Re-order scripts under an action.
61358 Hide or show table columns from the context menu.
61562 Use implicit time hierarchies in trend and forecasting functions.
61654 Get a collection of layer adapters that match the layer friendly name using .getLayersByFriendlyName.
61686 Set up Always Encrypted with SQL Server 2016.
61720 Add annotations (notes) to dynamic measures.
61788 Disable no-data indicators.
62092 Auto-generate a report from a table.
62144 Data Input interaction.
62204 Set the creator and the company for Excel and PowerPoint exports.
62240 Apply a license during silent installation.
62294 Hook to the ImportFinished event.
62296 Rebuild database indexes from the Dundas BI user interface.
62451 Clear the Most Recently Used list.
62833 Track logon history.

Fixed issues

TicketDetails
40349 Removing data connection to the tooltip text overwrites other text areas.
43851 Viewing multiple series on the Properties panel makes it difficult to tell them apart.
47437  Data connectors from uploaded files do not match the file name.
50236  Applying states on a table does not update the State Indicator column.
51968  Maps with symbols plotted at latitude and longitude coordinates do not automatically zoom.
53454 Renaming output elements does not save for OLAP data.
54353 The Default View picker does not have a scroll bar in Internet Explorer. 
56929 Popups do not open near the cursor when there is not enough space on the viewport. 
57935 Resizing a map scrolls the content out of view. 
58120 Security hierarchy members are not available when editing the custom attribute value. 
58280 Selecting all accounts for has incorrect paging. 
58340 Appending the date to the notification file name is not working. 
58880  An admin with two active sessions has an unclear licensing message. 
58975 Using Period Over Period on a formula measure does not display data.
59007 Filtering returns different results for unknown members depending on the data storage.
59011 Treemaps are not showing tooltips after removing and re-adding a measure.
59038  Attempting to open the Script Editor with a Power User seat type results in a JavaScript error.
59304 Passwords stored by data source credential service are not salted. 
59445 The Null token of a Single Date filter is not working.
59524 Switching from Raw to Standard data retrieval does not reflect on the toolbar. 
59542 Unable to delete an empty note from the chart. 
59780 White lines appear in frames when using Internet Explorer.
59893 Disabling the Show sort and filter menu property does not remove the icon on the table.
59997 Font weight is not applied to row numbers.
60057 Exporting to PowerPoint includes incorrect creation date.
60261 Treemaps are not showing tooltips after data refresh.
60274 Bridge parameter scripts are not triggered by tokens. 
60286 Relationship diagrams with the node fill set to an image are displayed as black. 
60372  In-memory cube storage runs out of memory while building.
60463 Relationship diagrams do not work with dynamic hierarchies. 
60540 The missing data rules do not handle calculated missing cell values.
60848 The cleanup Job Details page is slow.
60918 Using the property Set Value On Any Filter Change makes the option Show Checkboxes disappear.
61225 Unable to clone a project with a specific admin user.
61258 Changing the Sweep Direction of a pie chart to Counterclockwise makes it disappear when showing the Grand Total.
61274 Missing Data Rule behaves differently with an In-Memory data cube.
61325 Updating a metric set from a dashboard after changing table properties breaks the table. 
61444 Checkboxes in a filter control are partially selected when navigating to another dashboard. 
61482 Pivot transforms do not allow nulls in the value element.
61549 Bypass data cache is not working properly on a scorecard.
61613 Adding HTTPS Bindings during a silent installation creates a certificate error. 
61754 Tooltips are not showing in the Revision History viewer.
61793 Data point labels are displayed outside the chart. 
61812 Formula visualizations are not filtered by custom attribute data. 
61836 Using multi-value custom attributes as a security hierarchy for an in-memory cube returns no data. 
61913  Unable to save a scheduled notifications with Intra-Day Recurrence. 
61982 Error when importing a DBIE file.
62000 Changing the Unknown Member Caption of a dynamic hierarchy does not work. 
62272 Hyperlinks require a double-tap to navigate in iOS using Safari.
62335 Unable to change account from Developer to Floating Standard User if the license does not have floating standard users. 
62364 Unable to expand hierarchy after using Collapse All. 
62386 Bridge lines in waterfall charts are misaligned.
62391  Re-using a data cube with an Output Element Filter shows incorrect data. 
62444 The Member of section for a tenant user account does not show non-tenant groups.
62509  The last delivery date shown in the list of notifications is offset when using Internet Explorer or Firefox. 
62515 Custom column text is incorrectly applied during Excel export. 
62559 Adding a license for a higher version of Dundas BI causes an error. 
62623 Charts based on OLAP data lose their zoom settings while filtering.
62675 Transform parameter value appears as zero when setting the value using a custom attribute.
62767 Unchecking an only child in a filter behaves differently from inverting the filter. 
62773 Using measures or hierarchies from a Google Sheets data connector on a dashboard produces an error. 
62776 Exporting a report to PDF does not apply filtering.
62825 View parameters and Navigate settings are changed after publishing the dashboard.
62834 Scheduling an in-memory cube build presents a dialog about regenerating hierarchies and measures.
62848 Unable to override the file name prefix for database exports.
62893 Setting the value of a Single Date filter via a script does not return any data. 
62935 Filtering is lost when exporting scorecards or reports to Excel.
62938 Access data source requires parameters.
62991 Filtering OLAP data may produce incorrect totals.
63050 Empty space in the PDF when exporting a dashboard with large dimensions.
63051 A OLAP data connector override for multi-tenancy does not set the default value properly.
63068 Adding a formula to a second metrics set in a data visualization generates a series connected to the first metric set.
63358 The CSS setting the background color applies to elements other than the canvas.
63399 REST API calls are failing their pre-flight checks.
63790 The Dundas BI installer allows users to install on LocalDB.
63957 Text replacement for totals and sub totals clears some of the member text.

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