May 30
Dimension Health Check

Here is a Visual Studio (Data Tools) plug-in named Dimension Health Check which is available on CodePlex - http://bidshelper.codeplex.com/wikipage?title=Dimension%20Health%20Check

The Bids Helper – Dimension Health Check checks for uniqueness, proper parent and child relationships, and keys.
Once you have installed the plug-in you can right click any dimension in a SQL SSAS DB Solution Explorer and select Dimension Health Check.

In this screen capture I used Visual Studio 2010 Shell (Integrated) 2012 SQL Data Tools.

 

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools