Queries related to Auditing

[Former Member]

Hi All,

We have BO XI 3.1 sp2 FP 2.6 installed on our windows environment enabled for auditing.

After looking at the default auditing reports and the Activity universe, I still could not find answers for these queries:

1.We use u2018Schedule foru2019 option to run webi reports on behalf of some end user(SAP BW users). Report gets failed quite a few times for some users due to one or other error. I need an audit report showing details like u2018for which user it failedu2019 and u2018cause of failureu2019 etc. But, I could not find any such fields in u2018activityu2019 universe that could pull such info from audit database. Moreover if I take u2018user nameu2019 in my report it merely shows the scheduler name who had actually scheduled report on behalf of other users. As exporting scheduling statistics from instance manager is not possible so having such audit report would be a great help.

2.Another audit report that we want to create is related to scheduled instances. Is there a way we can show who actually viewed the instance created by a successful job.

3.It seems that s auditing is not supported by Xcelsius dashboards ,can usage of such dashboards be tracked by any other means.

Thanks in advance.

-Chandra

[Former Member]

You can find a lof of information in the BOE XI 3.1 admin guide (chapter 14) around auditing. It will also describe the default audit reports and provide details on the structure and available objects of the audit universe.

Regarding Xcelsius: You need SP3 to get auditable services for Xcelsius (only for QaaWS based dashboards). You can find more info in the What's new document of the SP3 release.

Hope this helps...

Martijn van Foeken

Focuzz BI Services

http://www.focuzz.nl

http://nl.linkedin.com/in/martijnvanfoeken

http://twitter.com/mfoeken

[Former Member]

Thanks Foeken.

I had already gone through the auditing chapter before putting these queries .

But, I could not find the answer for point 1 and point 2 based on whatever default audit reports we have in the system and whatever documentation I have read so far. Iu2019ll really appreciate if anyone can provide comments on these two points.

For xcelsius auditing Iu2019ll check sp3 whatu2019s new and find out the details.

Thanks,

Chandra

[Former Member]

Regarding question 1: There is no audit record that records on behalf of which users you have scheduled. Only the actual user account used to create the schedule (and is used to execute the event) is captured. A workaround could be is to schedule the report(s) for each individual user account by logging in and creating a schedule. Then it should be possible to capture which jobs have failed, because each job is then audited individually. Another workaround might be to query directly against the CMS database where each failed instance gets an entry with some properties captured. I guess it might also capture (and display) the reasons for failure. If you would go into the CMC you can see the failed instances and click on them to view the properties. This information is captured in the CMS database and not in the Audit database.

Regarding question 2: It might be possible to gather that information based on the CUID of the instance. After all, each object has a CUID. Have a look at Event_Type_ID 458753 op page 637 of the Administrator's Guide. Here you can recall the object instance via code 90.

Hope this helps...

Martijn van Foeken

Focuzz BI Services

http://www.focuzz.nl

http://nl.linkedin.com/in/martijnvanfoeken

http://twitter.com/mfoeken

[Former Member]

Thanks again for all these workarounds.

Finally I have a query for query builder which I can use to see all failed instances along with the error details:

select SI_NAME, SI_OWNER,si_cuid, SI_STATUSINFO from CI_INFOOBJECTS where SI_SCHEDULEINFO.SI_OUTCOME>=2 and SI_SCHEDULEINFO.SI_STARTTIME='2011-01-05'

But, for the next question I am still struggling to find out an audit report to show who has actually viewed different instances created by a schedule.

There is a default report called u201CDocument Scheduling and Viewing Statusu201D but that only displays report name with its viewer and What I need is instance and its viewer.

Thanks,

Chandra

[ofir_gil]

There is a product from APOS Systems that will let you audit Xcelsius. You can even audit the usage of areas within your dashboard or setup auditing of various events within your dashboard. http://www.apos.com/content/content.aspx?content=apos-insight

The same product also extracts other audit information about your instances and schedules.