Measures in Dimension table ?
2 posters
Page 1 of 1
Measures in Dimension table ?
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.
Appreciate your time.
VTK- Posts : 50
Join date : 2011-07-15
Re: Measures in Dimension table ?
Do you sum it or count it? If so, it's a fact otherwise you can put it in a dimension.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Measures as special dimension table
» How to create fact table with measures derived from comparing two fact table rows
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Updating Measures In Fact Table
» Fact table's changing measures
» How to create fact table with measures derived from comparing two fact table rows
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Updating Measures In Fact Table
» Fact table's changing measures
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum