Timespan Transaction Fact
4 posters
Page 1 of 1
Timespan Transaction Fact
I have customers who spend time with our business, staying in different rooms for different periods of time and in different locations.
I want to track how long customers spend with us at a time, and which rooms at which locations they stayed in (and how long they spent in each room).
I was thinking of using a Timespan transaction fact, but am unsure if I need a record for any period of time the customer is not staying with us?
I want to track how long customers spend with us at a time, and which rooms at which locations they stayed in (and how long they spent in each room).
I was thinking of using a Timespan transaction fact, but am unsure if I need a record for any period of time the customer is not staying with us?
Noslaner- Posts : 1
Join date : 2015-09-03
Re: Timespan Transaction Fact
Below would be the dimensions:
1. Customer
2. Date
3. Room (rolls up to location)
Fact table granularity would be all the above dimensions along with start and end time..
1. Customer
2. Date
3. Room (rolls up to location)
Fact table granularity would be all the above dimensions along with start and end time..
manickam- Posts : 27
Join date : 2013-04-26
Timespan Transaction Fact
Join customer dim to the Fact table to find those customer who stayed UNION that result and do outer join on customer dim to Fact table to find those customer who did not stay.
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago
Re: Timespan Transaction Fact
Do a left outer join having customer dim on the left hand side.
manickam- Posts : 27
Join date : 2013-04-26
Re: Timespan Transaction Fact
If you need to find gaps in the stays, use either a LEAD (or LAG) windowing function to look at two stays. The time between the check out of one stay and check in of the next would be the 'not staying' time.
Similar topics
» Transaction fact without obvious transaction type field
» Timespan accumulating fact table
» Subscription Services - Timespan Fact Table
» Transaction fact table and Transaction line item fact table
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Timespan accumulating fact table
» Subscription Services - Timespan Fact Table
» Transaction fact table and Transaction line item fact table
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum