How to auto refresh IBM Dynamic Cube

> Open DOS command and go to Cognos Installation directory (....\bin64) and run following command. User who run this command should have appropriate right to connect cognos portal.

Note:

• Namespace name should be as it is in Cognos (upper case/ lower case)
• [server name ] should be the name Dynamic cube been published. For example if the cube was published in a multi-server environment and server 2 was used, then [Server name] should that server name 2

Here is an example how to refresh member cache

dcadmin.bat -p 9300 -s CognosServer2 -x c:\test.txt -l "NamespaceName,user_name,****!" refreshCubeMemberCache cube0

For more details, see below:- 

You open the DCAdmin command line tool from the c10_installation\bin folder (for 32 bit installations) or bin64 folder (for 64 bit installations) as follows:

• dcadmin.bat (Windows)
• dcadmin.sh (Unix)

You can run the following commands using the DCAdmin command line tool. 

Command	Description

getCubeState	Check whether a dynamic cube is started, paused or stopped
getCubeMetrics	Check the metrics of a dynamic cube before or after loading incremental updates (see http://www.ibm.com/support/docview.wss?uid=swg27040417)
startCubes	Start or resume a published dynamic cube
forceStartCubes	Start a published dynamic cube using the parameter "startROLAPCubesAndSourceCubes"
stopCubes	Stop a dynamic cube
forceStopCubes	Stop a dynamic cube using the parameter "stopROLAPCubesImmediately"
restartCubes	Restart a dynamic cube
pauseCubes	Pause a dynamic cube to make it unavailable to report users (see http://www.ibm.com/support/docview.wss?uid=swg27040535).
incrementallyLoadCubes	Load incremental updates to a dynamic cube's data caches (see http://www.ibm.com/support/docview.wss?uid=swg27040417)
refreshCubeDataCache	Refresh the data cache for a dynamic cube
refreshCubeMemberCache	Refresh the member cache for a dynamic cube
refreshCubeSecurity	Refresh the security settings for a dynamic cube
clearCubeWorkloadLog	Remove the workload logs for a dynamic cube

You can configure pauseCubes and incrementallyLoadCubes commands as dynamic cube operations for the query service (i.e., Query Service Administration Task) using IBM Cognos Administration. This allows you to run these commands by schedule or by trigger. 
Syntax

dcadmin[.bat|.sh] [-p port] [-s server] [-x output_file] [-l "namespace,userid,password"] [-arg argName argValue] command [cube0 cube1 ...]

Note that any parameter containing a comma or a space must be included in double quotation marks. For example: "param1,param2"

Symbol	Description

-p port	Specifies the port to use. Default: 9300.
-s server	Specifies the server name to use. Default: "localhost"
-x output_file	Specifies the name of the output file to which to write the structured command results.
-l "namespace,userid,password"	Specifies the BI server login parameters. For example: -l “LDAP,admin,secret123"
-arg argName argValue	Specifies command arguments: transactionID - An optional argument for the incrementallyLoadCubes command.

When you run the DCAdmin command line tool, the output script is shown on screen. You can also save the output to xml file for parsing by specifying -x output_file.

When a command is complete, the output script returns an exit code 0 if the command was successful. If there was an error, it returns an exit code 1.