DBRn Formula and TM1 9.5 With Excel 2007

Post bug reports and the status of reported bugs
Post Reply
CiskoWalt
Posts: 46
Joined: Thu Oct 16, 2008 4:02 pm

DBRn Formula and TM1 9.5 With Excel 2007

Post by CiskoWalt » Fri Jun 04, 2010 9:41 pm

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

lotsaram
MVP
Posts: 3006
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: DBRn Formula and TM1 9.5 With Excel 2007

Post by lotsaram » Mon Jun 07, 2010 12:15 pm

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 :)

TJMurphy
Posts: 56
Joined: Mon May 12, 2008 12:25 pm
OLAP Product: TM1
Version: 10.2.2 64bit
Excel Version: Excel 2013

Re: DBRn Formula and TM1 9.5 With Excel 2007

Post by TJMurphy » Mon Jun 14, 2010 8:25 am

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

Post Reply