Managing Granularity

[ClevelandSteve]

I apologize if this is not the correct forum. It seemed to be the closest match I could find.

I have a data warehouse that stores sales data sent to us by our customers. Managing the time/date dimension has become a challenge and I’m looking for some advice. Some customers will send daily sales, most send sales by week, and two send sales by month. How do I store these different grains in the data warehouse so that products can be analyzed across customers without losing the lowest grain per customer if it is ever needed? Do I use different fact tables for the different grains? Multiple time/date dimension tables? Thanks.

 

[MDXer]

forum353

Would probably be a better forum.

 

[ClevelandSteve]

Thanks, I wonder why that forum didn’t come up in my search.