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.
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.
To modify Cognos javascript, I assume you need the SDK. Javascript is not one of my strongest skills.
Nope, JavaScript has little in common with SDK. Google up w3schools.