DBRW Formula error while editing

Post Reply
Hyphia
Posts: 2
Joined: Thu Jul 29, 2010 2:02 am
OLAP Product: SAP
Version: TM1 9.5
Excel Version: excel 2007

DBRW Formula error while editing

Post 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
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: DBRW Formula error while editing

Post 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.
Hyphia
Posts: 2
Joined: Thu Jul 29, 2010 2:02 am
OLAP Product: SAP
Version: TM1 9.5
Excel Version: excel 2007

Re: DBRW Formula error while editing

Post 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.
Post Reply