Clone complete model on same server

Post Reply
Perf
Posts: 5
Joined: Thu Sep 27, 2012 2:02 pm
OLAP Product: TM1
Version: 10.2.2 FP2
Excel Version: 2013

Clone complete model on same server

Post by Perf »

Hi,

We're having a model with several cubes, links and processes on TM1 10.2.2 FP2.

Model was made using Performance Modeler (some calculations are therefore embedded into the cube rules).

Now we would like to clone this model on the same TM1 server (or temporarily to another TM1 server). This means we would like to have the exact same model but having all objects (dimensions, cubes, links, processes, rules, etc) with new names (this is because large parts of the model can be reused and because of security requirements towards external clients). So after this we would ideally have a clone of the existing model but with no interaction between these.

Is there any way to accomplish this? Or if not what would be the best/simplest way to clone the model?

Thank you in advance. :)
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Clone complete model on same server

Post by Wim Gielis »

Hello,

An exact clone is not so difficult. Copy the data directory and related directories, create a service for the TM1 model, and change the TM1 server name, port numbers, ...
You can use Cognos Configuration for some of these tasks.

Note that changing the TM1 server name could mean that you have to go through the websheets to make the formulas point to the new name.

Once you also need to change names of cubes and dimensions and processes, you will definitely have much more work.
You will in fact need to go through the entire model and set it up again (obviously with copy/paste and such but still a lot of work potentially, not to forget testing... ).
Some routines will help you, like duplicating a dimension (including attributes and subsets and so on), or recreating subsets/views, or exporting data from cubes to text files and reimporting again, ... Bedrock can help here, or write your own generic processes/tools.

I know that you can localize a TM1 lodel (cube names and dimension names), starting with TM1 10.x.x (unsure about the starting version),
so if that is a quicker way of doing things you could look into that as well.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Perf
Posts: 5
Joined: Thu Sep 27, 2012 2:02 pm
OLAP Product: TM1
Version: 10.2.2 FP2
Excel Version: 2013

Re: Clone complete model on same server

Post by Perf »

Hi Wim,

Thank you for your reply.

As we want to clone the model to the same server it seems you are confirming that we more or less have to start from scratch.

The only thing I see we get "for free" is to be able to save dimensions with new names, but all other objects need to be recreated.
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Clone complete model on same server

Post by Wim Gielis »

Hi,

Yes that's correct. You can indeed "Save As" a dimension with a different name but don't forget to go through all rules and processes...

Depending on how big the model is, this exercise of cloning the model can take up a lot of effort. Be warned :-)
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply