carryforward ending balance to beginning balance

Post Reply
Analytics123
Posts: 70
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 » Sat Sep 16, 2017 7:38 pm

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: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: carryforward ending balance to beginning balance

Post by Wim Gielis » Sat Sep 16, 2017 8:09 pm

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Post Reply