Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic Automate script for cognos

‏2013-03-07T20:57:32Z |
Hi, i'm new to the forums so forgive me if this has been asked before.

My situation is a bit complicated. I need to refresh (build and swap) a cognos 8.2 cube on a remote transformer server but i can't seem to find anything in the api/sdk to do this.

Let me explain a little more. I need to refresh remotely because the cube is dependent on ETL processes on a microsoft SQL Server 2005 box. Once the data warehouse processing is done on that MS server, i need to kick off a refresh of the cube. The transformer and cube are on a different servers so i need to develop a way to kick off a remote refresh from an SSIS package. I'm having a hard time finding a solution online so i figure i'd try this forum.

Basically, my situation: box 1 (MS SQL Server 2005) wants to kick off a refresh on box 2 (transformer server with the cube)

plese suggest me step by step.
it would be great if yo can share script with me.
PLEASE HELP!!!!