asked
Dimensional modeling question
We have a data warehouse. We have snowflake scheme with multiple fact and dimension tables. The naming convention is: FactBudget, FactSales, DimSalesPerson, DimState, DimCalendar, DimProducts So "Fact" for all fact tables, "Dim" for all slicers. Now, some new calculations have to be made based on PeakUsageHours and NonPeakUsageHours. This new table (MonthlyHoursByTimebucket) looks like this DimCalendarTimeId TotalPeakHours TotalNonPeakHours ----------------- -------------- ----------------- 20120101 122 60 20120201 150 71 20120301 70 40 20120401 155 68 This is not a dimension table in that we are not going to use it as a slicer in any cube or report. It is not a fact table in that we are not going to report on it by itself. It is a table used for calculations. What do I prefix this new table as? - FactMonthlyHoursByTimebucket - DimMonthlyHoursByTimebucket - something else?
In fact it is a Fact Table as it contains Measures and references to Dimension even you will not provide those measures directly to end users. Those measures you will use for further calculations. So I'm for the **`FactMonthlyHoursByTimebucket`**
11 People are following this question.
