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
Tools to copy and rename TM1 object
-
- MVP
- Posts: 3117
- 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
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 !
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
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
-
- 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
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
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 !
-
- MVP
- Posts: 2832
- 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
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.
-
- 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
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
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
-
- 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
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.
-
- 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
Thank you all. Will try different solutions as suggested.