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
DBRW Formula error while editing
-
- 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
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.
Workaround - find/replace to remove the sheet name reference.
-
- 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
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.
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.