TM1 Contributor Reports

[cdhodge2002]

I have a contributor question. I am looking to create a report that allows the end users to see if certain nodes in the contributor workflow hierarchy are not started, in progress, submitted, or rejected. I can come up with the first 3 items using the state measure in the }tp_application_state cube. However I am having trouble figuring out the 4th item. I do not see any cube that contains information on if a node has been rejected. Does anybody know where this information might be?

[PlanningDev]

I don't believe that Rejected is a status. Rejecting a node simply changes the status back to "Work In Progress" which would unlock the node for Submitters to make changes again.

[cdhodge2002]

I was not sure if there was some kind of update field that would let me know if a rejection has occurred.

[Martin Ryan]

You'd have to roll your own. The status values are held in the cube that you mention, so the only way to find out if it had gone from submitted back to work in progress would be to either trawl the logs, or to have a TI process that runs every so often and records whether a status was submitted. Then you can compare that to what it is now and infer that it's been rejected.

Martin