TM1 Forum

Hi Team, We have one process to load data from cube to table. In that we have Dimensions- Year, Day, Budget_KPI, Branch & Measure. These dimensions have static subset only Day is dynamic as we have to run this process daily morning via chore. So we are selecting day(current date-1) everyday and ...

Thanks wim for the reply. I'll try this method.

Yes I asked source team they agreed to give us completion status as "C" in table

Should I have to check flag condition in Advanced-> Data Tab before SQL statement(as we are exporting data from cube to table).

Thanks Wim Gielis for the reply. We have total 6 processes to load daily Data in Actual Cube. 1. We have chore schedule at 8:40 AM but if source side(ETL) finish there data in between 8:40 AM to 8:41 AM in that situation our 1st process triggered exact 8:40 so half data is gone in cube(some KPIs Val...

Hello. I am very new to TM1 and I need some urgent assistance with an 'IF' statement in a TI Process. I have a cube that contains a Daily data ,. Lets say the data looks like :vBudget_KPIs(200 KPis) , vBranch_Master(5000 branches) ,vDays ,vYear, vValue . As these data is load on daily basis. Data is...

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