Page 1 of 1
How to get the record count to be processed ni TM1 Data tab
Posted: Wed Apr 26, 2017 9:35 am
by Ashleigh W
Hi everyone!
How to get the record count to be processed in TM1 Data tab?
I want to run additional steps once all the records are processed in data tab so the data are updated in cube prior processing this extra step.
thank you.
Re: How to get the record count to be processed ni TM1 Data tab
Posted: Wed Apr 26, 2017 9:40 am
by Alan Kirk
Ashleigh W wrote:Hi everyone!
How to get the record count to be processed in TM1 Data tab?
I want to run additional steps once all the records are processed in data tab so the data are updated in cube prior processing this extra step.
thank you.
Why do you need the record count? The TI process executes once for each row of the data source. When it has processed the final row, it moves on to the Epilog tab. You can therefore do your extra step on that tab. It's irrelevant how many records it has processed before that.
However if you really need to know, you set a variable's value to 0 in the Prolog tab, then increase that value by 1 as the first line of your data tab code.
Re: How to get the record count to be processed ni TM1 Data tab
Posted: Wed Apr 26, 2017 10:09 am
by Ashleigh W
Ok thanks Alan. Will give it a try and come back if I need more help. Thanks again.