Welcome to Salvo(z)

SSAS Event Type Calculation Dimension

Tuesday, May 21, 2013
by jsalvo

Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube.  For example, we can define a ‘Year to Date’ calculation in a calculation dimension and it will work for any measure.  Alternatively, we could define a new ‘Year to Date’ calculated member for every current measure in the cube, but this would cause our list of members to expand significantly and create clutter.  Therefore, calculation dimensions provide a nice option to minimize the number of calculated members in a cube; yet, still allow users to perform the necessary analysis.

read more...

SSAS 2012 Tabular Cubes PowerPoint Presentation

Sunday, May 5, 2013
by jsalvo

I presented an introduction to SSAS 2012 Tabular Cubes at a few PASS chapter meetings and SQL Saturday 206 in Madison, WI.  A few individuals have asked for the PowerPoint slides, so I am posting them here on my blog to share: SSAS 2012 Tabular Cubes Presentation

read more...

Windows Azure VMs go Live

Tuesday, April 16, 2013
by asalvo

I’ve been using Azure VMs since they launched as part of a public preview program last year at TechEd. Since then, I and members of my extended team have:

read more...

Count Weekdays in MDX

Sunday, March 24, 2013
by jsalvo

Nokia Lumia 920: No Screen During Call

Monday, March 18, 2013
by asalvo

I recently acquired a Lumia 920 and changed providers from Sprint to AT&T so that I could get the 920. So far I like the phone but ran into an interesting problem. Today I needed to dial into a conference bridge, so I browsed for my saved contact that I use for this and hit call. Usually the first thing I do after the phone “app” comes up is hit mute, but before I could do that, the screen went dark.

read more...