Need WEBI usage statistics

[Former Member]

My Requirement

Need details of all WEBI reports built on a particular universe along with the # of time the report is executed(either run/ refreshed etc..)

I have tried standard audit report - but they time out or retrieve no data

I also have query builder option if someone can give exact syntax

I also have activity universe access if someone can exactly tell what to do?

O/P needs be as below

Report Name | Report Folder Path | Universe Name | No. of times executed | Last executed date/ time

[former_member182521]

Hello Vishal,

We are yet to hear from you on BusinessObjects version?

Thanks

Mani

[Former Member]

BO - version 3.1

[Former Member]

Look at Mani's blogs,you may find what you are looking for. But for # time report executed , you cannot get the data from query builder. You have to use Audit Universe, or you can run the queries on Audit DB to get the details.

[Former Member]

I have reviewed mani's blog but would be great if I can get more specific query for this req?

Also the audit reports dont seem to return data or is throwing error.

Can you be specific which objects to use in audit universe and what filters?