Write back from excel template to TM1 cube

[venkatesh.alladi]

Hi,
I have created a excel template which will be used to input data, i have used dbrw function to write the data back to the cube, but one cell has dropdown list and in the list first value is empty string, problem is when user selects the empty string then the dbrw function is getting erased and furthur selection on that cell is not getting written back to the cube, please suggest any approach.


Thanks,
Ven

[declanr]

Change the excel validated list to a tm1 picklist.
Excel validation should work anyway but using a TM1 picklist you reduce the room for error and increase server side control.

[tm1_bloke]

TM1 pick lists won't help you. The empty/null value behaviour of TM1 pick list is similar that you have experienced with Excel drop downs. Workaround to retain DBRW formula is press a space instead of an empty string in pick list.

In TM1web pick lists work better and an empty string is added automatically to pick lists.

[declanr]

Sorry tm1_bloke is correct; just in case you read my comment and tried to make it work. I though I had read TM1 Web in your original question but was just imagining it.

[Willi]

Try to Change the empty List-Element in "<empty>" (in German it is "<leer>" so I assume the word empty to be correct). This is displayed by Excel as an empty entry but TM1 treats it as not empty