I want to be able to provide some exception reporting, that details any data that is not being pulled into TM1 via scheduled chores / processes...
The data that is produced in the error logs on the server is fine - I just want to be able to email it to various departmental managers on a daily basis.
Does anyone have any ideas on the best way to do this?
Many thanks in advance!
exception reporting
-
imanminhas
- Posts: 6
- Joined: Wed Apr 14, 2010 3:08 pm
- OLAP Product: TM1
- Version: 9.1
- Excel Version: 2003
-
rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: exception reporting
You can do this in 2 steps
1) Write a VB Script to send/email the LOG files to users
2) Write a process to Execute your VB script. You can put this process in a schedule which runs after your other Load process have finished their jobs.
1) Write a VB Script to send/email the LOG files to users
2) Write a process to Execute your VB script. You can put this process in a schedule which runs after your other Load process have finished their jobs.
Cheers!
Rizwan Kaif
Rizwan Kaif