数据仓库设计 - 如何设计与时间相关的度量，例如过去7天等

I'm working rearchitecting a reporting/data warehouse type database. We currently have a table that has data at the hotel grain (i.e. HotelID plus lots of measures, including measures like Last7DaysGross, Last28DaysXXX, etc).I'm working rearchitecting a reporting/data war