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
DBRn Formula and TM1 9.5 With Excel 2007
-
lotsaram
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: DBRn Formula and TM1 9.5 With Excel 2007
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
Any spreadsheets still using these formulas should probably have been updated about 10 years ago
-
TJMurphy
- Posts: 74
- Joined: Mon May 12, 2008 12:25 pm
- OLAP Product: TM1
- Version: PA 2.0.6 Local
- Excel Version: Excel 2016
Re: DBRn Formula and TM1 9.5 With Excel 2007
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
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