Use Action Button to Capture Date/Time?
-
- Posts: 21
- Joined: Wed May 25, 2011 1:49 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Use Action Button to Capture Date/Time?
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.
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Use Action Button to Capture Date/Time?
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.
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.
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Use Action Button to Capture Date/Time?
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.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.
Just be careful about how the time is stored in the cube. See this thread for an overview of the various types and formats.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.