SSRS and MDX: Detecting Missing Fields
For this example I’ll be using the Adventure Works cube running on SQL Server Analysis Services 2008 and Reporting Services 2008.
In case you don’t have the AdventureWorks databases and cubes yet, they’re available at CodePlex.
Scenario
The sales department has asked for a report that displays the number of product items sold during a selected period. As the company is active in two different markets, both the internet and reseller numbers should be shown. The figures need to be grouped by product category, with drilldown to product level through subcategory.