Missing Budget Data for Some Elements in Cube

[sh226]

Hello All,
I recently had weird issue in one of my cube which was missing "budget" values for some of the key elements. There is no error recorded in log file. Data load process ran successfully through ODBC but when my Manager ran reports, she noticed there were some of the elements with missing Budget values. I re-ran Budget Data load process and everything again was perfect. Now my Manager is asking me to set up some kind of process that can initiate a flag/email if there is any values missed during data load process. is there a way to create a process that can email or log the information about elements that were missed during data load process? I really appreciate if some body can provide me TI code to accomplish above task. Thank you very much.

[jim wood]

Have you checked the useful code forum? I'm not sure if email is covered there. If not have you tried googling on the subject? I think I remember somebody posting some code to share on a blog.

[tomok]

Think about it for a minute....How can you expect a system to know when something is "missing"? The only way TM1 can know if a particular company, account, cost center, blah, blah, blah combination is supposed to have budget information is for you to tell it so. This really is not practical. The answer, and you should already be doing this, is to reconcile the budget data that's in TM1 with the budget data in the source, after every load. When the numbers don't match you can then launch an investigation. There are ways to create special budget views in the cubes, and load control totals from the source into a control cube to help you balance, but there is no way to do what you are suggesting. It's going to take human eyes looking at something.