TI Error: Rules Apply To Cell

Post Reply
olapuser
Posts: 40
Joined: Fri Jan 29, 2010 1:55 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007
Contact:

TI Error: Rules Apply To Cell

Post by olapuser »

Hi,

Anyone know how to skip the TI Process error "Rules Apply To Cell"?

Thanks
User avatar
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

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
Post Reply