Archive for month: August, 2012

Intro To MDX Decathlon–.members Function (5/10)

27 August, 2012 (13:00) | Decathlon, MDX | By: Mark V

In the previous post in this series, Intro To MDX Decathlon – Sets: A Shirt of a Different Color (4/10), we defined a Set and also discussed the rules that valid sets must follow. In this post, we will introduce a function that can provide an easy way to form a set: .members. The .members […]

PASS Regional Mentor–Canada

22 August, 2012 (13:00) | PASS, Professional Development, Regional Mentor | By: Mark V

I had mentioned in my most recent PD post, Professional Development Plans: Turning Your Job Into a Career, Part 2, that I wanted to jump back into SQL Community involvement and let PASS know of my desire to become a PASS Regional Mentor (RM). I was on the Executive Board for the Minnesota chapter of […]

Intro To MDX Decathlon–Sets: A Shirt of a Different Color (4/10)

20 August, 2012 (13:00) | Decathlon, MDX | By: Mark V

In the previous post in this series, Intro To MDX Decathlon – The Trouble With Tuples (3/10), we discussed how to reference a particular cell in a cube by using a Tuple. Now it’s time to group them together using a concept we haven’t discussed yet: the Set. Its basic definition is deceptively simple: Set: […]

Intro To MDX Decathlon–The Trouble With Tuples (3/10)

13 August, 2012 (12:30) | Decathlon, MDX | By: Mark V

In this third installment of my Intro to MDX Decathlon, we cover the hugely important Tuple. Before we get into the details, I want to make a quick note about pronunciation. There is some controversy over how to properly say the “tup” in Tuple. In one camp, there are the folks that say it must […]

Upcoming Presentation: MDX Trek: First Contact on August 21st

9 August, 2012 (13:00) | MDX, PASSMN, Presentations | By: Mark V

I will be giving my MDX Trek: First Contact presentation to the mighty Minnesota Chapter of PASS (PASSMN) on Tuesday, August 21st. You can come live and in person to the Microsoft office in Edina or attend via Live Meeting. Get more details of register here. Happy days.

Intro To MDX Decathlon–The Basic MDX Query (2/10)

6 August, 2012 (13:00) | Decathlon, MDX | By: Mark V

In the previous post in this series, Intro to MDX Decathlon – Cube Space: The Final Frontier (1/10), we learned the terminology we use when talking about cubes and cube space. We also gave a little primer on a helpful way to imagine the cube space while working with MDX. In this post, we will […]