Copying Scenario

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Copying Scenario

Post by Jorge Rachid »

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
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Copying Scenario

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Copying Scenario

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Copying Scenario

Post by Jorge Rachid »

Ok, I will try that.

Thank you all!

JR
Post Reply