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
TI process should not load data if it throws error
-
- Posts: 14
- Joined: Mon Mar 28, 2011 9:21 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 200
- 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
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
www.infocat.co.uk
-
- 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
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.
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TI process should not load data if it throws error
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.