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

Contract - How to model

2 posters

Go down

Contract - How to model Empty Contract - How to model

Post  fluid Sun Jul 15, 2012 4:25 am

Hi,

I am thinking about options to model a contract for an energy company (electricity and gas supply).
A contract has start and an end date (typically end date is blank or filled in with 9999 if the contract is active).
The 'product', customer,premise,installation etc are then attached

Now would this be typically modelled as a fact (likely fact-less fact table)?
How would changes to the contract typically modelled eg: if the customer changed the contract rate they were on.
Would the contract be a dimension as well as a fact for changes?

The closest example I could find was the insurance example in the "data warehouse toolkit".
(but didn't quite give me what I needed).

Any help or advice would be greatly appreciated.








fluid

Posts : 1
Join date : 2012-07-15

Back to top Go down

Contract - How to model Empty Re: Contract - How to model

Post  BoxesAndLines Mon Jul 16, 2012 2:02 pm

I think an applicable example that Kimball has written about is product price. The attribute could live in a dimension or fact. In your case, I would put rate in the fact table.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

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