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

contract multi-value or multi-fact or ...

2 posters

Go down

contract multi-value or multi-fact or ... Empty contract multi-value or multi-fact or ...

Post  elementary Wed Feb 06, 2013 12:01 pm

I want to track contracts on a monthly basis. A contract is defined per customer.
- A contract can contain 1 or more modules.
- A contract can contain 1 or more interfaces.
- A contract can contain 1 or more suppliers.
- A contract can contain 1 or more ....

I want to know on a re-current basis which modules a certain customer has
I want to know the customer which have a certain module and have a certain interface currently
I want to know the customer which have a certain module and have a certain interface in a certain month
...

Any idea on how to model this? My initial approach is to have 1 fact for customer-month-modules, 1 fact for customer-month-interfaces, etc.

Any help appreciated!

cheers!

elementary

Posts : 4
Join date : 2012-05-18

Back to top Go down

contract multi-value or multi-fact or ... Empty Re: contract multi-value or multi-fact or ...

Post  BoxesAndLines Wed Feb 06, 2013 8:04 pm

Things you count or sum are facts. Things you filter by are dimensions.

I want to know the customer (filter) which have a certain module (fact) and have a certain interface (dimension) currently. Or it just may be a factless fact table where all three of these things are dimensions and their intersection is the fact.
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