Contract Terms dimension per ETL toolkit - populating the dimension

View previous topic View next topic Go down

Contract Terms dimension per ETL toolkit - populating the dimension

Post  rpccpa on Fri Jun 06, 2014 9:07 am

In the ETL Toolkit, for Procurement- a contract terms dimension is mentioned...
Contrat Terms Dimension..

Contract Terms Key (PK)
Contract Terms Description
Contract Terms Type

The contract terms dimension contains one row for each generalized set of negotiated
terms, similar to the promotion dimension...

In our case, we have a bonus flag on a contract that has a value of 0 or 1

I assume we would create 2 rows one for Bonus + 0 state and one for Bonus +1 state

In another case - similar we have a third party voucher flag 0 or 1 state

In another case we have a Min_Config amount of X >>> so this would be one row with amount...

Does this sound like the proper approach to populate the dimension?

rpccpa

Posts : 2
Join date : 2014-06-06

View user profile

Back to top Go down

Re: Contract Terms dimension per ETL toolkit - populating the dimension

Post  umutiscan on Fri Jun 06, 2014 11:12 am

I think contract terms key is not used to give details of contracts.

That may be something used to give more detail about a transaction, which is processed as a result of a term written in the contract.

transaction type = Payment transaction
contract terms description = Late delivery penalty
transaction dollar amount = 15.000

or

transaction type = Payment transaction
contract terms description = Early delivery bonus
transaction dollar amount = 15.000

umutiscan

Posts : 51
Join date : 2010-11-26
Age : 36
Location : Istanbul, Turkey

View user profile

Back to top Go down

Re: Contract Terms dimension per ETL toolkit - populating the dimension

Post  BoxesAndLines on Tue Jun 10, 2014 7:47 am

It sounds like Kimball is describing a junk dimension to store common contract terms. If your contract terms are not very common, then this would not be a good design solution. You might need to refine your data into smaller dimensions to get value from a junk dimension approach.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Contract Terms dimension per ETL toolkit - populating the dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum