Modifying SQL in a Lookup Transform

Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...

Selecting Top N Rows from Excel Source

Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...

SSAS Query Processing and Performance Tuning

Any of us can work with some simple MDX queries and get them to do what we want, but in...

Testing Security in SSAS

Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...

Quotes in Calculation Tab

A quick clarification on something I said the other day to a group of students in one of our quick...

I’m Speaking at the SSWUG VConference in April

Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...

Pragmatic Works is on YouTube !

I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at

There is some great...

Don’t Miss our Upcoming Webinar Series in February and March

More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...

Using MDX to work with the File System

There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...

Important SSAS Dimension Properties

When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...