Analysis Services DependsonDimension Property

I have never used the Analysis Services DependsonDimension property so I was intrigued when trialling a few configurations dealing with custom dimensional security – what it actually does.   Looks like Chris Webb is all over this so I won’t cover in detail here but suffice to say the property only really gives the Aggregation Design and Usage Based Optimisation Wizards something to ponder when two dimensions are closely related.

Chris Webb Covers DependsonDimension Property

Is also covered in brief here with more explanation – “If a dimension A has a strong correlation to dimension B, then you should set A “depends on” B. This way, the aggregation design algorithm won’t consider both as mutually independent dimensions. For example, Fiscal Time is dependent on Calendar Time.”

http://technet.microsoft.com/en-us/library/microsoft.analysisservices.dimension.dependsondimension(v=sql.90).aspx.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s