Upfront - News boxes/Items 1

[spicysudhi]

Hi

two questions in upfront:

1 I want to display cube updated date in the Modified date and hide the date display option for reports, in this background
(a). How to hide the Modified date and time of the newsbox/item
(b). Anyway to update those dates for cubes with the cube modified date

2. How to order the display of these items? (arrange manually)

regards,
sudhi

 

[Draoued]

If you are using PPES7.1 you can easily update the Modified date when enabling the new cube version.
The following command will update also all the saved views created by end-users in Upfront.

ppadmtool connect ${SERVER1} USER username PASSWORD
mypassword ENABLE ${CUBEPATH} NOTIFY CUBE_OBJECT ${CUBEPATH} EVENT=UPDATE

The NOTIFY update the date in Upfront.

If you are not using 7.1 but 7.0 , you can use the upfront command :
UpfrontCmd -u username -p mypassword -s servername:portNumber '<SetNewsItemProperties><Id>NEWSITEMID</Id><UpdateDate>Now</UpdateDate></SetNewsItemProperties>'

The upfrontcmd can be found in bin folder.
The NEWSITEMID is the item ID in Upfront, found in Advanced properties

 

[spicysudhi]

thanks.

anyway to hide the date display? bcoz for reports, the last modified date is meaningless...

and also anyone to my second question above.

thanks Draoued.

regards,
sudhi

 

[drlex]

sudhi,
For the second part of your query, I have found the only way to do it is to add leading spaces to the names of the reports or links. Shortcuts appear to defy the alphabetic sort.

lex

&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[drlex]

Draoued
I've been trying your 7.1 suggestion, adding the &quot;notify cube_object&quot; to the enable script but it doesn't appear to work for me. Where is the date change showing? On the cube and/or on all reports based on the cube? Or am I missing something?

many thanks,
lex

My batch is :
&quot;C:\Program Files\Cognos\cer3\bin\ppadmtool.exe&quot; < D:\Data_Folder\BAT\EnableSales.txt

EnableSales.txt is:
connect {serverort}user {user} password {pw}
cd &quot;cube folder&quot;
enable &quot;sales&quot;
NOTIFY CUBE_OBJECT &quot;sales&quot; EVENT=UPDATE
exit

&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[Draoued]

The NOTIFY should be in the same line as the enable,it s some how a parameter for ENABLE.

Try:
enable &quot;sales&quot; NOTIFY CUBE_OBJECT &quot;sales&quot; EVENT=UPDATE
as 1 command

 

[Draoued]

I forgot to respond to your first question:
The Notify is updating the Modified Date in UpFront for the cube and all the reports based on the cube, even if the report are in Personal newsboxes.
And the cube link in Upfront turns to be Bold (unread item).

 

[drlex]

No, putting it on one line makes no difference; the reports' dates remain as per their creation.
Perhaps it's a release issue - I have PPES admin 7.1.341.2 dated June 2003 and Upfront admin 7.1.333.3 dated May 2003.
I'll see if I can get an upgrade and then try again.
thanks,
lex


&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[Draoued]

We have Upfront 7.1.549.0 and PPES 7.1.544.0

 

[drlex]

Got it!
The full path needs to be specified:
connect {serverort}user {user} password {pw}
cd &quot;cube folder&quot;
enable &quot;sales&quot; NOTIFY CUBE_OBJECT &quot;cube folder/sales&quot; EVENT=UPDATE
exit

Ref: Cognos KB article 124928

lex

&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[spicysudhi]

lex,

i have seen fewq of ur posts saying &quot;Ref: Cognos KB article xxxxxxx &quot;,

question on this. r u refering to the Knowledge base on the cognos website? if so when i click that that link, it takes to a search page, how to get the reference number u have given here?

regards,
sudhi

 

[drlex]

Yes, I am referring to the Knowledge Base on the Cognos Site. Enter the number in the search box and then click the radio button (near the bottom of the page) to select Document ID as the search type.
lex

PS: for anyone using the shell command in a script to kill, then enable cubes after copying, you may need a delay loop in order to give the kill command to complete prior to copy and enable.

&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[drlex]

Draoued,
For the Upfrontcmd method, should this also work for NewsItems that are (hyper)links? I get a result code = &quot;Success&quot; after running it from the command line as against the correct id for the NewsItem, yet the date displayed in Upfront remains that of the date of creation.
I note that no dates are displayed under &quot;properties&quot; for NewsItems that are links.
thanks,
lex


&quot;Time flies like an arrow, but fruit flies like a banana.&quot;

 

[Draoued]

For me it works for everything.
Even a URL link added manually to Upfront will be updated with upfrontcmd.
Command is :
UpfrontCmd -u username -p mypassword -s servernameortNumber <SetNewsItemProperties><Id>NEWSITEMID</Id><UpdateDate>Now</UpdateDate></SetNewsItemProperties>
There is no single quote.

You can test it from your web broswer.

http://...../cgi-bin/upfcgi.exe?xml...Date>Now</UpdateDate></SetNewsItemProperties>

The modified date in Upfront newsitems description is then updated when refreshing the screen.

 

[drlex]

well, that's just plain odd!
The xml command in the browser works; the command line level version doesn't (although the output indicates it has been changed, as result code = success and number of objects modified = 1).
Perhaps I'll need to upgrade upfront to the version you have, although I would have thought that fix would have been in the documentation.
Thanks for all your help, Draoued, that has to be worth a star for getting me going.
lex

&quot;Time flies like an arrow, but fruit flies like a banana.&quot;