Sheet names in DBRWs

[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,

[Paul Segal]

No, this is a "feature", I believe. It's an extremely irritating feature.

Best

[David Usherwood]

C&@p isn't it.
I do a global search and replace removing the Sheet1! refs before copying it around.

[lotsaram]

Thankfully this "feature" is gone in 9.5.2

[Wim Gielis]

Yes thankfully. And finally too!

[David Usherwood]

Wim, you are hereby awarded the Optimist of the Year Award - unless you've tested this in TM1 10

[Wim Gielis]

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.

[Alan Kirk]

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

[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.