Transfer data in the cube to a specific cell

Post Reply
Wirt
Posts: 37
Joined: Fri Feb 21, 2014 9:55 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 10

Transfer data in the cube to a specific cell

Post 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!
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Transfer data in the cube to a specific cell

Post by BariAbdul »

"You Never Fail Until You Stop Trying......"
Wirt
Posts: 37
Joined: Fri Feb 21, 2014 9:55 am
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: 10

Re: Transfer data in the cube to a specific cell

Post 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;
Wim Gielis
MVP
Posts: 3105
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: Transfer data in the cube to a specific cell

Post 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.
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
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Transfer data in the cube to a specific cell

Post by Drg »

Post Reply