Documentation
Cleanse, Consolidate & Modify Data
Using a data cube to join tables
Learn how to use data cubes to integrate and transform data into a reusable data model, using joining as an example.
Data cube storage types
You can store your data cube in the warehouse or in-memory to help improve performance and reduce the load on your database server.
Using manual select placeholders
This article shows you how to define a placeholder for a manual select transform and use it in your manual queries with parameters.
Re-wire the data flow
This article shows how to change the data sources and structures used behind existing data cubes and metric sets.
Create a cube perspective
A cube perspective defines a subset of the available measures and dimensions from a native OLAP cube.
Writing data scripts with DundasScript
Overview of the script language used in data-related features such as formulas and data cubes in Dundas BI and Logi Symphony.
Using TRACE statements
This article shows you how to use #TRACE statements in server-side DundasScript such as the ones used in calculated element transforms.
Using a bridge parameter
Bridge parameters are an intermediate step in your data cube between a transform's parameter and a parameter value passed into the cube.
List of transforms
This article describes the transforms you can use when creating a data cube (ETL process).
Give a friendly name to a transform
This article shows you how to give a friendly name and description to a transform when editing a data cube.
Update a select transform when the data source changes
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.
Passing parameter value from dashboard to stored procedure
This article demonstrates how to pass parameter values from a dashboard to a stored procedure.
Passing placeholder value from dashboard to manual MDX select
This article demonstrates how to pass a value from a dashboard to a placeholder in a manual MDX select.
Using the filter transform with tokens
This article shows examples of filtering data using the filter transform with tokens as filter values.
Filter data cube using complex logical expression
This article shows you how to filter the data cube with complex logical expressions.
Clustering predictions using R language analysis
This sample uses the R language to create clusters using the K-means model.
Display 'top N + other' measures using data cube transforms
This article shows how to display the top/bottom 'N' records and the sum of the remaining records using data cube transforms.
Display 'top N + other' measures using stored procedure
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.
Replace '(Empty String)' text with empty value
This article shows how to replace the '(Empty string)' text from a data cube with an actual empty cell value.