Would a value such as monthly cost from source data be represented as a fact? If yes, how would a date dimension table be designed around that fact?
Asked
Active
Viewed 60 times
2
-
No, I don't think so. According to ["What is a fact table,"](http://searchdatamanagement.techtarget.com/definition/fact-table), a fact corresponds to a single event, like a sale. Monthly Cost would be either part of a rollup in a report, or part of a rollup table in an OLAP database. – Robert Harvey Jun 04 '16 at 03:36
-
Thanks Robert, in that case the dataset for monthly cost can be added as a dimension in the warehouse? The source data is like a cost schedule, so I have - ID,Product Family, Product Name, Monthly Cost – user1450259 Jun 04 '16 at 03:47
-
Possibly. It depends on how you've set up your warehouse. – Robert Harvey Jun 04 '16 at 04:51