Zap function

socal_tm1user · Post by **socal_tm1user** » Wed Oct 31, 2012 6:42 pm

I just started at a company on v10.1. I was a super user of v9.5.2 and there was a function called Zap that would make all of the TM1 formulas disappear however it would keep the regular excel formulas in tact. Which is very useful when you send spreadsheets to non TM1 users. I used it multiple times a day. On v10.1 that funcation does not appear to exist? Can anyone confirm that? I cannot believe IBM would get rid of this!

Thanks

Paul Segal · Post by **Paul Segal** » Wed Oct 31, 2012 7:05 pm

socal_tm1user wrote:I just started at a company on v10.1. I was a super user of v9.5.2 and there was a function called Zap that would make all of the TM1 formulas disappear however it would keep the regular excel formulas in tact. Which is very useful when you send spreadsheets to non TM1 users. I used it multiple times a day. On v10.1 that funcation does not appear to exist? Can anyone confirm that? I cannot believe IBM would get rid of this!

Thanks

I don't believe that Zap was ever a native part of TM1, but http://www.tm1forum.com/viewtopic.php?f=21&t=2515 will do what you're looking for.

dymoy · Post by **dymoy** » Wed Oct 31, 2012 7:51 pm

I believe that Zap is a function out of the Revelwood Application Manager and is not native to TM1.

Alan Kirk · Post by **Alan Kirk** » Wed Oct 31, 2012 7:56 pm

dymoy wrote:I believe that Zap is a function out of the Revelwood Application Manager and is not native to TM1.

Actually it's a function out of the TM1 Tools add-in that Paul pointed the OP to.

I should know, I wrote the thing. (There are three alternative methods for removing formulas in TM1 Tools but Zap Formulas refers specifically to my one.)

I cannot believe IBM would get rid of this!

And I cannot believe that IBM hasn't included most of the functionality of TM1 Tools in the core product.

Oh wait, yes I can, sadly.

tomok · Post by **tomok** » Thu Nov 01, 2012 1:55 am

It would be pretty easy to roll your own zapping with VBA. Just cycle through the collection ActiveSheet.UsedRange, looking for DBR and SUBNM, and when found do a Cell.Copy and Cell.PasteSpecial. You can pretty it up with stopping screen updates and the like but you get the picture.

Martin Ryan · Post by **Martin Ryan** » Thu Nov 01, 2012 2:38 am

Yes, a simple one is basic, but when you want frills like finding nested TM1 formula and doing multiple sheets then it's just simpler to use the freely available TM1 tools. You also get the fabulous tracer and various other tools chucked in all for the low low price of $0. And a money back guarantee. [/sales mode]

Alan Kirk · Post by **Alan Kirk** » Thu Nov 01, 2012 3:05 am

Martin Ryan wrote:Yes, a simple one is basic, but when you want frills like finding nested TM1 formula and doing multiple sheets then it's just simpler to use the freely available TM1 tools. You also get the fabulous tracer and various other tools chucked in all for the low low price of $0. And a money back guarantee. [/sales mode]

Not to mention all of the non-common formulas like DimIx or View Or Elcomp. Or the possibility of some keywords being inside strings. Or dealing with with Excel's desire to "help" you by auto-converting data types as they move from an element to a cell content. Or...

I was going to make an observation about "wheel, reinvention of", but I think you've covered it.

TM1 Forum

Zap function

Zap function

Re: Zap function

Re: Zap function

Re: Zap function

Re: Zap function

Re: Zap function

Re: Zap function