Page 1 of 1

Transfer data in the cube to a specific cell

Posted: Mon Sep 04, 2017 6:15 am
by Wirt
Hello everybody!
I have a question about copying data from one element to another element in one cube using TI. I have a source, and a dim period, I need to copy data from one period to any other. It is necessary that when process start, I could choose the period in which to copy the data. how is this possible? Thank you!

Re: Transfer data in the cube to a specific cell

Posted: Mon Sep 04, 2017 7:12 am
by BariAbdul

Re: Transfer data in the cube to a specific cell

Posted: Mon Sep 04, 2017 7:53 am
by Wirt
thanks for the info
but I do not quite understand what is meant MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE and OTHER_DIMENSION_VARIABLES
(I'm sorry, I'm not completely versed in the processes)


IF(CELLISUPDATEABLE(vCubeName,
MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE,
pTargetElement,OTHER_DIMENSION_VARIABLES)=1);
IF(VALUE_IS_STRING=0);
CELLPUTN(NValue,vCubeName,
MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE,
pTargetElement,OTHER_DIMENSION_VARIABLES);
ELSE;
CELLPUTS(SValue,vCubeName,
MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE,
pTargetElement,OTHER_DIMENSION_VARIABLES);
ENDIF;
ENDIF;

Re: Transfer data in the cube to a specific cell

Posted: Mon Sep 04, 2017 9:03 am
by Wim Gielis
Hello Wirt,

It means that you need to supply the correct arguments to the functions CellIsUpdateable, CellPutN, CellPutS, ...
This depends on your cube structure and it's only that can do this because you know the cube structure, the variables, and so on.

Re: Transfer data in the cube to a specific cell

Posted: Wed Sep 13, 2017 8:10 am
by Drg