How to make a closing balance from a previous month an opening balance in the next month?

kumesh · Post by **kumesh** » Tue Aug 27, 2019 6:03 am

Hi,

Please help, I am new to TM1. I need to create a rule on my cash flow cube, to take the closing balance from previous month to the opening balance in the next month?

Your help will be appreciated
Thanks

orlando · Post by **orlando** » Tue Aug 27, 2019 8:00 am

Hi kumesh,

maybe you should first familiarize yourself with the basic concepts of TM1.
I recommend you the pages of IBM

https://www-01.ibm.com/support/docview. ... wg27049091

or this thread:

https://www.tm1forum.com/viewtopic.php?f=3&t=14823

You can find more information for beginners by searching in the forum.

In your special case you don't need further elements in the dimension but attributes for the dimension "month" (previous month, following month).
These attributes will then be filled with the corresponding information for each month.
The ClosingBalance can then be "updated" as OpeningBalance via a rule.

How to do this is best explained in the RulesGuide:

http://public.dhe.ibm.com/software/data ... m1_rul.pdf

regards
orlando

kumesh · Post by **kumesh** » Wed Aug 28, 2019 7:50 am

thank you

jim wood · Post by **jim wood** » Wed Aug 28, 2019 10:44 am

Welcome Kumesh and excellent post Orlando!!

tomok · Post by **tomok** » Wed Aug 28, 2019 12:10 pm

What the guys didn't tell you is that while this linking of periods is a very useful feature in TM1, it is not without it's caveats and challenges. The biggest issue is going to be linking too many periods into the future and ending up with a stack overflow error because you have too many dependent links. See https://www.tm1forum.com/viewtopic.php?f=3&t=1170 for more details. It is best to use this feature judiciously and not try and link too far into the future. It is also wise to not link periods in the past since it may not be necessary.

gtonkin · Post by **gtonkin** » Thu Aug 29, 2019 4:30 am

tomok wrote: ↑Wed Aug 28, 2019 12:10 pm What the guys didn't tell you is that while this linking of periods is a very useful feature in TM1, it is not without it's caveats and challenges. The biggest issue is going to be linking too many periods into the future and ending up with a stack overflow error because you have too many dependent links. See https://www.tm1forum.com/viewtopic.php?f=3&t=1170 for more details. It is best to use this feature judiciously and not try and link too far into the future. It is also wise to not link periods in the past since it may not be necessary.

This is a case where the proposed feederless rules would really be useful. Definitely one of the first tests to run with them.

TM1 Forum

How to make a closing balance from a previous month an opening balance in the next month?

How to make a closing balance from a previous month an opening balance in the next month?

Re: How to make a closing balance from a previous month an opening balance in the next month?

Re: How to make a closing balance from a previous month an opening balance in the next month?

Re: How to make a closing balance from a previous month an opening balance in the next month?

Re: How to make a closing balance from a previous month an opening balance in the next month?

Re: How to make a closing balance from a previous month an opening balance in the next month?