TM1 Forum

Hello, friends.

Hope someone faced with this problem.

I need to move data between two versions (from Year Plan to Adjustment).
I have around 40-45 cubes, and they all have Versions dim.

Is there best practice to move data in all cubes from one version to another?
Can I use one TI process, but not to define all the views? (or smth like that).

The best solution will be choosing versions 'from' and 'to' and periods (month from, month to).
But I want to start with smth less difficult.

Thanks for any help!

Alex

I think you may find that you do indeed need to use TI to do this. This is an inter cube copy and I can't think of an easier or better way to do it tbh. There might be something out there that somebody has written via the API to do this. I think cube wise may have something that could help you but you would have to dip your hand in your pocket,

Jim.

Here's what I would do
- Export to Year Plan data from each cube to a csv file (right click on the cube, choose Export ascii data... or Export as text data... depending on your version)
- Create a TI process that uses the export file from the cube with the most dimensions. This TI process will be used for all your imports. You can then use the first column of the source to figure out which cube you are using. You'll need to cycle through the list of variables to figure out which one is the version dimension and change that to Adjustment. You'll also need to use tabdim to ensure that you write the correct number of arguments in your cellputn.

- You can then call that slave process multiple times from a master process that has all the names of all the exported files. You can then pass these names as a parameter and use DatasourceNameForServer to change the source of the slave process.

(You could probably do step 2 using TI too, but I think it'll take you longer to figure that out than export them all manually.)

HTH,
Martin

Thank you both for quick response!

I found some info here:
http://www.tm1forum.com/viewtopic.php?f=3&t=4140
I'll try to make this process usable for my needs.

Best regards,
Alex