Skip to Content
0

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

Dec 19, 2017 at 05:07 PM

76

avatar image

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

https://answers.sap.com/questions/66808/data-load-status-for-sap-bw4-hana-optimized-infopr.html 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 -

RSRREPDIR, RSOOBJXREF , RSPMDATAPID

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

Thanks,

Teena

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Erdem Pekcan Dec 22, 2017 at 01:44 PM
0

Hi,

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: https://blogs.sap.com/2013/10/31/bw-cube-last-update-date-in-bo-dashboards/

Regards,

Erdem

Show 1 Share
10 |10000 characters needed characters left 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!

0