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

Fact with more than one relation to the same dimension in the same role

2 posters

Go down

Fact with more than one relation to the same dimension in the same role Empty Fact with more than one relation to the same dimension in the same role

Post  gbaren Tue Apr 15, 2014 4:19 pm

I'm having trouble getting my wits around this. I have a Market dimension and a particular fact, the way the OLTP source is designed, can be in more than one Market, say US and AL. But it is not necessarily a hierarchy. I wouldn't want to use roles and have a Market1Key and Market2Key and I don't think I want a US/AL market key. Is there a standard solution for something like this?

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

http://equalsql.wordpress.com

Back to top Go down

Fact with more than one relation to the same dimension in the same role Empty Re: Fact with more than one relation to the same dimension in the same role

Post  ngalemmo Tue Apr 15, 2014 9:20 pm

A bridge table is the standard solution if the number of references is not known or have no 'status' (for lack of a better word).

The 1, 2 thing doesn't work well even if there are a fixed number of references as they are difficult to use together. It only works if there is a clear precedence, an use of multiple references is not common.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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