TM1 Forum

Hi guys.

We are currently working with an approval hierarchy application type on Tm1/Planning Analytics.

Our hierarchy structure is as follows: Cluster -> Department -> Branch -> Business Unit.

The user at a Business Unit level will submit to the Branch level.

Is there any way to retrieve a list of users who haven’t submitted their budgets on a certain date and send it to somebody (Eg, Branch manager) via e-mail?

We already have the email method which uses the SendEmail.exe file via TurboIntegrator.

We are trying to figure out how to compile the string which contains the names of the users who haven’t submitted their budgets on a specific date.

Any ideas will be much appreciated.

Let me start by saying I don't have an answer for you, sorry. However, the source for what you want is in a cube, }tp_application_state}{XXXXXXX}. The XXXXXX will be replaced by a key number and that is going to be unique to your application. This cube has, among other things:

State - the state of the node, represented by a number. You search for those having the number representing not submitted. For example purposes we'll say 3.
CurrentOwner - the alias name of the user id for the person that owns the node
CurrentOwnerID - the actual client id of the node owner

You should be able to create an MDX-based subset on the }Clients dimension that looks for elements that have a value less than 3 in the }tp_application_state}{XXXXXXX} cube. This will be your list of clients that have not submitted their budget, forecast, whatever. Good luck.