TI process

[Amritha]

Hi All,

Need help on the below task:

How to create TI process for the below one.

TI Logic should work for below one:

If the product dimension already has a code in the target tm1 cube and it also has a cost in the data source, it needs to replace the TM1 Cube with the new code from data source.
If the product dimension does not have a product code in the target cube, it needs to populate the data from the data source.
If the product dimension has a Product code in the target cube and does not exist in the data source, the process should ignore it and leave the value in the TM1 cube untouched.


A

[dusherwo]

Your requirement is pretty much TI's default behaviour.
Set the product dimension to 'Update', then the new elements will add in. (You may want to put them into a consolidation as otherwise they'll be hard to find/reconcile.)
If you don't clear the destination of the cube, the existing values will be replaced from the data source if matched, left untouched if unmatched.

(Did you try it out before posting?)

[Amritha]

Thanks for the immediate response.

Do i need write any code..if so can you please share it.

Thanks
A