How to paste multiple values into DBRA
Posted: Wed Nov 09, 2011 4:38 pm
I'm trying to add a passel of Names to a dimension. I have already added the elements by pasting them into the dimension editor.
I'd paste the names into the Attribute editor, but the order in the attribute editor is different and I can't see any way to sort what shows up in this editor.
So, I got the brilliant idea of using Excel.
I have a three column spreadsheet like this:
A: Item B: DBRA("Server:Item", $A1, "LongName") C: The long name
If I just use excel to copy and paste C1 to B1, it works (it puts the value into the TM1 Attribute in the database)
But if I copy C1:C100 and paste it to C1 the DBRA formulas in B1:B100 disappear and are replaced with the pasted values (the values don't make it to the database)
(I tried paste, paste as values, I tried pasting from Notepad, nothing works)
I tried writing a macro. I recorded a macro of me doing it once. The macro created uses hard references: e.g. Range("B1").Select
When I try and generalize the references, it doesn't work. It replaces the DBRA formula with the value (even though when I recorded it it worked perfectly.
I'm going to do one hundred copy and pastes by hand, because I'm in a hurry.
But if anybody can tell me how to paste multiple values into multible DBRA's, I'd appreciate it for next time.
9.5.2 Excel 2003
I'd paste the names into the Attribute editor, but the order in the attribute editor is different and I can't see any way to sort what shows up in this editor.
So, I got the brilliant idea of using Excel.
I have a three column spreadsheet like this:
A: Item B: DBRA("Server:Item", $A1, "LongName") C: The long name
If I just use excel to copy and paste C1 to B1, it works (it puts the value into the TM1 Attribute in the database)
But if I copy C1:C100 and paste it to C1 the DBRA formulas in B1:B100 disappear and are replaced with the pasted values (the values don't make it to the database)
(I tried paste, paste as values, I tried pasting from Notepad, nothing works)
I tried writing a macro. I recorded a macro of me doing it once. The macro created uses hard references: e.g. Range("B1").Select
When I try and generalize the references, it doesn't work. It replaces the DBRA formula with the value (even though when I recorded it it worked perfectly.
I'm going to do one hundred copy and pastes by hand, because I'm in a hurry.
But if anybody can tell me how to paste multiple values into multible DBRA's, I'd appreciate it for next time.
9.5.2 Excel 2003