Page 1 of 1
Sheet names in DBRWs
Posted: Tue Jan 10, 2012 11:03 am
by Steve Rowe
The release of TM1 I'm on (9.5.1 SR something) insists on putting the sheet name when you build a DBRW using edit formula
This makes the formula editor impossible to use and the formula you get can't be copied around from sheet to sheet without more work.
=DBRW(Sheet1!$B$1,Sheet1!$B$2,Sheet1!$B$6,Sheet1!$B$3,Sheet1!$B$4,Sheet1!$B$9,Sheet1!$A10,Sheet1!$B$5)
Anyone know how to stop this from happening on the off chance that is an Excel setting that is making this happen?
Cheers,
Re: Sheet names in DBRWs
Posted: Tue Jan 10, 2012 11:08 am
by Paul Segal
No, this is a "feature", I believe. It's an extremely irritating feature.
Best
Re: Sheet names in DBRWs
Posted: Tue Jan 10, 2012 11:14 am
by David Usherwood
C&@p isn't it.
I do a global search and replace removing the Sheet1! refs before copying it around.
Re: Sheet names in DBRWs
Posted: Tue Jan 10, 2012 11:24 am
by lotsaram
Thankfully this "feature" is gone in 9.5.2
Re: Sheet names in DBRWs
Posted: Tue Jan 10, 2012 11:28 pm
by Wim Gielis
Yes thankfully. And finally too!
Re: Sheet names in DBRWs
Posted: Wed Jan 11, 2012 2:47 pm
by David Usherwood
Wim, you are hereby awarded the
Optimist of the Year Award - unless you've tested this in TM1 10
Re: Sheet names in DBRWs
Posted: Wed Jan 11, 2012 8:17 pm
by Wim Gielis
David Usherwood wrote:Wim, you are hereby awarded the
Optimist of the Year Award - unless you've tested this in TM1 10
I haven't tested anything
I'm currenntly on a TM1 9.5 installation, so I cannot verify if it is still there in TM1 9.5.2.
But I have all confidence in Lotsaram!
To be honest, I don't not use this feature a lot, only occasionally.
Re: Sheet names in DBRWs
Posted: Wed Jan 11, 2012 9:08 pm
by Alan Kirk
Wim Gielis wrote:David Usherwood wrote:Wim, you are hereby awarded the
Optimist of the Year Award - unless you've tested this in TM1 10
I haven't tested anything
I'm currenntly on a TM1 9.5 installation, so I cannot verify if it is still there in TM1 9.5.2.
But I have all confidence in Lotsaram!
To be honest, I don't not use this feature a lot, only occasionally.
As do I, to the extent that I'd never noticed it to be a problem in earlier 9.5 releases simply because I had probably never used it in those. It doesn't happen in either 9.0 or (as noted above) 9.5.2.
However whether it works in version 10 or not... I'll bet that it
still won't pick up range names the way a standard Excel formula does. (And since I use range names for all title elements in standard reports, I have to go in and edit the formula anyway before I can copy it around.)
Re: Sheet names in DBRWs
Posted: Mon Jan 23, 2012 5:41 am
by Olivier
Hi All,
I am running 9.4MR1FP3 and this feature is there as described.
Sometime the formula generator fail completely as the worksheet name in each reference makes it too long for the DBRW to be written in Excel.
This was not the case in 9.1SP3UPD2.