COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: konesens on 16 Oct 2013 06:04:46 PM

Title: Display time when report will be available
Post by: konesens on 16 Oct 2013 06:04:46 PM
Hello guys,

Let's say a report run during 4 houres before being published. If I start the report at 1pm it won't be available until 5pm . So I would like to display an information page saying to consumers the report will be available a 5pm.

Can I get data from Cognos Administration ?

Thanks for your help
Title: Re: Display time when report will be available
Post by: sir_jeroen on 17 Oct 2013 01:30:23 AM
Nope... Not possible...
Title: Re: Display time when report will be available
Post by: wyconian on 18 Oct 2013 09:03:44 AM
going bacl to basics you shouldn't have a report that runs for 4 hours!
Title: Re: Display time when report will be available
Post by: konesens on 20 Oct 2013 03:58:12 PM
actually the report run in less than an hour but again is there any way to display a message when consumers log in during report execution ?
thxs
Title: Re: Display time when report will be available
Post by: wyconian on 21 Oct 2013 01:58:49 AM
There's no way to tell the users how long the report is going to run for but if you know an average run time you could dispaly a meassage when the user runs the report saying something like

'the report typically runs for 30 minutes.  The estimated time the report will be available is 14:32' 

You can get the estimated completion time by using one of the built in time functions (think it's called now) and adding the average run time to it.

You can display the message as a text item on a page before the main report page or maybe een as a prompt page.

Good luck
Title: Re: Display time when report will be available
Post by: konesens on 23 Oct 2013 08:01:09 PM
Thanks guys , we did display a first report with a message using the 'as of time' function
then run the main report and then masking the first report.