Load particular records in a cube using TI

Post Reply
Posts: 3
Joined: Tue Jun 04, 2019 6:14 am
OLAP Product: Planning analytics
Version: 2.0.6
Excel Version: 2016

Load particular records in a cube using TI

Post by ajaykumar09ns » Tue Sep 10, 2019 3:55 am


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..

Wim Gielis
Posts: 2346
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium

Re: Load particular records in a cube using TI

Post by Wim Gielis » Tue Sep 10, 2019 7:11 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply