TM1 Forum

I am getting an odd intermittent error when recalculating data in a spreadsheet using tm1 v9.5.2 and excel 2003.

If I build a cube view and then slice it back to excel the data all appears to be perfectly fine, but if I then recalculate I get a *RECALC_n returned instead of the value which should be there. If I then manually recalculate the individual cell (with f2 say, or by actually entering the formula bar and hitting enter) the value is returned with no problem.

I've overcome this before by setting all of the parameters in the spreadsheet to be fixed values rather than references to the view or to subnm, but I have one case where this is not working.

Anyone seen this before or have any ideas how to overcome?

Do you have any of the parameters dpendent on results from another cell? I've run into issues in the past where a caluculated result is needed to feed one of the TM1 cells resulting in no values (just a message like "N/A" or "RECALC" appearing. I believe it's because the DBRW statement is a batch process to the server. I've been able workaround this by using a DBR statement instead on the affected cell(s). It's much less efficent but forces a cell by cell retrieval rather than the batch.