Home Knowledge Articles Series 7 Trigger The Notify Event For Correct Cube Build Date In Upfront
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 30
Yesterday: 111
Last Week: 3353
This Month: 9182
Last Month: 16191
Total: 382835


Trigger The Notify Event For Correct Cube Build Date In Upfront PDF Print E-mail
(0 votes, average 0 out of 5)
Written by Martijn Christenhusz   
Wednesday, 20 May 2009 20:22

When a cube is published for the first time in Upfront the publish timestamp is attached to the cube. But when the cube is refreshed the timestamp in Upfront does not change. You can change this by executing this script with the NOTIFY option.

extra info:
model name is Great Outdoors Company.mdl
(published) cube name in PowerPlay Enterprise Server (PPES)

***************** Script *********************
echo 1. disable the cube in PPES
echo 2. build the cube
echo 3. enable the cube and trigger the notify event so that the modified cube date in Upfront is current

"c:\program files\cognos\cer4\bin\ppadmtool.exe" connect <SERVERNAME>:8010 user cognos password cognos disable "Great Outdoors Company"

"c:\program files\cognos\cer4\bin\trnsfrmr.exe" -n -s "C:\Program Files\Cognos\cer4\samples\PowerPlay\Cubes and Reports\Great Outdoors Company.mdl"

"c:\program files\cognos\cer4\bin\ppadmtool.exe" connect <SERVERNAME>:8010 user cognos password cognos enable "Great Outdoors Company" NOTIFY CUBE_OBJECT "/Great Outdoors Company" EVENT=UPDATE

Comments

Please login to post comments or replies.
Last Updated on Sunday, 14 February 2010 12:10
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?