BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[XI 3.1] Business Objects Reports usage through Audit Table


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
srini2019t
Forum Member
Forum Member



Joined: 01 Mar 2019

Posts: 5



PostPosted: Thu Apr 11, 2019 1:52 pm 
Post subject: Business Objects Reports usage through Audit Table

Hi All,

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.

VERY URGENT PLEASE.

Regards,
Sri.
Back to top
bernard timbal
Forum Addict
Forum Addict



Joined: 26 May 2003

Posts: 3908
Location: Paris - FRANCE


flag
PostPosted: Thu Apr 11, 2019 2:04 pm 
Post subject: Re: Business Objects Reports usage through Audit Table

srini2019t wrote:
VERY URGENT PLEASE.


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

Good search

_________________
Bernard TIMBAL DUCLAUX de MARTIN
BusinessObjects Platform Certified Consultant
Image link
(Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Fri Apr 19, 2019 8:52 am 
Post subject: Re: Business Objects Reports usage through Audit Table

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.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0273 seconds using 17 queries. (SQL 0.0024 Parse 0.0008 Other 0.0240)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo