Measures in Dimension table ?

View previous topic View next topic Go down

Measures in Dimension table ?

Post  VTK on 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.

VTK

Posts : 50
Join date : 2011-07-15

View user profile

Back to top Go down

Re: Measures in Dimension table ?

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

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