Cleanse, Consolidate & Modify Data
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 article shows you how to define a placeholder for a manual select transform and use it in your manual queries with parameters.
This article shows how to change the data sources and structures used behind existing data cubes and metric sets.
A cube perspective defines a subset of the available measures and dimensions from a native OLAP cube.
Overview of the script language used in Dundas BI in formulas and data cubes.
This article shows you how to use #TRACE statements in server-side scripts such as the ones used in data cube transforms.
Bridge parameters are an intermediate step in your data cube between a transform's parameter and a parameter value passed into the cube.
This article describes the transforms you can use when creating a data cube (ETL process).
This article shows you how to give a friendly name and description to a transform when editing a data cube.
If the structure of the data used as an input to a data cube changes, you can update the select transform with the added & removed columns.
This article demonstrates how to pass parameter values from a dashboard to a stored procedure.
This article demonstrates how to pass a value from a dashboard to a placeholder in a manual MDX select.
This article shows examples of filtering data using the filter transform with tokens as filter values.
This article shows you how to filter the data cube with complex logical expressions.
This sample uses the R language to create clusters using the K-means model.
This article shows how to display the top/bottom 'N' records and the sum of the remaining records using data cube transforms.
This article shows an example of how to use a stored procedure in a data cube with a parameter for selecting the top 'N' records and grouping the rest as 'Others' for a SQL data source.
This article shows how to replace the '(Empty string)' text from a data cube with an actual empty cell value.