Page 1 of 1

DBRW Formula error while editing

Posted: Thu Jul 29, 2010 2:04 am
by Hyphia
Hi,

When I edit formula on excel (sliced from TM1), and when asked absolute (there is sheet titles on the side), it gives me sheet name also.

How can I get rid of sheet name in formula

Thanks

Hyphia

Re: DBRW Formula error while editing

Posted: Thu Jul 29, 2010 2:28 am
by lotsaram
The sheet name being included when using the TM1 edit formula wizard is an annoying bug that has been with us since 9.4 FP2.
Workaround - find/replace to remove the sheet name reference.

Re: DBRW Formula error while editing

Posted: Thu Jul 29, 2010 3:20 am
by Hyphia
Thanks mate.

But that would be cumbersome as a cube with too many dimension or long sheet tab name.

I hope they come out with fix for this bug.