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
Copying Scenario
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
The recipe should be pretty simple: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?
- 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.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Copying Scenario
Ok, I will try that.
Thank you all!
JR
Thank you all!
JR