Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Customer Both as Fact and Dimension

2 posters

Go down

Customer Both as Fact and Dimension Empty Customer Both as Fact and Dimension

Post  ohmycamote Tue Jul 05, 2011 2:41 pm

In our business, our customers are subscribers so they can be active or inactive status.
Part of the reporting requirements is to show how many subscribers there are based on when they joined.

So is it best to do this via a Factless Fact table?
E.g.,

FACTCUSTOMERS
- FACTCUSTKEY (PK)
- CUSTKEY (FK)
- JOINDATE_KEY (FK)

DIMCUSTOMERS
- CUSTKEY (PK)
- RECORD_STATUS (SCD)
- STARTDT (SCD)
- ENDDT (SCD)

Is this the right way to do this?

Thanks

ohmycamote

Posts : 14
Join date : 2011-07-05

Back to top Go down

Customer Both as Fact and Dimension Empty Re: Customer Both as Fact and Dimension

Post  ngalemmo Tue Jul 05, 2011 3:43 pm

Customer is a dimension, never a fact. The fact in question is subscription, not customer. You would have a subscription fact table of which customer is one of the dimensions.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum