SSAS - Attribute relationship and Hierarchy of dimension
Most of the scenarios, there will be relation between different attributes of the same dimension and in this case we have to explictly define the relationship using dimenison designer. It improves the performance as well as affects calculations that are aggregated across these attributes. There is a chance of performance degrade if the relationship is not set properly. In this post we can see the steps to set attributes relationship and also important properties of the same. We can use the same DSV(AdventureworkdDW2008) that I used to demonstrate named query where I have replaced the below query with the actual DimProduct table. select a.ProductKey ,a.EnglishProductName ,b.ProductSubcategoryKey ,EnglishProductSubcategoryName ,c.ProductCategoryKey ,EnglishProductCategoryName from dimProduct a inner join DimProductSubcategory b on a.ProductSubcategoryKey = b.ProductSubcategoryKey inner join DimProductCategory c on b.ProductCat