view audit reports..

[#1]

hi,

I have few queries in regards to Audit reports..Before that my environment is

Unix SOlaris 10.2 (clustered with another box so 2Unix containers / Oracle 10.2 / BO XI 3.1)

1. I have enabled Auditing on both of the boxes but how do i figure it out if the auditing is acutally enabled.

I did enable Audit features for the servers that i want to be audited but still how to confirm this ?

2. Do I need enable auditing by going under each Crystal report under Audit folder and tick the box ?

3. I loaded ORACLE_AUDIT_BIAR file on server and then loaded the AUDIT_EN_BIAR files > this created an AUDIT folder and I can view all sections under it.

4. Will change the parameter for Acitivity Universe to point to my ORACLE DB... But i guess in doing so the option of DefaultBOAuditingDB will go away and get replaced by my ORACLEDB ?

5.How do I get more information on the metadata Schema of CMS (SI_infoobjects6 etc..) I tried to lookup and find any documentation which would say detail descriptions on what each table means but in vain.?

6. I just need 3 main Audit reports >>

a. Find the START TIme of the Report when Run and End TIME of REport when it finished populating records.

b. Find the number of Lines populated in the report after it has run ?

c. FInd the size of the report after it has run ?

How to go about just these 3 reports ?

please advise,

regards

[Former Member]

Hi,

I have few updates on your question.

Let me explain about my information.

we are on 4.0 SP2 and Oracle DB and we have all BICS adhoc reports.

1. Through oracle db we cant find the report execution time as simple as by considering start time and end time. We need to consider view, refresh, prompt, retrieve events to get approximate time of report execution time. But we have too may bugs in those.  ADS not able to capture correct event time like we see view, retrieve, prompts Event Duration as "0". Even SAP able replicate the issue on their end. They are in the process of analysis with Development team.

2. We see event duration for refresh but it shows as MS but in reality it should be Seconds. SAP confirmed it as bug, I am waiting for ADPT number.

3. Event Start time works perfectly in IDT but when I use the same dimension in webi reports it gives wrong data, SAP able to replicate the same issue on their end. waiting for ADPT number.

finally i can clear say that we can not get the report execution time if we have BICS reports as ADHOC based, but we can get the report execution time only if reports are sechule. Run event gives an complete time.

I went through a hard time to make sap to replicate the issues on there end. Now SAP accepted that they see same issues with few other clients too.

[Henry_Banks]

Hi,

I would be interested to know more. 

Please quote your OSS  and any ADAPT you may be tracking for this issue specifically.

Regards,

H