Data & Metrics
This article builds upon earlier walkthroughs in order to show a couple of features of Dundas BI: automatic join capability and user hierarchies.
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.
Dundas BI includes a built-in, default time dimension which contains two hierarchies you can use for filtering, sorting, grouping, and drill down.
This article shows you how to display data from a Microsoft Excel file using simple drag-and-drop operations in Dundas BI.
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.
You can set up states on a metric set to indicate whether your data is in a good or bad condition based on comparison with other measures, formula results, or hierarchy values.
This article shows you how to add a Count measure to a metric set from the Metric Set / Data Binding Panel.
Add relationships between tables to facilitate automatic join functionality and user hierarchy creation in Dundas BI.
Store your data cube in the Dundas BI warehouse or in-memory for possible performance gain and reduced load on your database server.
Define how a measure should be sorted by specifying the hierarchy to sort along and the hierarchy level.
This article shows you how to override the default sorting for a hierarchy and its levels by choosing a sort direction and specifying members to always appear on top or bottom in the sort order.
This article describes the ways in which data can be refreshed in Dundas BI.
Learn how to adjust Dundas BI elements to changes in the structure of your data.
Dundas BI includes the ability to add and modify data within the application to be stored in its warehouse data storage area, and to use this as a data source.
Overview of the script language used in Dundas BI in formulas and the data cube designer.
This article describes the transforms you can use when creating a data cube (ETL process).