Archive for tag: Decathlon

Power Query Decathlon – Beginner: Introduction

2 January, 2015 (15:12) | Decathlon, Power Query | By: Mark V

Power Query is an add-in for Excel that helps us easily import data from many different sources into Excel. During that process, we have the option to create new columns, change existing ones, filter out rows, and generally shape the data before it arrives in Excel. This is different from the capabilities we have had […]

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

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