How to Handle a value in a fact table that can have multiple dimension values
3 posters
Page 1 of 1
How to Handle a value in a fact table that can have multiple dimension values
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
Thanks in advance for the help.
Jean
jeancarlos- Posts : 2
Join date : 2009-03-27
Re: How to Handle a value in a fact table that can have multiple dimension values
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).
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
Re: How to Handle a value in a fact table that can have multiple dimension values
Or add a bridge table between your fact and dimension table.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
What is a bridge table can you explain?
BoxesAndLines wrote:Or add a bridge table between your fact and dimension table.
jeancarlos- Posts : 2
Join date : 2009-03-27
Re: How to Handle a value in a fact table that can have multiple dimension values
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
http://www.kimballgroup.com/html/08dt/KU105Snowflakes_Outriggers_Bridges.pdf
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Dummy dimension values in the fact table
» 1 Dimension used multiple times in 1 fact table?
» Source Values and Conformed Values in the Dimension table
» From Enterprise Models to Dimensional Models. Can a single Dimension table be referenced multiple times in a fact table?
» Lab Result values in Fact Table has int and non int values
» 1 Dimension used multiple times in 1 fact table?
» Source Values and Conformed Values in the Dimension table
» From Enterprise Models to Dimensional Models. Can a single Dimension table be referenced multiple times in a fact table?
» Lab Result values in Fact Table has int and non int values
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum