• I don't know if the original poster was asking about multi-dimension or tabular, but in tabular, all your hierarchy fields have to exist in the same dimension. A way to get around this, though, is to create a new calculated member in your dim table and use the =RELATED function. For instance, I wanted to create a Product Hierarchy (Category-Subcategory-Product). On the dimProduct tab, you'd create a new column for ProductCategory and use the function =RELATED(DimProductCategory[EnglishProductCategoryName]). You'd do the same thing for ProductSubcategory. =RELATED(DimProductSubcategory[EnglishProductSubcategoryName]). Now you can use them in your hierarchy.