Skip to Content
0

SAP HANA views usage

Dec 19, 2016 at 04:35 AM

254

avatar image
Former Member

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

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

4 Answers

Avijit Dutta Jan 06, 2017 at 07:04 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Avijit,

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

Thanks,

Guna

0
Lars Breddemann
Dec 19, 2016 at 06:03 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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...

0
Manikandan Elumalai Jan 10, 2017 at 09:35 PM
0

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-intelligence-documents-for-bi41/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 14, 2017 at 07:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded