contract multi-value or multi-fact or ...
2 posters
Page 1 of 1
contract multi-value or multi-fact or ...
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!
- 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
Re: contract multi-value or multi-fact or ...
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.
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- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» multi to multi relationship with multiple business view.
» Multi-event Fact Table?
» Multi level grainulity in Fact table
» Multi-currency metrics on fact table
» Multi-valued attribute that has fact type data
» Multi-event Fact Table?
» Multi level grainulity in Fact table
» Multi-currency metrics on fact table
» Multi-valued attribute that has fact type data
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum