You can add a clause to the statement to describe the relationship between two columns. Analysis Services supports using the following <Column relationship> clause.

RELATED TO

This form indicates a value hierarchy. The target of a RELATED TO column can be a key column in a nested table, a discretely-valued column in the case row, or another column with a RELATED TO clause, which indicates a deeper hierarchy.

The following example creates a mining structure called New Mailing, without creating any associated mining models. To learn how to add a mining model to the structure, see ALTER MINING STRUCTURE (DMX).