Tools to copy and rename TM1 object

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Tools to copy and rename TM1 object

Post by kenship »

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: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Tools to copy and rename TM1 object

Post by Wim Gielis »

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

IBM Champion 2024
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
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Tools to copy and rename TM1 object

Post by kenship »

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 !
tomok
MVP
Posts: 2831
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 »

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: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: Tools to copy and rename TM1 object

Post by kangkc »

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: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Tools to copy and rename TM1 object

Post by John Hammond »

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
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Re: Tools to copy and rename TM1 object

Post by kenship »

Thank you all. Will try different solutions as suggested.
Post Reply