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

Multiple Bridge tables to a single fact?

2 posters

Go down

Multiple Bridge tables to a single fact? Empty Multiple Bridge tables to a single fact?

Post  Bumblebee Sun Aug 23, 2015 9:32 pm

Hi
We have had a design option proposed that has a single fact table, which has 2 bridge tables to multivalued dimensions.

Given that a bridge table changes the grain of the fact table to the level of the bridged multivalued dimension, I would not have thought it was possible to then join a second multivalued dimension to the fact using its own bridge table. Thoughts on this please?

Bumblebee

Posts : 3
Join date : 2015-03-04

Back to top Go down

Multiple Bridge tables to a single fact? Empty Re: Multiple Bridge tables to a single fact?

Post  ngalemmo Sun Aug 23, 2015 9:43 pm

Yes, you can combine multiple bridges in a query. However, unrestricted, you create a cartesian product. This may be significant depending on the cardinality of these relationships. You also need to include an allocation factor for each relationship to distribute measures to the new grain. Multiplying cumulative factors (from the multiple bridges, and provided it is stored as a value between 0..1) to properly allocate the cartesian product before summarization.

If you do allocation, be ready to support multiple allocation factors for different purposes. Allocations tend to be a hot topic among different departments.
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