Archive for month: October, 2012

SQL Saturday Nashua (146) Recap

25 October, 2012 (13:00) | PASS, Professional Development, SQLSaturday | By: Mark V

On October 20th, I had the pleasure to attend SQL Saturday 146 in my hometown of Nashua, NH. To speak in the vocabulary of my youth, it was wicked good. I have decided to have parts of this post be in Bostonian, the dialect of English that is common in a pretty wide radius around […]

SQL Saturday Minnesota (149) Recap

10 October, 2012 (13:00) | PASS, Professional Development, SQLSaturday | By: Mark V

My customary post-SQL-Event post is a Top Ten List. I have decided that I do not wish to be bound by the limitations of the number Ten. Therefore, from here on out, my plan is to do a more free form recap. SQL Saturday #149 just took place in Minneapolis, MN, on September 29th. There […]

Intro To MDX Decathlon–PERIODSTODATE() Function (10/10)

1 October, 2012 (13:00) | Decathlon, MDX | By: Mark V

For the final post in this series, we’ll take a look at the PERIODSTODATE() function. Your skills of predictive analytics should suggest that this is a handy one to use for reports needing calculations for year-to-date, month-to-date, etc. The PERIODSTODATE() function takes two inputs: [Level]: The hierarchy level defining the “Period” part of the period-to-date […]