Hi Friends... I am new to TM1 and would like to get some help from the community.
I plan to use TM1 for rolling forecast of OPEX involving several departments.
I have a Cube with YTD actual costs and ask other departments to update the forecasted OPEX, and I have another cube containing the budget data.
I would like them to input comments for the variances between 1) actual and budgets 2) forecast and budget.
For example, assuming there is a saving of 50,000 actual admin cost against budget, and there are 2 reasons contributing of 20,000 and 30,0000 saving each, I am hoping they can input the comments as follow:
Dept Saving Explanation
Admin 20,000 Reason 1
Admin 30,000 Reason 2
It would be perfect if there is any alert to the contributor if the total savings mentioned by them is less than the total.
How should I build it in TM1?
Appreciate any advice.