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.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.
I forgot to tell that some of the 0 level cell also contain formula which TM1 not allow to overwrite.Find the "Select By Level" button and select level 0
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.emotlau wrote:I forgot to tell that some of the 0 level cell also contain formula which TM1 not allow to overwrite.Find the "Select By Level" button and select level 0
It is difficult to exclude the non-formula cell.
Yes, I have chosen this option finally.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.
And it works!