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

Contract Terms dimension per ETL toolkit - populating the dimension

Go down

Contract Terms dimension per ETL toolkit - populating the dimension Empty Contract Terms dimension per ETL toolkit - populating the dimension

Post  rpccpa Fri Jun 06, 2014 9:21 am

Contract Terms dimension per ETL toolkit - populating the dimension

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

Back to top Go down

Back to top

- Similar topics

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