I have a request to show a title turnaround duration.  Which would be defined as the duration from the initial transaction in a branch to the mail date to the customer.

Currently, I have a fact_transaction table with a dimension key to a transaction type table that can give me # of transactions by Titles.  I could add a title_complete_date_uid in my fact table and a calcuation for title duration in this fact table.  This issue I would have would be with my current employee_uid dimension.  Employee_uid is the employee responsible for the transaction.  I would need to add title_employee_uid because the employee responsible for processing the title is different.  Title transaction account for about 90% of all the transactions.

Or, do I create a fact_titles table that shows the "turnaround duration" and associated dimensions that are pretty redundant comparing back to the original fact_transaction table?

In the source database each transaction does go through a status change, however I'm only bringing in completed transactions.  Most transactions have a begin date and an end date on the same day.  Example: a drivers license renewal transaction starts and ends on the same day.  The customer walks out of a branch with a new license in hand.  When a title amendment transaction takes place there is a begin and end date on the transaction just like the the license renewal but the customer doesn't walk out of the branch with a title in hand.  There is processing that takes place at the corporate center before the title is delivered.

Can I just add this delivery date to the fact table and do my title turnaround duration here?