copy dimension from one to another server

[mw20000]

Hi, I've created a TM1 TI standard process to copy a dimension via odbo to another server. As you can the in the attachements (green original dimension, red copied dimension) the dimension copy is done, but the leafs have an additional umderscore and a counted number. This is not what I need, does anybody knows why this is happening?

copied dim on target server

copied.png (8.51 KiB) Viewed 4353 times

original dimension from source server

original.png (8.02 KiB) Viewed 4353 times

[tomok]

Please read the request for assistance guidelines then come back with a reasonable request.

[Duncan P]

What you are seeing is the result of your source dimension leaf items each having multiple parents. The ODBO import process treats all leaf items with different parents as unique and creates unique items in the target dimension to represent them.

I have not yet found a way to prevent it from doing this. If you need to transfer a dimension with multiple parents per item I would choose a different method, such as by text file.

[qml]

Duncan is right on the money, that's how it works with an ODBO data source and there seems to be no way of changing it.

The suggestion to use a text file export instead is the obvious one. Another option which you can try if you're slightly more adventurous is to add a bit of post-processing to your TI logic. This would basically be a separate TI process that looks for all the elements with _number suffixes and replaces them in the hierarchy with the correct single N element. This would have to be done in a few logical steps (find the duplicates, create the single replacement element, add it under all the correct parents, delete the duplicated elements), but it seems quite doable in principle, provided that your naming conventions allow for easy and reliable distingushing of the elements that were duplicated.

[Harvey]

If you do not need to achieve this via TI, there are various methods to copy a dimension.

My favorite would of course be the Flow Model Packager, but you could also try another free tool, such as Ricky's TM1 Simple Replicate.