Cognos Masters,
I need help setting up our Cognos triggers to have our cubes 'refreshMemberCache' when our ETL jobs finish running. At the moment, our jobs finish around 5:30AM and I have to manually restart the cubes every morning to get the new data. I know there is a process out there that I can set up to get this done automatically. Any help would be greatly appreciated.
Best,
Zach George
Hi Zgeorge
I got 2 different approaches to offer you:
1] Use the DCADMIN command line tool from IBM
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cog_rlp.doc/c_cog_rlp_if3_dcamin.html
This tool is quit straight forward, we use it for checking the state of the cubes during the day.
2] Use the tasks in Cognos Admin:
> Administration
> Configuration
> Content Administration
> On the right click the icon: "new Query service administration task" The wizards takes you through the needed options
> Then configure a schedule on this task, either a simple time schedule, or use a trigger - this must then be fired by abother process
Good Luck