cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA views usage

Former Member
0 Kudos

Hi Experts,

I am having Analysis office reports created on SAP HANA views and I want to know how many times a user ran the report. Basically I am looking at the report usage.

Please let me know if there is way to get how many time a view is called and who is the user , if possible with runtime data.

Thanks,

Guna

Accepted Solutions (0)

Answers (4)

Answers (4)

You can check/create audit reports in BO to find the report usage.

Former Member
0 Kudos

Hi Avijit,

Thank you very much, Kindly let me know how I can do this BO.

Thanks,

Guna

Former Member
0 Kudos

Thank you.

But issue is I am having report build on different data sources but all of them are running on Analysis office (HANA, BW, ECC). my cetralized reporting in analysis office based on Business objects.

Is there way I can find how may times these report are executed in analysis office.

Currently we are in BI4.1 SP4 and our database is SAP Sybase ASE RT 16.0.02.05.

Kindly advise me how find report usage.

Thanks,

Guna

former_member182521
Active Contributor
0 Kudos

You may required to deploy the Audit reports from below to get the required metrics for you.

https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligen...

lbreddemann
Active Contributor
0 Kudos

Besides the auditing functionality, there is no reliable way to see how often and by whom a view has been used.

For runtime data, you can check the expensive statements trace and the shared sql cache.

Maybe worth noting is that the concept of "a report" doesn't exist in HANA.

Instead, it deals with queries (and those are not 1:1 to reports).

Former Member
0 Kudos

Thank you, as we are running these reports. do we have anything BO to find the utilization of the reports.

lbreddemann
Active Contributor
0 Kudos

With BO you should be able to monitor report usage. But I'm no expert in BO (client tool to me), so rather ask someone who is...