If you are unable to create a new account, please email support@bspsoftware.com

 

Executing a bat file at the end database load using Cognos 8.4.1 event studio

Started by KK2012, 23 Aug 2012 05:29:15 PM

Previous topic - Next topic

KK2012

Hi Cognos Gurus,

I am quiet new to Cognos and trying to find my way through the event studio for a requirement. Let me explain in detail exactly what i have done till now and what i would like to do next.

The version of Cognos that I am using is 8.4.1 . Currently i have designed a cube and few reports with the cube as the source. The cube needs to be refreshed once in month and occasionally may be more than once in a month if any reprocessing is happening at the database.

I have created a batch file which will do the cube build and sub sequently fire a trigger to refresh the report. The batch file is working fine and the cube build and the report refresh are working as desired. I am using window scheduler to run my batch file now.

Now the problem is,  as the end time of the database refresh is not static for every month load (Sometime it even takes 3 days to load the data), I cannot have a standard time set in the window scheduler to run every month.  :(

So i thought i would create some event which will check for the latest month record in the condition and if the condition is true, then cognos has to trigger the job schedule. But i don't want to run the agent every day looking for a change. I want to get your expertise suggestions for this problem. Is there a method to trigger the batch file/ the window scheduler that is residing in my cognos server once the database load is completed successfully.

P.S: We use Oracle 11g and the database is residing in a different server. Please help me out with this problem.

Thanks in Advance.