Skip to Content

Refreshed date and Refresh by in Webi

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 24, 2018 at 04:24 PM

    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()

    Add comment
    10|10000 characters needed characters exceeded