July 2006 Entries

Quote of the week
“Some people are like Slinkies - not good for much, but they still bring a smile to your face when they tumble down the stairs.” :)

Posted On Sunday, July 30, 2006 9:26 PM | Comments (0)

Product of values in MDX
There was an interesting question on the Analysis Services newsgroup tonight which involved a requirement to produce a product of a set of values. ie. value1 * value2 * value3 * .... valueN You could do something like this with a unary operator, but that would change the aggregation for all measures. In order to do this for just a single measure I proposed exploiting a technique I saw Itzik Ben-Gan use in T-SQL. The basic mathematical proof for this technique was the following: logN (val1*val2*...*valn) ......

Posted On Tuesday, July 18, 2006 9:30 PM | Comments (3)

Some new blogs
I have come across a couple of interesting new blogs in the last few days. Chris Baldwin - Program Manager for Reporting ServicesHas an interesting first post on reducing the amount of merged columns when exporting a SSRS report to Excel Elizabeith Vitt - from SQL SkillHas 2 good posts up, one about how attribute relationships affect aggregation designs. This is well worth reading, I think this is an area that is going to trip up a lot of people. I don't think there is a lot of understanding out ......

Posted On Monday, July 17, 2006 8:57 PM | Comments (0)

Getting a Cell from Analysis Services 2005 using PowerShell
I noticed that the scripts library at http://scripts.readify.net/ had an example on returning results from a SQL table. Not to be out done by the relational guys, I thought I would post an example of how to do the same thing against an Analysis Services 2005 cube. I can see that this could have some value in a production environment in that it could be used to automate the validation that a given tuples in the cube matched the results from a source system.function get-cell { param([string] $server ......

Posted On Wednesday, July 12, 2006 8:37 PM | Comments (0)

I'm an MVP!
Woo-Hoo! I got an email from Microsoft yesterday afternoon telling me that I am “a recipient of this year’s Most Valuable Professional (MVP) award” A special thanks goes to Edward and Greg and Marco, but there are may others that have helped along the way. I also want to thank all the little people (the smurfs, leprechauns and Oompa-loompas) :) ......

Posted On Monday, July 3, 2006 9:04 PM | Comments (6)