What's New in Dundas BI


1. Overview

A list of highlights from the new features and enhancements available with the release of Dundas BI 7.0.

For a complete list of new functionality and behavior changes, see the List of changes in version 7.0.

2. Installation / Deployment

3. Data Preparation and Analysis

  • Improved way to view table relationships
  • New Dundas BI assistant to perform analysis tasks using natural language user input
  • New Median aggregator and Mode (min) and Mode (max) aggregators to find the highest and lowest values appearing most often in a range of values
  • Exclude expanded hierarchy members from formula calculations when using multi-level hierarchies
  • The following functions have been enhanced to support multiple hierarchy alignment:
  • Correlation
  • Cumulative Total
  • Normal Distribution
  • Percent of Total
  • Percent Rank
  • New icon on certain data cube transforms to indicate when a transform will execute in-memory
  • Set query isolation level when using DB2 connector
  • Collection placeholders are now supported for R Data Generator and Python Generator data cubes
  • The Google Sheets data provider now uses the latest Google API
  • Now use raw keys instead of member unique names when setting up custom attributes for single level hierarchies
  • Disable data caching for specific data cubes
  • Use the search bar to look for data cube input elements
  • Usability improvements to the States and Hierarchy Level Sorting Overrides dialog
  • Rename data cube output elements directly on the Output Elements dialog

4. Data Visualizations

  • New color scale legend to display the ranges of colors generated by color rules
  • New heat map chart type
  • New Identify Clusters recommendation for visualizations like scatter plots or bubble charts
  • Automatically sort stacked bar charts
  • Hide color rules from the legend when there is no matching data
  • Set up rounded borders and round data images

5. Design and View

  • Use the new slicer comparison to compare measures with different filters
  • Use the new Menu component on a dashboard to enable users to navigate through other views easily
  • Relative fonts resize on responsive dashboards when viewed on various devices and browser sizes
  • Display slicer values in tooltips and labels
  • New quarter of year, day of month and week of year time dimension attributes
  • New menu layer to allow using better navigation options when designing a dashboard for use in responsive mode
  • Pass parameter values between multiple views in the sub-canvas view container
  • Set custom permissions for notes
  • Add groups as recipients for notifications
  • Various improvements to the Dundas BI default theme

6. Administration

  • Improved Administration user interface
  • Segregate warehouse databases and in-memory storage types by tenant
  • Export and import the administration configuration settings
  • Admin users can manage CSS, JS, HTML override files and installed extensions from the Administration user interface
  • System administrators can promote tokens created by users to global tokens
  • Log detailed health check error information
  • New data tokens to query the database at runtime
  • New health check to find and fix duplicate table relationships
  • Select the number of CPU cores that should be used and specify which ones
  • Disable/enable tenant to support tenant data migration to/from tenant warehouse database
  • New Job Failure Email Throttle Period configuration option to limit job failure emails

7. API / Branding / Integration

  • Rest API for data cubes have been refactored and could cause a break in the API. The following methods are affected by this change:
  • createElementParameter
  • getAnalysisElement
  • getDataElement
  • datacubeservice.createSchedule
  • New IsAlive method to check the status of the Dundas BI website

8. See also

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

North America: 1.800.463.1492
International: 1.416.467.5100

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