Load particular records in a cube using TI

Post Reply
ajaykumar09ns
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 »

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

Post by Wim Gielis »

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
Post Reply