TM1 TI Process

Post Reply
HarshaPatil
Posts: 6
Joined: Tue May 23, 2023 8:23 am
OLAP Product: IBM Cognos TM1 Architect
Version: IBM Planning Aalytics 2.0
Excel Version: 15 0 4569 1504

TM1 TI Process

Post by HarshaPatil »

I am just newbie in TM1.I have some doubts please if u know any suggestion u can give. We are loading daily Actuals data in TM1 cube ,as we have source from ETL side. When they finish loading then only we have to load data but we have some chores which schedule at fix timing if chore schedule at 8:30 AM and data finish from ETL side at 8:31 AM then in that situation through chore some data is missing in cube. can we put some conditions for that...?
After that we have dependency on that Daily Actual cube .we are loading data from Daily Actual cube to table(database) as in that process we set Flag "Y". Sometimes if data is not loaded then also flag set to Y coz half data is present in that Daily Actual cube. Is there any solution for this situation...?

I have another doubt can we use same TI to load data(loading data from TM1 cube to database) for two different dates (ex 22 May& 23 May)..? but if we set two dates in TI then on 1st day same process will load for 22 May as 23 May data is zero on 1st day... On 2nd day we have load data for only 23 May but it will load for 22 May and 23 May also as we schedule this process in chore so in that situation 22nd may Data is double in table.. We have static subsets just we have to change only dates to run everyday but problem is occurs in weekends.so we are trying to automate the process.
Wim Gielis
MVP
Posts: 3103
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: TM1 TI Process

Post by Wim Gielis »

Use a flag in a table to know when the data is ready to be loaded.

Have a chore run the process x times per day but do a ChoreQuit; when the calling process determines that data have been loaded already.
For instance, keep track of this information in an attribute or simple logging cube by day.
Or update the flag table such that next loads will not find any need to launch the process again.
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