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.
:)
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.
Thx so much! This did the trick!! :o