How to Handle a value in a fact table that can have multiple dimension values

View previous topic View next topic Go down

How to Handle a value in a fact table that can have multiple dimension values

Post  jeancarlos on Fri Mar 27, 2009 9:49 am

Hi everybody my name is jean carlos im new in this forum and new in the world of business intelligence, im working on my first BI project and i want to know how to handle that In the fact table i have there are some records that apply to have more than one value in a dimension table of the model and i need to reflect that for example that a customer have 3 plans in the plan dimension, so i need to know how to count that in every plan.

Thanks in advance for the help.

Jean

jeancarlos

Posts : 2
Join date : 2009-03-27

View user profile

Back to top Go down

Re: How to Handle a value in a fact table that can have multiple dimension values

Post  Michael_K on Fri Mar 27, 2009 10:25 am

1 row in the fact table per plan.

You need to define your grain to minimally be Customer, Plan (and probably Date of some kind).

Michael_K

Posts : 7
Join date : 2009-03-14

View user profile

Back to top Go down

Re: How to Handle a value in a fact table that can have multiple dimension values

Post  BoxesAndLines on Fri Mar 27, 2009 11:57 am

Or add a bridge table between your fact and dimension table.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

What is a bridge table can you explain?

Post  jeancarlos on Fri Mar 27, 2009 11:59 am

BoxesAndLines wrote:Or add a bridge table between your fact and dimension table.

jeancarlos

Posts : 2
Join date : 2009-03-27

View user profile

Back to top Go down

Re: How to Handle a value in a fact table that can have multiple dimension values

Post  BoxesAndLines on Fri Mar 27, 2009 1:54 pm

Here's a link that describes bridge tables. It's essentially an associative entity in normal modeling nomenclature.
http://www.kimballgroup.com/html/08dt/KU105Snowflakes_Outriggers_Bridges.pdf
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: How to Handle a value in a fact table that can have multiple dimension values

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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