Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Do you know anyone Scottish?

with 2 comments

Here’s something fun to show them:
  1. Open SQL Server Management Studio
  2. Connect to the AdventureWorks cube
  3. Run the following query:
    select [Measures].[Internet Sales Amount]
    on 0,
    [Geography].[Geography].[State-Province].[England].children
    on 1
    from [Adventure Works]
  4. Scroll down the result set and point out that according to AdventureWorks, Scotland is a city in England.

 

Written by Chris Webb

November 24, 2005 at 5:13 pm

Posted in Off-topic

2 Responses

Subscribe to comments with RSS.

  1. Chris, thank you for catching this mistake. We\’ll be sure to get it fixed for SP1. -rob

    Rob

    November 28, 2005 at 10:53 pm

  2. I am Scottish, and I find this very offensive.

    Unknown

    December 1, 2005 at 2:51 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,301 other followers

%d bloggers like this: