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!
Transfer data in the cube to a specific cell
-
- 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
Try this,It might help:
http://www.wimgielis.com/tm1_copydataonelement_EN.htm
http://www.tm1forum.com/viewtopic.php?t=1767 Thanks
http://www.wimgielis.com/tm1_copydataonelement_EN.htm
http://www.tm1forum.com/viewtopic.php?t=1767 Thanks
"You Never Fail Until You Stop Trying......"
-
- 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
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;
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;
-
- MVP
- Posts: 3118
- 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
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.
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
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