星型模式中我的时间维度表的属性(Attributes of my Time dimension table in star schema)

 我正在使用星型模式建模构建DW。 我将它用于pentaho的BI项目。 我当然会有时间维度表。 我将用不同的粒度（日，周，月，或许其他）分析我的事实表 
 
 我应该在维度表中为每个粒度添加一个属性（所以我有一天属性，一个月属性，一年属性......）或者我应该只写日期然后用这个日期计算所有内容（得到日期的月份，日期的年份......）？ 
 
 非常感谢你的帮助 

I'm building a DW with a star schema modeling. I'll use it for a BI project with pentaho. I'll have of course a time dimension table. I'll analyze my fact table with differents granularity (day, week, month year, perhaps other)
 
Should I put one attribute for each of those granularity in my dimension table (so I have one day attribute, one month attribute, one year attribute ...) or should I just write the date and then calculate everything with this date (get the month of the date, the year of the date ...)?
 
thks a lot for your help

原文：https://stackoverflow.com/questions/15202389