Hi,
Anyone know how to skip the TI Process error "Rules Apply To Cell"?
Thanks
TI Error: Rules Apply To Cell
- Steve Rowe
- Site Admin
- Posts: 2456
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TI Error: Rules Apply To Cell
Use the TI function CellIsUpdateable to test the location you are writing to before you write to it.
If (CellIsUpdateable ( cube reference)=1);
CellPutN ( value, cube reference );
EndIf;
Cheers
If (CellIsUpdateable ( cube reference)=1);
CellPutN ( value, cube reference );
EndIf;
Cheers
Technical Director
www.infocat.co.uk
www.infocat.co.uk