Page 1 of 1
How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 4:00 am
by emotlau
- 33.jpg (31.75 KiB) Viewed 5444 times
Hi,
Is there anyway to copy data from one column to another one in cube view? For example i want to copy all non consolidated data from (R0, JAN) into (E3, JAN).
Because the consolidated data exist in some of the rows, TM1 does not allow to paste at all. Is there any option to paste into non-consolidated cell only? I cannot select only the non-consolidated cell to copy since it is really time consuming.
Help Me....
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 4:11 am
by Alan Kirk
emotlau wrote:Is there anyway to copy data from one column to another one in cube view? For example i want to copy all non consolidated data from (R0, JAN) into (E3, JAN).
Because the consolidated data exist in some of the rows, TM1 does not allow to paste at all. Is there any option to paste into non-consolidated cell only? I cannot select only the non-consolidated cell to copy since it is really time consuming.
Help Me....
It shouldn't be that time consuming. Select all elements in subset editor. Find the "Select By Level" button and select level 0.
If you do this often you can also use the Record Expression option on the Tools menu to create a dynamic subset which refers only to the N level elements, creating it in the fashion described above.
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 4:24 am
by emotlau
Find the "Select By Level" button and select level 0
I forgot to tell that some of the 0 level cell also contain formula which TM1 not allow to overwrite.
It is difficult to exclude the non-formula cell.
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 4:30 am
by Alan Kirk
emotlau wrote:Find the "Select By Level" button and select level 0
I forgot to tell that some of the 0 level cell also contain formula which TM1 not allow to overwrite.
It is difficult to exclude the non-formula cell.
Yes, I have a dimension like that as well. What I did with it was to create an attribute and flag the elements which are affected by rules. Granted, it was initially a little time consuming but it only needed to be done on a one-off basis. After that I could select all of the elements by a combination of level and attribute. It simplifies life if you need to do this kind of copying regularly.
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 4:53 am
by SueZhaZa
Bravo Alan Kirk! 
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 7:33 am
by Martin Ryan
An alternative option is to slice the cube out to Excel then convert the second column from DBRWs into DBS formulas that pull the value to send from the first column and send it into the second column. The DBS that try to send to ruled cells will silently fail without preventing the other ones from working.
Martin
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 8:48 am
by declanr
Can you not just use the in-built spreading techniques? (e.g. relative...)
Or do they completely fall over if there is a rule calc'd cell?
Re: How to copy from one column to another in cube view
Posted: Tue Mar 27, 2012 9:24 am
by emotlau
An alternative option is to slice the cube out to Excel then convert the second column from DBRWs into DBS formulas that pull the value to send from the first column and send it into the second column. The DBS that try to send to ruled cells will silently fail without preventing the other ones from working.
Yes, I have chosen this option finally.
And it works!