carryforward ending balance to beginning balance

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

carryforward ending balance to beginning balance

Post by Analytics123 »

Hi,

I am planning to write a ti process to carry forward ending balance to beginning balance of next month via ti.
I have my data starting july 2015 in my cube , i should now start carry forward july ending balnce as august beginning balance .

For this I will create a ti with datasource as a view with july data as initial step and load august . to iterate next month should I update the month subset and change the data source ?

Thanks
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: carryforward ending balance to beginning balance

Post by Wim Gielis »

Hello,

The view for your datasource needs to be scripted using parameters such as pYear and pMonth.
Then in the Advanced > Data tab, do a CellPutN using an attribute on the Month / Period / ... dimension, to know the "Next Month".
Also, in the Prolog tab, you will need to a zero out of the data in the Next month (use the attribute as suggested above).
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply