TM1 Forum

Can a TM1 input form have something like a button a user hits that captures current date and time. Have a TI process utilize the =Now() ability of Excel? So a cube would have a list of clients and the agent would hit a button and then TM1 would store info on the date and time when the client was contacted.

Hi
Yes, once you have selected the process that needs to be executed by the Action Button, you should be able to pick up the parameters that get sent into the process from XL cells.

cardantim wrote:Can a TM1 input form have something like a button a user hits that captures current date and time. Have a TI process utilize the =Now() ability of Excel? So a cube would have a list of clients and the agent would hit a button and then TM1 would store info on the date and time when the client was contacted.

Gregor's given you one solution, but another is just to have the TI process work out the current date and time in the Prolog from a combination of the NOW function and, if you need it formatted, the TIMST one. In that way you don't need the action buttons to pass anything to the process. The only down side of this process is if you have users in different timezones since the NOW function in TM1 records the server's time, not the client's.

Just be careful about how the time is stored in the cube. See this thread for an overview of the various types and formats.