Action Button Server Reference fails for non Author

[John Hammond]

Hi

I have a strange problem in that I am trying to use a reference to a cell instead of choosing from a list of Tm1 servers. (This is so we can use find and replace to change references when we move a server from Dev to Live instead of having to go in and manually edit the action buttons).

Reference Example

tm1_server_reference.JPG (40.52 KiB) Viewed 2844 times

This works fine until you give this to another user to run. What occurs is that you get a message - IBM Action Button Control: Process Failed.
When you check the TM1 server log there is no indication the instruction to run the TI process has been passed back to the server.

Indeed if you examine the attached image you will see that the server is assuming that you have no connection with the server and when you click on the connect... button you get this message

tm1_server_reference2.JPG (12.33 KiB) Viewed 2844 times

Which suggests you are trying to access a server with the same name as the cell reference. ( I tried absolute reference, full reference incl sheet name and none worked).

Once you return to an explicit server there is no problem.

My big problem is that it works for the author, but not for someone else who has the same TM1 permissions. (I took the reference and each time it resolves to the hidden cell reference containing the server name). It seems to be something in Excel but I am running out of ideas.

Could anyone help please?

Regards

John

[Steve Rowe]

Maybe try a named range or even a "named range" that just has a value assigned to it?
(When you create a name in xl, you don't need to point it at a range you can give it a constant value or formula too)

[John Hammond]

Thanks Steve - your suggestion led me to the answer.

I could not enter any kind of reference and hence this led me to think about software versions.

Sure enough my version of client 9.4.10000.50077 did not support references whereas the authors version 9.4.10100.55168-FP1 (great version nos IBM) did. Mine was an early eval copy I never got round to service packing!

btw IBM you have no documentation on action buttons I can find...