If you are unable to create a new account, please email support@bspsoftware.com

 

Datawarehouse builds notification on Cognos Connection page

Started by jmorrison, 25 Apr 2007 04:14:24 PM

Previous topic - Next topic

jmorrison

We have our datawarehouse being built at 7:30 pm CST for Sales Information, 10:30 PM CST for AR information, 1 am CST the next day for Inventory information. 
We come in the morning to find the Inventory build was hung. People in Europe have been running the reports to find out the data has not been updated by viewing the data.

Is there a way to place a scrolling text frame or window that shows the last update of all the datawarehouses on Cognos Connection.  This way people will know the status of the datawarehouse before they go and run their reports.




COGNOiSe administrator

#1
Two options:
1. You make your users hit a dashboard (portal tab) when they log in. Then you can display whatever messages you need in form of a report or RSS feed.
2. You modify Cognos JavaScript and plug in the message using DOM and DHTML.

jmorrison

To modify Cognos javascript, I assume you need the SDK.  Javascript is not one of my strongest skills.

COGNOiSe administrator

Nope, JavaScript has little in common with SDK. Google up w3schools.