Tools to copy and rename TM1 object

Post Reply
kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Tools to copy and rename TM1 object

Post by kenship » Mon Feb 05, 2018 7:20 pm

Hi,

I've been building a budget model and the objects are named with prefix ISOBMV1 with V1 being version number. I'm now on V4 and this is probably the last version before production.

I'm close to a hundred objects (cube, dimension, rule and TI) I need to find some tools that allow me to rename these objects, rules and TI quickly.

I know bedrock has some TI that I can use for cube and dimension, but is there other tool that can find and replace in rule and TI?

Thank you.

Kenneth

Wim Gielis
MVP
Posts: 1579
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Tools to copy and rename TM1 object

Post by Wim Gielis » Mon Feb 05, 2018 7:48 pm

Hello Kenneth,

Tools like Notepad++ can help you, but in the end it will always be a semi-automatic task.
Good testing will be very much needed because skipping 1 or more references is not uncommon.
Or cases (though unlikely) where object names are derived as variables rather than hardcoded, don't forget them !
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tools to copy and rename TM1 object

Post by kenship » Mon Feb 05, 2018 8:08 pm

I'm hoping there will be 3rd party tools that scan all the TM1 objects for find and replace so that I don't need Notepad++ in the end.

I use different color and bold and underline in some of my rules and for some reason Notepad++ doesn't copy those format correctly.

Thanks.

Kenneth
Wim Gielis wrote:
Mon Feb 05, 2018 7:48 pm
Hello Kenneth,

Tools like Notepad++ can help you, but in the end it will always be a semi-automatic task.
Good testing will be very much needed because skipping 1 or more references is not uncommon.
Or cases (though unlikely) where object names are derived as variables rather than hardcoded, don't forget them !

User avatar
tomok
MVP
Posts: 2378
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Tools to copy and rename TM1 object

Post by tomok » Tue Feb 06, 2018 12:06 pm

There is no such tool, at least that I am aware of. This is why what you did, naming the TM1 objects with the DEV versus PROD construct, a really bad idea in TM1. If you need to segregate development from production it is best to do it on different services so you can have your objects use the same name. Sorry.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

kangkc
Community Contributor
Posts: 176
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: Tools to copy and rename TM1 object

Post by kangkc » Tue Feb 06, 2018 1:05 pm

You can try GrepWin :
https://sourceforge.net/projects/grepwin/

However, it's not that straight forward with rule as you will need to deal with both .rux and the corresponding .blb.
Should works fine with .pro

John Hammond
Community Contributor
Posts: 258
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe
Version: 10.2
Excel Version: 2010
Location: City of London

Re: Tools to copy and rename TM1 object

Post by John Hammond » Tue Feb 06, 2018 3:57 pm

Text Substitution works fine on TM1 objects provided the original and replacement texts are the same length. Don't attempt otherwise or you will just bust your instance and even with the above proviso always have a backup of your original instance.

kenship
Posts: 81
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tools to copy and rename TM1 object

Post by kenship » Tue Feb 06, 2018 9:35 pm

Thank you all. Will try different solutions as suggested.

Post Reply