TI process should not load data if it throws error

Post Reply
swati_phadtare
Posts: 14
Joined: Mon Mar 28, 2011 9:21 am
OLAP Product: TM1
Version: 9.5
Excel Version: 200

TI process should not load data if it throws error

Post by swati_phadtare »

Hi ,
While loading data from flat file through TI process if it throws any error then it should not load any data to cube.
Kindly help me in coding this.
Thanks & Regards
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 process should not load data if it throws error

Post by Steve Rowe »

Your best bet is to trap "any errors" in the metadata tab before starting the data tab. Then if you find errors you can processbreak/quit at the end of the metadata.
Technical Director
www.infocat.co.uk
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: TI process should not load data if it throws error

Post by Christopher Kernahan »

For individual items that have errors, you can use ItemReject('message'); which will skip the particular data line and also output a message to the Message Log.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: TI process should not load data if it throws error

Post by David Usherwood »

If you don't want _any_ data from the feed to be left in the cube, count the errors and clear the destination in the epilogue if the count is positive.
Post Reply