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 5.0.

2. Data Visualizations

• Tables
  • Display a prominent indicator on the column when filtered
  • Display axes in the headers for bullet graphs and databars
  • Show all bullet graphs with the same scale
  • Rotate column headers
  • Set up one-click sorting
  • Improved experience for grouping and sorting
• Chord diagrams
• Tree diagrams
• Display images on relationship diagram nodes
• Maps
  • Specify the coordinate system with a PRJ file
  • Show heat maps
  • Show geographical data from third-party map providers
  • Set the minimum and maximum zoom levels
• Charts
  • More easily see and compare series details as the mouse moves over a line chart
  • Display point and bubble chart data as hollow points with a new checkbox setting

3. Data Preparation and Analysis

• Connect to databases using a JDBC data connector
• Data cubes
  • Generate and analyze data using Python scripts
  • Indicate high level links for explicit hierarchies
  • Pass collection values to a manual SQL placeholder
  • Incrementally update data cubes
  • Use record grouping in the Top/Bottom transform
  • View data statistics in the data cube designer
• Aggregate data points into a single Other row
• Formula
  • Forecasting using exponential smoothing
  • K-Means clustering
• Create custom member groups during analysis
• Open a copy of the metric set for analysis
• Use tokens when setting up states

4. Design and View

• Set up dependencies between filters
• Export
  • Hide a measure or hierarchy from the data export
  • Set the export timeout value for individual dashboards and reports
  • Export single indented column as a single column in Excel
  • Cleaner export to Excel when using multiple hierarchies
• Disable application privileges at the view or data visualization level
• Define font settings for the entire dashboard or template
• Interactions
  • Clear the input fields and refresh multiple visualizations with the Data Input interaction
  • Change multiple layers with a single interaction
• Set up data driven notifications for an entire column
• Set up custom data brushing
• Insert keywords into text properties using a menu
• Update uploaded files
• Templates
  • Change the spacing between template cells
  • Detach the template from a dashboard
• Report/Scorecard
  • Create scorecards and reports from a Standard User account with pre-made metric sets
  • Re-use metric sets to boost performance
  • Move controls in the body area by moving the associated header control
• Exclude or keep only selected data points
• Change the top level of the hierarchy from the context menu

5. Administration

• Use PostgreSQL instead of SQL Server to run Dundas BI
• User profile
  • Download generated export files or view/cancel queued files from the user profile
  • Enable, disable, and run notifications from the user profile
• Hide select export options from the Share menu
• Track logon history from the administration interface
• Open user notifications for editing from the administration menu
• Prevent users from overriding the default view set by an admin
• View, edit, and delete unused entities in a project
• Whitelist email address domains for notifications
• Set up a server farm using the Dundas BI deployment application
• User interface
  • New home screen for finding and viewing content
  • Landing page for system administrators
  • Manage application privileges in a more flexible manner
• Delete old entity data using the dt command line tool
• Limit the number of concurrent export requests

6. See also

• Dundas BI release notes
• List of changes in Version 5.0