Refreshed date and Refresh by in Webi

[former_member208716]

Hello Experts,

Using SAP BO 4.1 Environemnt.

1 ) Need to get the 'Last Refreshed Datetime" and "Last Refreshed By" information of list of reports in a separate report. Checked in Auditing universe but unable to find any useful information. Please anyone help on this.

2) Is there any option to get the last refresh (manual refresh) in query builder ?

Thanks,

LKumar.

[former_member554641]

Last Refresh Date

=If DocumentPartiallyRefreshed() Then "PARTIAL RESULT" Else FormatDate(LastExecutionDate();"MM/dd/yy h:mm a")

Refresh Duration

=FormatNumber(Floor(Abs(LastExecutionDuration())/3600);"00")+":"+FormatNumber(Floor(Mod(Abs(LastExecutionDuration());3600)/60);"00")+":"+FormatNumber(Mod(Mod(Abs(LastExecutionDuration());3600);60);"00")

For the user perhaps use:

=DocumentAuthor()

=DocumentOwner()

=CurrentUser()