Cancel a build/deploy

Maybe I'm the only one that didn't find this right away, but I'll blog about it anyways.

Anyone needed to cancel a deploy/build?  Sometimes my project defaluts back to deploy and build and I only want it to deploy causing me to need to stop the deploy.

Go to the Build menu and a new menu item is there during a build called cancel.

Have fun.

Mark

Dimension Hierarchy Relationships

We all (should) know that it is really important to set up relationships between our dimension attributes.  This enables AS to build aggregations at levels other than the top and the bottom.  For a large cube this could make a huge difference in query speed.  I haven’t found a really clear example of how to set these up so I thought I’d take a stab at it.

When you are editing a dimension hierarchy, you need to add a parent relation ship to all levels.

If you have Year, Month and Day (and a Key) you need to add a releationship to Year in the Month level and a relationship to Month in the Day level and then over on the left, add a relationship to the Key from the Day level.

Every level must have its parent defined as a relationship.

In addition to that, don’t forget to make sure that the relationship type is set up properly.  In this example, we have a rigid hierarchy since we know that no members will be moving around like people in an organization.  March of 2003 will always be a 2003.  Each relationship need to defind whether it is a many-to-one or a one-to-one relationship.  In this example, they are all many-to-one except for the relationship of the key to the Day level.  This would be a one-to-one.

Hope this helps.

Mark

Adventure Works OLTP

In case anyone was wondering, the storefront for Adventure Works can be found at

\Program Files\Microsoft SQL Server\90\Samples\Integrated Samples\Storefront

I was looking for it and had a little trouble finding any info on the web.

Thought I'd blog about it so others won't have to search.

Mark

SQL Server 2005 Samples

I just ran across the SQL 2005 samples and noticed that they had been re-released.  They are now dated 4/19/2006.

http://msdn.microsoft.com/sql/downloads/samples/

Not sure what is different – there isn't a readme that specifies.

Thought I'd let everyone know they seem to have been updated.

Cheers,

Mark

SQL Server SP1

SP1 is out.  Check here for the bugs that are fixed and here for the enhancements.

Go here to get sp1.

Cheers,

Mark