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.
How to get the record count to be processed ni TM1 Data tab
-
Ashleigh W
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: How to get the record count to be processed ni TM1 Data tab
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.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.
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
Ashleigh W
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: How to get the record count to be processed ni TM1 Data tab
Ok thanks Alan. Will give it a try and come back if I need more help. Thanks again.