Data & Metrics
Overview of the script language used in Dundas BI in formulas and the data cube designer.
Data Input lets you reference a warehouse data storage area containing user input data, and add or modify data from inside Dundas BI. This article shows you how to set up a simple data input table from the Metric Set designer and one of the view designers.
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 main elements of the Dundas BI data model and the flow of data in the system.
This article builds upon earlier walkthroughs in order to show a couple of features of Dundas BI: automatic join capability and user hierarchies.
Dundas BI includes a built-in, default time dimension which contains two hierarchies you can use for filtering, sorting, grouping, and drill down.
Add relationships between tables to facilitate automatic join functionality and user hierarchy creation in Dundas BI.
This article shows you how to display data from a Microsoft Excel file using simple drag-and-drop operations in Dundas BI.
Learn how to create a new data cube in Dundas BI and add transforms to it in order to join three database tables.
Store your data cube in the Dundas BI warehouse or in-memory for possible performance gain and reduced load on your database server.
This walkthrough shows you how to create and use metric sets in Dundas BI and apply filters.
This article shows you how to add a Count measure to a metric set from the Metric Set / Data Binding Panel.
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.
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.
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).