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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Author 10.1.2 (Dim. Hier.) Showing Every Thursday

Started by gosoccer, 16 May 2014 12:03:48 PM

Previous topic - Next topic

gosoccer

Folks,

I have a requirement to show on the first page of the report the date in which relates to
a cube refresh that occurs every Thursday.  One of the option is to have the Report Author
to generate this date automatically for every Thursday and show it as a Parameter on the
first page of the report.

if anyone has done this in the past and could share the code or approach with me, I'll
greatly appreciate it.

Thanks in advance for your time.

:)


adam_mc

Drag on a Layout Calculation, then select CubeDataUpdatedOn ([YOUR HIERARCHY]) from Report Functions.

This should always display the date/timestamp of the last time the cube was updated.

Hope this helps.
Adam.

gosoccer