Copying data TM1
Posted: Thu Sep 17, 2020 3:27 pm
Hey, New to tm1 here.
So i wrote a ti process that allows me to cpy data from one scenario to the other. I could copy from one year in the source to another in the target.
And like that copy from different months/accounts whatever .
But I am only able to copy into a leaf level element (copy from 2019-2020, or one month to the other, one account to the other)
I am trying to copy data from a roll up to another roll up, or instead of just 1 month I would like to copy data from the entire Quarter 1 into the entire quarter 1 of another sceario. using parameters doesnt seem to be doing the job
Update:
I was able to copy from one scenario to another. But I would like to copy from (e.g, the actuals of dept 0 into the budget of dept 1,2,3, and 4) basically take one piece of data divide it into 4 and place 1/4 into each one of the targets I’ve tried to just use a calculation and cell put N but maybe I’m doing something wrong?
So i wrote a ti process that allows me to cpy data from one scenario to the other. I could copy from one year in the source to another in the target.
And like that copy from different months/accounts whatever .
But I am only able to copy into a leaf level element (copy from 2019-2020, or one month to the other, one account to the other)
I am trying to copy data from a roll up to another roll up, or instead of just 1 month I would like to copy data from the entire Quarter 1 into the entire quarter 1 of another sceario. using parameters doesnt seem to be doing the job
Update:
I was able to copy from one scenario to another. But I would like to copy from (e.g, the actuals of dept 0 into the budget of dept 1,2,3, and 4) basically take one piece of data divide it into 4 and place 1/4 into each one of the targets I’ve tried to just use a calculation and cell put N but maybe I’m doing something wrong?