Archive for tag: MDX

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

Intro To MDX Decathlon–Cube Space: The Final Frontier (1/10)

30 July, 2012 (13:01) | Decathlon, MDX | By: Mark V

Since this series is an introduction to MDX (Multidimensional Expressions), let’s start off with a few definitions. The following terms form the foundation of our discussion of MDX and Cube Space. Measure: A value used to asses a business process or event. Measures are typically numeric and often map to fields in your fact table. […]

Intro To MDX Decathlon–Introduction

30 July, 2012 (13:00) | Decathlon, MDX | By: Mark V

For quite some time now, I have had an idea in the back of my head right next to some useless trivia about Sherlock Holmes. A blog series with ten parts, called a Decathlon, would be really cool. Particularly with the Olympics Games in London having just started, now is a great time to get […]

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

17 July, 2012 (09:30) | MDX, Presentations | By: Mark V

Digineer, the consulting firm I work for and adore, is starting up a shiny new webcast series. As part of that series, I will be giving my MDX Trek: First Contact presentation via those Internets on August 1st at 1PM Central. Hazzah! If you are interested in attending, or just like clicking on things, please […]

Upcoming Presentation: PASS DW/BI Virtual Chapter May 9th

9 April, 2012 (10:00) | MDX, PASS, Presentations | By: Mark V

I am elated to announce that I will be delivering my MDX Trek: First Contact presentation on May 9th (at 4PM Central Time) to the PASS Data Warehouse and Business Intelligence Virtual Chapter. I have presented to local groups and at SQL Saturdays before (with a few more coming in the next two months) but […]

Using Bogus Measures in SSRS Parameter Available Values Lists

3 April, 2012 (10:00) | MDX, SSRS | By: Mark V

I am currently working on a project involving many reports against an Analysis Services 2008 R2 cube that we implemented for the client. The available values lists for the report parameters are largely just lists of members of various dimension attribute hierarchies from the cube. Since we are not going to actually use any measures […]