Page 1 of 1

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

Posted: Wed Mar 21, 2012 1:19 pm
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. .

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

Posted: Wed Mar 21, 2012 1:44 pm
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
));