Need a way to copy all elements of a dimension to another

Post Reply
jcblough
Posts: 18
Joined: Tue Mar 20, 2012 3:08 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Need a way to copy all elements of a dimension to another

Post by jcblough »

I am working on a financial planning application and I need a process to create a copy of the plan into a new dimension when the plan is finalized. For example, say I have a simple cube with the dimensions of Version, Month, and Store. The users will lay out a plan of sales by store by month in a version level named 'plan'. when this process is complete, I need to run a process that will take the info in the 'plan' element of the version dimension and copy it to an element named 'final' I would think this would need to be a TI process, but I do not see a way to do this. Mind you, I'm a complete novice. .
jcblough
Posts: 18
Joined: Tue Mar 20, 2012 3:08 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: Need a way to copy all elements of a dimension to anothe

Post by jcblough »

Disregard, I got it - just made a TI process that took no action and did the following in the data section:

if (VALUE_IS_STRING=1, CellPutS(SVALUE,'Copy Test',Location,Measures,Version,YearQtr), CellPutN(NVALUE, 'Copy Test', Location,Measures,Version,YearQtr
));
Post Reply