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.” :)

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) ......

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 ......

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 ......

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) :) ......

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online
Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: