April 2008 Entries

powerSSAS: Getting Aggregations for a particular Attribute
If you have ever manually edited aggregation designs, you may have wondered what aggregation currently exist for a particular attribute. Well the following powerSSAS script will give you just that. (you could do this with straight PowerShell, but powerSSAS just makes it slightly easier to address a given measure group) Technically this script is just one single statement, with a couple of parameters to make it more re-usable. I have broken it up in order to make more readable by using the PowerShell ......

Posted On Sunday, April 27, 2008 10:46 PM | Comments (1)

More BI MVP goodness
I just learned that we have some new BI MVPs that were awarded recently On the SSAS front Vidas Matelis (of www.ssas-info.com fame) has received a SQL Server MVP award. And two of my fellow countrymen and PerformancePoint specialists Adrian Downes and Nick Barclay have both been awarded too ......

Posted On Wednesday, April 2, 2008 9:36 AM | Comments (3)