Search found 2 matches
- Mon Feb 26, 2018 6:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Chore Schedule Information
- Replies: 10
- Views: 6286
Re: TM1 Chore Schedule Information
Here is what I've gleamed from the great Alan Kirk's post. (INT(NextActivationTime/86400)+21916+(-5/24)). The -5 at the end is to convert GMT to local time. I did forget to mention that you have to have Performance Monitoring turned on to get the }Stats cubes. At least in 10.2.2 FP4 there is a cube ...
- Thu Feb 22, 2018 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Chore Schedule Information
- Replies: 10
- Views: 6286
Re: TM1 Chore Schedule Information
At least in 10.2.2 FP4 there is a cube called }StatsByChore that has some good stuff in it. You have to do the crazy serial date conversion math but it will give you the up coming schedule and last completion time.