TM1 Forum

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

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 !

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 !

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.

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

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.

Thank you all. Will try different solutions as suggested.