Hi,
I am new to this TM1, Could you please help me in how to load particular source values in a cube using TI.
For suppose I have 10 records in a source data, but I want to load only last 4 or 5 records into the cube using TI function. How can I do that..
Load particular records in a cube using TI
-
- Posts: 3
- Joined: Tue Jun 04, 2019 6:14 am
- OLAP Product: Planning analytics
- Version: 2.0.6
- Excel Version: 2016
-
- 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: Load particular records in a cube using TI
Either you change the query for the datasource to include only the records needed, either you have logic in the TI process to count the number of records that have been treated. If this means excluding the last 5, for example, it can mean that you need to use a helper process to know how many records you have in total (such that you can stop processing at (x - 5) records).
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