convert string to code TM1

[mrdauduong]

Hi community,

Iam looking for an idea.

I have a client who have 53 cubes that use the dimension Version

I have to dev something that copie a version to another version for all the cubes.

Right now, the only solution i have is make 53 processus copy for each cube and 1 process MASTER to execute this 53 processus copy.

Another idea that i can thing about is make something "auto code" but i dont know how to make a string variable become the code TM1

For exemple

CubeName ='XXX';
CodeTM1= 'cellput('&CubeName&'.....&')'; ==> but how to make CodeTM1 work?

Is there another solution that can solve my case?

Thanks a lot !

[David Usherwood]

That's the easy bit - because the cube name is just a string:

Code: Select all

CubeName ='XXX';
cellputn(cubename, v1,v2....vnn);

However I think you are hoping to build a complete cellputn statement. That's not possible in pure TI code. You could do it in TM1PY using tm1.processes.update_or_create though.

[Alan Kirk]

Another way might be to use the Bedrock library, where most of the code has been built for you. Specifically, the }bedrock.cube.data.copy process.

[mrdauduong]

Another way might be to use the Bedrock library, where most of the code has been built for you. Specifically, the }bedrock.cube.data.copy process.

thanks, it is the thing i need for now !!!

That's the easy bit - because the cube name is just a string:

Code: Select all

CubeName ='XXX';
cellputn(cubename, v1,v2....vnn);

However I think you are hoping to build a complete cellputn statement. That's not possible in pure TI code. You could do it in TM1PY using tm1.processes.update_or_create though.

thanks, i will try it in the future