Each Dimension table column can have a transformation associated with it. The transformation is included in the generated procedure and is executed as part of the procedure update.
The transformation must therefore be a valid SQL construct that can be included in a Select statement. For example, we could have a transformation of 'load_order_line.quantity * 0.125' to calculate a tax column of 12.5%.
Click the Transformation tab to enter a transformation code.
The transformation screen is as follows:
Transformations only take effect when the procedure is re-generated.
Microsoft Analysis Services 2005+ Tabular Mode Tables: For Tabular Mode table column transformations, Default DAX is the only applicable Function Set for after load transformations.
Refer to Transformations for details.