“Quick” Dimension Attribute Settings Report

This week I needed to check up on the design of several cubes, in several environments. As I somehow failed to install the SQL Server 2012 Best Practice Analyzer (BPA) properly, I wasn’t able to use that tool. So I build a quick command prompt tool, to check the most basic stuff on attributes?

I have attached the csproj (see below) and the flow of the program is as follows:

First you execute the command prompt, and wait for the process to finish.

AttibuteStatisticsCommandPrompt

After the program has run through all the attributes, you should see the file(s) pop up in the folder you supplied.

AttibuteStatisticsFiles

The CSV file would look something like this (this is AW):

CSV_ScreenShot

Get the solution here:  Attribute Statistics

Leave a Reply

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