Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimension interpretation

3 posters

Go down

Dimension interpretation Empty Dimension interpretation

Post  olalov Thu Sep 15, 2011 5:07 am


Our business is asking for a new dimension, Region.
However, Region is interpreted differently among the business units. Region would be a collection of countries but the exact setup may differ.
A country could belong to one Region in business unit A but to another in business unit B.
Facts are only available on Region level (not country level) and facts are (so far) only local to the unit. Business unit A can measure e.g. delivery precision and unit B will measure e.g. customer satisfaction/profit/whatever...

THe business says they would benefit from using the dimension in our dashboards etc while still knowing that they interpret the dimension differently. What are the drawbacks and logical implications of this design?




Posts : 1
Join date : 2011-09-15

Back to top Go down

Dimension interpretation Empty Re: Dimension interpretation

Post  VHF Thu Sep 15, 2011 12:25 pm

It sounds like you already understand the limitations. Drilling across business units won't be possible by region.

Make sure there is no possibility for confusion or accidently comparing apples with oranges! Ensure that every region in your dimension has an enterprise-unique name. i.e. you can't let Business Unit A have a "Northwest Region" and Business Unit B also have a (different) "Northwest Region". As long as the regions are unique and users understand they won't be able to drill across, you should be OK.

To bad your fact data doesn't arrive at the more granular country level!


Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

Back to top Go down

Dimension interpretation Empty Re: Dimension interpretation

Post  KS_EDW Thu Sep 15, 2011 11:04 pm

None really, if I understand it correctly…

Region would end up similar to a date dimension having several different fiscal years, season definitions, etc., or a time dimension having different shift definitions. Correct?

So you’d have basically a three column setup that has Country, Region BU A, and Region BU B?

I agree with VHF, in that, if the users acknowledge they can’t drill across... you’ll be golden. In fact, it may even do you some favors down the road, much like storing different fiscal years in the date dimension. In many cases for us this helps users recognize that there are differences in the calendars of the facts (quarters, BOFY, EOFY, etc.).

To make sure there isn’t an interpretation error, you could always name them distinctly different in the BI (hiding the other BU’s column) or create a rule in the metadata to force an invalid query response where the facts are joined by these two dimensional columns.

Posts : 20
Join date : 2011-09-07
Age : 47
Location : Kansas

Back to top Go down

Dimension interpretation Empty Re: Dimension interpretation

Post  Sponsored content

Sponsored content

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum