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
carryforward ending balance to beginning balance
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- MVP
- Posts: 3120
- 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
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).
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
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