Skip to Content

BW Data Refresh Date In Webi Report in BW7.5 on HANA

Hello All,

How Can we get the BW Data refreshed date in the Webi Report?

Sorry this question is been asked few times, but as this is 7.5 on HANA not sure statistics method does work ,and I can't find composite provider information from any of these tables rsdcubemulti and rsmonicdp ?

I did find few tables as per the blog but how can I get this to each Webi report ? one way I found is exit variable ; but how can I catch the CompuID/query name in the run time

these are the 3 tables that I can join -


shame that there is no straight forward method like how we see Infoprovider 'Last Refreshed' in the Bex Analyser.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 22, 2017 at 01:44 PM


    BO 4.2 provides this information by default (SP3 and onwards I guess.). You can use following function to get the data status information.

    =QuerySummary([Query 1];StatusOfData)

    There're several workarounds as well. A sample how-to can be found here:



    Add comment
    10|10000 characters needed characters exceeded

    • Sorry for the delay ! This is the one exactly I'm looking for ! easy and very simple only thing is I need to just keep "BW Status of Data" and Strip out the other information - need to find a way to do it.

      great!! Thank you very much!