When you start designing dimensions of an OLAP cube in Business Intelligence Studio( version 2008) or SQL Server Data Tools, there are some properties and configurations which I think that they are quite important. I have tried to summarize all of them in one picture and hopefully it can help you to be easy for understanding and how to use them appropriately. (Contact me if you need the original image)

Advertisements