Page 1 of 1

DBRn Formula and TM1 9.5 With Excel 2007

Posted: Fri Jun 04, 2010 9:41 pm
by CiskoWalt
Seems that the old DBRn (where 'n' is the number of dimesnions referred to) do not work with Excel 2007 and TM1 version 9.5

The formula will rerurn #NAME? error messages

The same Workbook will work with Excl 2003 and TM1 version 9.5

We have to replace DBRn with DBR formula.

Is this common knowledge?

Thanks

W

Re: DBRn Formula and TM1 9.5 With Excel 2007

Posted: Mon Jun 07, 2010 12:15 pm
by lotsaram
I'm not sure this is a bug. DBRn was removed from product documentation way back in version 7 or 8 when those formulas were replaced by DBR and DBRW. If undocumented features stop working it's unlikely that IBM would see this as a "bug"

Any spreadsheets still using these formulas should probably have been updated about 10 years ago :)

Re: DBRn Formula and TM1 9.5 With Excel 2007

Posted: Mon Jun 14, 2010 8:25 am
by TJMurphy
It's because that's a valid cell reference in the new "wider" Excel.

And on our version (9.1SP3 but with clients on mixed Excel 2003 / 2007) there's another nasty little gotcha. It's basically a DBR3 formula through an Excel 2007 model back into an Excel 2003 model causes the server to hang ... IIRC Excel 2007 flags the DBR3 as 'DBR3 thus disabling it but Excel 2003 still tries to evaluate it but somewhere it gets stuck in an infinite loop requiring the server to be crashed. We changed all our standard models to strip out the offending command (there was only one left so it wasn't too bad) so haven't had any re-occurrences.

Tony