# How to model a contract

2 posters

Page

**1**of**1**## How to model a contract

Hi,

I want to star model a contract between an employer and a employee. The contract has a begin and a enddate. I was thinking about to model this as fact. I am also looking into the HRM solutions of Kimball books. This is another kind of fact than a transaction fact with a timestamp of happening. Currently not quite convinced of this solution. Hope that someone could give some clues.

Gr,

Hennie

I want to star model a contract between an employer and a employee. The contract has a begin and a enddate. I was thinking about to model this as fact. I am also looking into the HRM solutions of Kimball books. This is another kind of fact than a transaction fact with a timestamp of happening. Currently not quite convinced of this solution. Hope that someone could give some clues.

Gr,

Hennie

**hennie7863**- Posts : 31

Join date : 2009-10-19

## Re: How to model a contract

Hi Hennie

You might want to consider a periodic-snapshot fact. If an employee has a contract for 6 months, you'd load 6 records into the fact (one for each month) if you are looking at data month-to-month.

FACT:

Period_______EmployeeKey_______ContractKey________SomeMeasure

201201______1_________________1_________________x

201202______1_________________1_________________x

201203______1_________________1_________________x

201204______1_________________1_________________x

201205______1_________________1_________________x

201206______1_________________1_________________x

Perhaps provide more context around what you're trying to model, including what you're measuring.

You might want to consider a periodic-snapshot fact. If an employee has a contract for 6 months, you'd load 6 records into the fact (one for each month) if you are looking at data month-to-month.

FACT:

Period_______EmployeeKey_______ContractKey________SomeMeasure

201201______1_________________1_________________x

201202______1_________________1_________________x

201203______1_________________1_________________x

201204______1_________________1_________________x

201205______1_________________1_________________x

201206______1_________________1_________________x

Perhaps provide more context around what you're trying to model, including what you're measuring.

**min.emerg**- Posts : 39

Join date : 2011-02-25

## Re: How to model a contract

thnx for your reply. Currently looking in the books of kimball and there is also the same solution suggested as you do. The problem is that I do not have a business question. Currently working at a group of analysts and they want to analyze the data. There are some basic questions. So I wanted to start small and take some cyclic steps to improve the data (alla prototyping).

**hennie7863**- Posts : 31

Join date : 2009-10-19

## Re: How to model a contract

Ken Collier has written a good book titled Agile Analytics that's specific to business intelligence. The agile approach to analysis that he promotes may be of use to you.

http://www.amazon.com/Agile-Analytics-Value-Driven-Intelligence-Warehousing/dp/032150481X

http://www.amazon.com/Agile-Analytics-Value-Driven-Intelligence-Warehousing/dp/032150481X

**min.emerg**- Posts : 39

Join date : 2011-02-25

Similar topics

» Contract - How to model

» Contract Terms dimension per ETL toolkit - populating the dimension

» Rule based algorithm to convert an ER model to a dimensional model

» Complexities of Relational Model and Simplicities of Dimensional Model

» Why we use Dimensional Model over De-normalized relational Model ?

» Contract Terms dimension per ETL toolkit - populating the dimension

» Rule based algorithm to convert an ER model to a dimensional model

» Complexities of Relational Model and Simplicities of Dimensional Model

» Why we use Dimensional Model over De-normalized relational Model ?

Page

**1**of**1****Permissions in this forum:**

**cannot**reply to topics in this forum