Here’s something fun to show them:
- Open SQL Server Management Studio
- Connect to the AdventureWorks cube
- Run the following query:
select [Measures].[Internet Sales Amount]
on 0,
[Geography].[Geography].[State-Province].[England].children
on 1
from [Adventure Works] - Scroll down the result set and point out that according to AdventureWorks, Scotland is a city in England.
Chris, thank you for catching this mistake. We\’ll be sure to get it fixed for SP1. -rob
I am Scottish, and I find this very offensive.