SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide required information about factual data in cubes. By default these objects are bound to one or more columns in one or more tables in a data source view. The attributes can be arranged as hierarchies that will help to navigate the user path when...(<a href="http://sqlserver-qa.net/blogs/bi/archive/2011/03/25/sql-server-analysis-services-multi-level-hierarchy-dimension-design-gotchas.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=10054" width="1" height="1">