Creating Custom Audit reports in Webi - which report has been used

[amadese]

Hi,

I would like to use the Auditing universe installed with the module Auditing of our BI4 instance.

My goal is to generate a report allowing to know which reports have been executed / created and updated during the 2 last years (name of the report / location folder / the action [edit – create – run] / the user name who does the action and the universe used by the report).

I'm lost in the universe and I don’t know clearly how to use it (which fields to use for getting these information).

Could you please help me with that ?

[ayman_salem · Accepted solution]

see matthew.shaw's blog

Unlock the Auditing database with a new Universe and Web Intelligence Documents for BI4.1/BI4.2

[amadese · Accepted solution]

The Auditing database is already unlocked. I have access to data. But I don't know how to use the universe and the different objects for retrieving data that I want. Could you help with that ?

[ayman_salem · Accepted solution]

There are many Auditor WebI reports that you can download and import into your system.

(See download link on mentioned blog)

[amadese · Accepted solution]

Where can I find them ?

[ayman_salem · Accepted solution]

See download link on mentioned blog

..

and from KBA 2793147 - Where can I download the BI Platform Auditing Universe and Reports

[amadese · Accepted solution]

Hi,

After analysing the objects and data into the universe, I don't find the objects corresponding to the last execution of a report. Do you have any idea about that ?