question

Raj More avatar image
Raj More 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?
database-designdata-warehousedata-modelling
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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`**
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.