COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Steve on 05 Feb 2007 03:52:46 PM

Title: [Solved] Display Cube date in the report
Post by: Steve on 05 Feb 2007 03:52:46 PM
I have a report running from a cube. The objective is to display 'Last updated on 2/4/2007 12:31 pm' in the report. So the user would know how recent is the data.

Is there a way to display the date and time of cube update?

Thanks,
Steve
Title: Re: Display Cube date in the report
Post by: sir_jeroen on 06 Feb 2007 04:02:13 AM
have you thought of creating a simple dimension in which you put the create date?
Title: Re: Display Cube date in the report
Post by: MDXpressor on 06 Feb 2007 08:55:57 AM
Try this Knowledge Base Document:Ã,  1027581.1.Ã,  It is an ASP script to give you the Cube Refresh Date.

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=124103
Title: Re: Display Cube date in the report
Post by: Steve on 06 Feb 2007 03:52:31 PM
Thanks RNA and MDXpressor. Appreciate it !