Cognos 11 Dynamic Cube Restart

[zgeorge]

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

[paulpeetersnl]

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