Transfer data in the cube to a specific cell

Post Reply
Wirt
Posts: 36
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 » Mon Sep 04, 2017 6:15 am

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: 400
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: Transfer data in the cube to a specific cell

Post by BariAbdul » Mon Sep 04, 2017 7:12 am

"You Never Fail Until You Stop Trying......"

Wirt
Posts: 36
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 » Mon Sep 04, 2017 7:53 am

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: 1522
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Transfer data in the cube to a specific cell

Post by Wim Gielis » Mon Sep 04, 2017 9:03 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Drg
Posts: 57
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 » Wed Sep 13, 2017 8:10 am


Post Reply