What's New in Dundas BI

Contents[Hide]

1. Overview

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

Tip

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

Create a ragged or unbalanced hierarchy, based on self-referencing or recursive data
Hierarchy Attributes
- Identify additional 'attributes' of a hierarchy's values and easily select them when using that hierarchy
- Conserve memory consumption when building in-memory cubes compared with using separate hierarchies
- Select a time dimension's attributes Month of year and Day of week together with a hierarchy at the same time
Formulas
- More flexibility for setting up custom total calculations
- Set a measure placeholder to refer to values from a different row, column, or aggregator in your formulas
- New DISTANCE function to calculate the distance between latitude & longitude coordinates in formulas
New experience for formatting measures with easy-to-use options, previews, and predefined formats available
Use the Pivot transform to pivot non-numeric data in a data cube
New Merge transform for easily combining two columns into one
Data Connectors
- Find all discovered tables and ranges from an Excel file listed under Programmatic Structures
- New, easier-to-use Google Analytics data connector providing a cube data source
- Connect to SQL Server Azure using Active Directory authentication
- Data connector for Snowflake cloud data sources
- Pardot data connector

Radar charts
- New Radar Point, Radar Line and Radar Area charts
- Visualize circular data such as time, directional data, or repeat a circular chart shape and look for recognizable patterns
- Set up a series as Radar Range or Radar Stacked Area advanced chart types in Properties
Animated transitions of colors and locations when data changes in a map or diagram
Tables
- Set up a grand total column style
- Customize cell text for certain states/conditions using keywords
- Adjust small tables in reports, scorecards, or small multiples to fit varying numbers of rows
Hide null/unknown values in a tree diagram for ordinary data to appear like a ragged or unbalanced hierarchy

Small Multiples
- Create a Small Multiple view (or 'trellis chart') to repeat visualizations for different data for easy comparison
- Lay out a series of visualizations horizontally, vertically, or both, and wrap them to fit within the available width
Quick Access Properties popup to customize font and appearance for the element you clicked on
Customize the appearance of various parts of filters from the Properties window
Preview fonts and colors within the dropdown before selecting
Use the Layers window to rename, lock/unlock, and highlight elements or groups
Set up a 'sticky' or frozen header in responsive dashboards, and in reports and scorecards
Set up a group of cells spanning a row as a header in a responsive dashboard
Use rich formatting when setting up notification emails

Recycle Bin: recover recently deleted files from your profile
Publish multiple files from within a project at once (without publishing the entire project)
Maintain the cube storage type when publishing, with a prompt to build the cube

Message displayed on the administration home screen when a new version is available
Warehouse data cubes separately per-tenant when using data connector overrides
Ability for tenant administrators to create custom attributes for their accounts & groups
Ability to auto-create accounts associated with a particular tenant

Notification displayed with upgrade option when a new version of the Dundas BI Deployment application is available
Set up multiple scheduler services when deploying as a server farm for high-availability of scheduled actions
Add a scheduler service to an instance using the deployment application after deploying without one

Create custom export and delivery providers for sharing and notifications
Use the REST API to get the result of an export
Create an account as an API-only account, which doesn't consume a license
Clear personalization settings for all users of a view or instance
Specify EffectiveAccountName to log on as another user using an administrator account using the .NET and REST APIs
Query for which files are available for a specified account ID without logging on in a separate session