Documentation
How-To
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.