TM1 Forum

Client is on TM1 9.5.1 accessed through Citrix using Excel 2003.

Have others encountered this?

When a DBS formula references a blank cell and is refreshed, any value in the cube is overwritten with zero.

When a DBSW formula references a blank cell and is refreshed, the value in the cube is not overwritten.

(Admin note: Moved from bugs till proven/SR raised)

Did you find an answer to this? We have a similar issue in a spreadsheet.

If we use DBS then we get #N/A in all the cells. If we use DBSW, then we can see the numbers in the spreadsheet, but they are not sent to the cube at all. Infact, it wiped out the existing data in the cube!

Thanks.

Hi,

What is the source for the number you are trying to load through the DBSW formula ?

DBRWs can not be used to source a DBSW.
It is due to the priority in which the formula get calculated.

You can look at this post for more details.
http://www.tm1forum.com/viewtopic.php?f=3&t=3064

Hope this helps,