How to fetch Last Data Commit Date in TM1 Application Portal

Post Reply
Chittemreddy
Posts: 8
Joined: Thu Sep 16, 2010 9:02 am
OLAP Product: IBM Cognos TM1
Version: 9.5
Excel Version: 2003

How to fetch Last Data Commit Date in TM1 Application Portal

Post by Chittemreddy »

Hello Team,

We have created and deployed the TM1 10.2.0 application in Portal, If user selected the particular node and enter the forecast details and submitted the same node.

Then it will display "Last Data Commit" date in application portal, Is there any way to fetch the same date using any TM1 function.

We are using the Cognos TM1 10.2.0.

Regards
Sreenivas.
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: How to fetch Last Data Commit Date in TM1 Application Po

Post by sander »

In the 'Control' cube }tp_application_state}{[Application Number]} data about the application (like Current owner, change dates etc) is saved. Here you can find the 'Last data Commit' date. I think it's 'DataChangeDate', to be sure you have to test it. How to convert this date, you can find here; http://www.tm1forum.com/viewtopic.php?f=3&t=6698

Regards,
Sander
Chittemreddy
Posts: 8
Joined: Thu Sep 16, 2010 9:02 am
OLAP Product: IBM Cognos TM1
Version: 9.5
Excel Version: 2003

Re: How to fetch Last Data Commit Date in TM1 Application Po

Post by Chittemreddy »

Thank you very much Sander.
Post Reply