Hierarchies in the SQL interface The SQL interface supports only the default hierarchy of a dimension.