TM1 Application Node status

[gbehel]

Dear All

Im trying to find out if any control cube exists that stores "TM1 Approval Hierarchy Application" node status. Any pointers will be helpful. I am also looking to create a report on the existing owner of the node, data change date.

If the control cube is not available then can you help in pointing out the way to design it??

Regards
GGB

[TrevorGoss]

Hello,

Try looking into the tp_application_state control cube.

The tp_application_state string will prefix the identity of the application.

This control cube shows this info: "State,Viewed,Saved,Reviewed,BeingEdited,Offline,CurrentOwner,CurrentOwnerId,TakeOwnershipNode,StartEditingDate,
StateChangeUser,StateChangeDate,DataChangeUser,DataChangeDate"

It also has the workflow as a dimension

Trevor

[gbehel]

Thanks Trevor

This helps. One more question : What does the "State" element of Node_Info dimension indicate... In my case it is "0" for one user and "2" for another

Will appreciate your help

Regards
GGB

[TrevorGoss]

Hello again

Thanks Trevor

This helps. One more question : What does the "State" element of Node_Info dimension indicate... In my case it is "0" for one user and "2" for another

Will appreciate your help

Regards
GGB

The State element of the }tp_Node_Info dimension indicates what state the node is in, it does not hold different states for different users, I am guessing thar your "0" and "2" are values for different elements in the workflow dimension.

The 5 states are:

0 = available

1 = incomplete

2 = reserved

3 = Ready

4 = Locked

I hope this helps.

Trevor