Archive for category: MDX

Updated MDX Trek: First Contact Downloads

13 March, 2014 (10:00) | MDX, Presentations | By: Mark V

Greetings. After delivering my MDX Trek: First Contact presentation as part of the Pragmatic Works Free Training series on 3/11, I got some great feedback from an attendee. He pointed out that my single zip file download on my home page for the presentation only contained the SQL Server 2008 R2 version and that I […]

Upcoming Presentations: SQL Saturday #241 Cleveland

27 January, 2014 (10:17) | MDX, PASS, Presentations, Professional Development, SQLSaturday | By: Mark V

        It is with great joy that I announce that I will be presenting at SQL Saturday in Cleveland on February 8th. I have driven through Cleveland before, but never stopped for long. So, this will be my first real visit. Although, if it helps, I used to love to play as […]

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 […]

Intro To MDX Decathlon–PARALLELPERIOD() Function (9/10)

24 September, 2012 (13:00) | Decathlon, MDX | By: Mark V

Like the LEAD() and LAG() functions we looked at in the previous post, the PARALLELPERIOD() function is also useful for travelling through ordered hierarchies. However, there is one really important difference. While LEAD() and LAG() use the hierarchy level of the member passed to the function to determine the hierarchy level to be traversed, the […]

Intro To MDX Decathlon–LEAD() and LAG() Functions (8/10)

17 September, 2012 (13:00) | Decathlon, MDX | By: Mark V

One of the many strengths of MDX is that there are many different functions you can use for travelling through time. And as a plus, none of them require you to sling-shot around the Sun at maximum Warp speed. In this post, we will introduce the simplest of these functions: LEAD() and LAG(). Although I […]

Intro To MDX Decathlon–NON EMPTY and CROSSJOIN (7/10)

10 September, 2012 (14:00) | Decathlon, MDX | By: Mark V

Since you have been following this series with the utmost, life-changing, interest, then you have most certainly read the previous post, Intro To MDX Decathlon – Hierarchy Navigation Basics (6/10). In that post, I used the NON EMPTY keyword and mentioned I would cover it in the next post. Tada! The next post is right […]

Intro To MDX Decathlon–Hierarchy Navigation Basics (6/10)

4 September, 2012 (13:00) | Decathlon, MDX | By: Mark V

Hierarchies are a great asset to cube users. They allow them to drill down into increasing levels of detail with a click. Since hierarchies are so pervasive in cubes, it is pretty much guaranteed that folks who write MDX against cubes will need to perform hierarchy navigation at some point. There are many MDX functions […]

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 […]

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 […]