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

tenants and children versus facts

2 posters

Go down

tenants and children versus facts Empty tenants and children versus facts

Post  elementary Wed May 23, 2012 9:05 am

I have a tenant dimension which can be related to various facts (maintenance on houses/apartments, payments, hire requests ...)
A tenant can have numerous attributes which could be of importance to 1 or more facts.

Now, each tenant also can have children, which upon their turn can have different attributes (age, income, job, gender ... and lots more).
What we want to achieve is to be able to use the childrens' attributes versus a(ny) fact table.

Important remark: a fact table is related to a tenant. A tenant is related to 0,1 or more children. None of the facts is related to children directly.

example:
- give me the payments for tenants which have at least 2 children, of which at least 1 child is older than 18 years.
- give me the number maintenances done in period x for tenants with a mutual income of more than 10.000 dollar and where at least 1 child is x% handicapped
- ...

Any thought on how to model this?

elementary

Posts : 4
Join date : 2012-05-18

Back to top Go down

tenants and children versus facts Empty Re: tenants and children versus facts

Post  BoxesAndLines Wed May 23, 2012 3:37 pm

A bridge table to a Tenant dimension should work. Put the role (child, Parent) in the bridge table as well. All tenants, children and parents go into the tenant dimension.
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