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

Measures in Dimension table ?

2 posters

Go down

Measures in Dimension table ? Empty Measures in Dimension table ?

Post  VTK Wed Jan 07, 2015 11:47 am

I have heard that measures (amount fields) does not belong in the dimension tables but is that a rule of thumb ? Are there exceptions to this rule ? How do we decide if a measure belongs to Dimension or Fact table ? Lets say I have a dimension (campaign) which has some amount fields(like margin amounts) attached to it at the dimension grain and they rarely change. These fields are decided upfront. Now what would be the drawbacks of keeping them in the dimension table? If it does not belong in dimension do we need to create a fact table just to analyze these ? You can't slice and dice these anyother way I think.

Appreciate your time.


Posts : 50
Join date : 2011-07-15

Back to top Go down

Measures in Dimension table ? Empty Re: Measures in Dimension table ?

Post  BoxesAndLines Thu Jan 08, 2015 1:28 pm

Do you sum it or count it? If so, it's a fact otherwise you can put it in a dimension.

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

Back to top Go down

Back to top

- Similar topics

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