Offline data key_err
Posted: Wed Oct 10, 2012 3:21 pm
Hi Team,
I have tried offline concept in TM1 by taking a slice of a cube view and sending that sheet to end user, there made changes(data entry) and send back to me and updated it by referring another excel data(client excel data). It was successful.
Later I have taken 10 slices from the respective cubes and conglomarated all the slices into single work book and forwarded it to end user. Later there have made changes(Offline means not under TM1 environment) and there send back me the same work book with additional excel sheet.
I have updated it under application layer in TM1. When I updated slice workbook, I was getting Key_error in the cells and warning like:
Security Warning automatic update of links has been disabled: Options this is the warning I am getting.
What options to be selected from the options.
thanks and regards
TM1 9.5.2
Excel 2007
I have tried offline concept in TM1 by taking a slice of a cube view and sending that sheet to end user, there made changes(data entry) and send back to me and updated it by referring another excel data(client excel data). It was successful.
Later I have taken 10 slices from the respective cubes and conglomarated all the slices into single work book and forwarded it to end user. Later there have made changes(Offline means not under TM1 environment) and there send back me the same work book with additional excel sheet.
I have updated it under application layer in TM1. When I updated slice workbook, I was getting Key_error in the cells and warning like:
Security Warning automatic update of links has been disabled: Options this is the warning I am getting.
What options to be selected from the options.
thanks and regards
TM1 9.5.2
Excel 2007