TM1 Forum

Hi guys,

On our current system, we have the following hierarchy:
Cluster -> Department -> Branch -> Business Unit
Users of business units will submit their budgets to a higher level (branch level)

We currently require the following functionality:
Is there any way for the system to compile a report of who haven’t submitted their budget on a specific date?

How are you tracking if they've submitted their budget or not? If values are anything other than zero or something else?

A quick google search returned the video linked below that utilizes data reservations, but some methods demonstrated are possibly the components of what you're looking for.

https://youtu.be/1DBHG7LUWLg

There are several ways to do this. Here is one idea:

Create a 3 dimension cube with the following dimensions, where the measures dimension has one element: "Count":
- Version
- }Clients
- Period
- Measures

Simple, but gives the planners more accountability:
-At the beginning of the budget season populate "Count" with a 1 for all }Clients for that version.
-When users finish their budget, they can click an action button that runs a TI that populates a 0 in the cube above for that client, and version.
-Write your report zero suppressed with the }Clients dimension on the rows