TM1 Forum

I want implement Ctr+H functionality through TI process on worksheets.

How it helps:

If we want to move reports from one environment to other , we have to change server name from all subnm functions.

it takes hell out of time to do indivually if ur report is huge with many active form.

I tried to put cell reference(server Name) in all Subnm functions,so that i need to changes at only one place when u move reports across d environments,but Subnm never takes cell value in the place of server name.

Thats the reason i am trying for above alternative solution.

If you have any way ,kindly share.

Thanks in advance.

Regards,
Nata

Subnm will take a reference to a cell (e.g. =subnm(a1 & ":Scenario", "", "Actual")), however doing so will prevent the user being able to double click the subnm to change the element within TM1.

What I tend to do is to reference a cell for all of the TM1 formulae except subnms, which means I only have to change at most a dozen references, rather than potentially thousands.

Martin

nataraja.pl@tcs.com wrote: I tried to put cell reference(server Name) in all Subnm functions,so that i need to changes at only one place when u move reports across d environments,but Subnm never takes cell value in the place of server name.

Which version of 9.4 are you on? If it's 9.4.1 FP1 or higher, you should now be able to do that. See this thread.

Hi Alan/Martin,

Thanks a lot,i am using 9.4.1 version.

my syntax was incorrect ,thats y i was not able to do that.

I recorrected as martin mentioned,issue got resolved.

Thanks a lot martin & Alan.

Regards,
Nata