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)


Dimension Properties



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.