Office Zealot

In Part I, I discussed how to set the worksheet up, now it’s time to look at some code. Building a report consists of three logical operations: determining the correct MDX that will yield the desired results, fetching the data, and displaying the data. In this post I’ll focus on the first task – determining the correct MDX. ...

The main objectives in this post are to show some screenshots that demonstrate what you can expect when you complete the exercise and to do all of the preliminary setup on the workbook. The goal of this example is to show how you can create reports in Excel that consume Analysis Services data and provide basic drill up/drill down functionality. ...