tenants and children versus facts
2 posters
Page 1 of 1
tenants and children versus facts
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?
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
Re: tenants and children versus facts
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- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» snapshot facts: daily versus effective from & to
» How best to model Timesheet facts against Sales Order facts
» Multiple Facts or Single Facts and Status Table?
» In which layer to relate facts to other facts?
» Identify the facts and facts grain
» How best to model Timesheet facts against Sales Order facts
» Multiple Facts or Single Facts and Status Table?
» In which layer to relate facts to other facts?
» Identify the facts and facts grain
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|