TM1 Forum

Hello!

I have a model on TM1 with 40 cubes, and most of these cubes have the dimension Scenario, where I have 'Scenario 1', 'Scenario 2', etc.

Now I need to do the copy of the complete model from Scenario 01 to Scenario 02 on cubes where I have the dimension Scenario.

Do you know if there is a TI process that is possible to do that do all cubes from the model?

Thanks in advance,

JR

Jorge,

If you go to this thread: http://www.tm1forum.com/viewtopic.php?f=21&t=4901 Martin has built a process in which you can find every cube in which the scenario dimension has been used. I also believe that bedrock contains a process to generically copy data with cubes of different sizes. If it doesn't I'm sure you'll be able to adapt one that's close. (It's been a while since I've looked at bedrock.)

Combining the 2 will be the quickest way to achieve what you're looking. As you may of guessed there's nothing out of the box (that I know of) that will do what you're looking for,

Jim.

Jorge Rachid wrote:I have a model on TM1 with 40 cubes, and most of these cubes have the dimension Scenario, where I have 'Scenario 1', 'Scenario 2', etc.

Now I need to do the copy of the complete model from Scenario 01 to Scenario 02 on cubes where I have the dimension Scenario.

Do you know if there is a TI process that is possible to do that do all cubes from the model?

The recipe should be pretty simple:
- while loop on }Cubes dimension
- for each cube a tabdim while loop to find the scenario dimension
- for each cube where scenario is found call Bedrock.Cube.Data.Copy

Less than 20 minutes work if you know what you're doing.

Ok, I will try that.

Thank you all!

JR