Its possible to pull the below columns to create an Business objects report (DESKI/WEBI) by using BO Audit Database or Audit Universe.
1.Report Type
2.Report Name
3.Universe Name
4.Folder Path
5.Created Date = when was the BO report created?
6.Created By = who created the BO report?
7.Last Run Date = when was the BO report last run?
8.Last Run Date by Whom = who ran the last run?
BO Version - BO XI 3.1 SP 5 and Audit Database - Oracle 11G
From column 1 to 4 - Its possible I know , From 5 to 8 - How we can pulled from Audit DB . From Audit table as we all know that have only one date field called Start timestamp and there is no columns like Created Date,Created By,Last Run Date,Last Run Date by Whom…
How we can achieve this requirements?
Please share me the if you have any SQL Query or any other tips also appreciated.
We are not the official SAP techsupport helping you and our free time so be patient and avoid such words…
Audit will only give you the reports used by people. By example, if your repository has 100 reports and only 10 have been accessed by users, the audit will only display you 10, not 100. If you want to have the whole list of reports and not only the one accessed, you need to query repository using query builder. You will find in the SDK sections a lot of post explaining how to use query builder and to automatize such extraction using Excel / VBA or Java
The only way to get this information with the BOBJ version that you have is through writing a program that uses either the .NET or Java SDK because the information you need is stored in the CMS database.
If you were on 4.2 SP4 or newer, you could get the info through the new “BI on BI” universe and CMS database connector.
(BOB member since 2003-05-26)
(BOB member since 2007-04-16)