Data & Metrics

Overview of the main elements of the Dundas BI data model and the flow of data in the system.

Learn how to create a new data cube in Dundas BI and add transforms to it in order to join three database tables.

This walkthrough shows you how to create and use metric sets in Dundas BI and apply filters.

This article shows you how to display data from a Microsoft Excel file using simple drag-and-drop operations in Dundas BI.

This article builds upon earlier walkthroughs in order to show a couple of features of Dundas BI: automatic join capability and user hierarchies.

Add relationships between tables to facilitate automatic join functionality and user hierarchy creation in Dundas BI.

Dundas BI includes the ability to add and modify data within the application, and to store it in its warehouse data storage area.

You can set up states on a metric set to display some data differently when it falls within that state, based on comparisons with other values.

This article shows you how to add a Count measure to a metric set from the data analysis panel.

Define how a measure should be sorted by specifying the hierarchy to sort along and the hierarchy level.

This article shows you how to customize the sorting for a hierarchy and its levels from the data analysis panel by choosing a sort direction and optional members to appear on top or the bottom.

Dundas BI includes a built-in, default time dimension which contains two hierarchies you can use for filtering, sorting, grouping, and drill down.

Store your data cube in the Dundas BI warehouse or in-memory for possible performance gain and reduced load on your database server.

Learn how to adjust Dundas BI elements to changes in the structure of your data.

This article describes the ways in which data can be refreshed in Dundas BI. 

Overview of the script language used in Dundas BI in formulas and data cubes.

A cube perspective defines a subset of the available measures and dimensions from a native OLAP cube.

A date mapping connects a hierarchy from your native OLAP cube to a Dundas BI time hierarchy format.

This article describes the transforms you can use when creating a data cube (ETL process).

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