Time and Expenses -- sql server data warehouse

Scott
11/29/2005 3:43:04 PM

We're building a data warehouse to report on consulting revenue
(HoursWorked*BillRate) and Expenses. We need to do things like determine
Gross Profit (GP) based on a consultant's loaded rate and by subtracting the
non-reimbursable expenses and costs from the revenue. Should this be one
fact table for both Hours and Expenses or two fact tables, one for Hours and
one for Expenses? Is there a best practice? They seem like different data
to me. I'm a relational database administrator learning the ropes of
dimensional modeling and data warehousing. Using SQL Server 2005 SSIS, SSAS

MC
11/30/2005 12:00:00 AM

Probably one fact table. It depends on how do you want to implement
Expenses. They dont have Hours attached to them so you would have to put 0
as a value for Hours. If 0 hours is not a problem, dont see why you wouldnt
go with one fact.

If, however, there are different attributes attached to those two objects
(lets call them Payment and Expenses) then you should probably go with two
facts.

MC

[quoted text, click to view]

sql server data warehouse : Time and Expenses