Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)

I had a great question from a customer concerning something weird happening with PowerPivot relationships.  In this example, we have two tables such as city and state.  With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA.  Even though the relationship makes sense (as per below)

relationship

the output doesn’t!

 image

To continue reading, click here.

Advertisements

0 Responses to “Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)”



  1. Leave a Comment

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




Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

Copyright

Copyright © 2010 Denny G Lee - All Rights Reserved

%d bloggers like this: