Do we have pre-built Audit reports?

[kalpesh_pandey]

Hi, I think I saw pre-built Audit reports in m26.cab for BOXI R2 SP3 but I am not able to find it. I saw it everywhere but could not find this time. Can someone help?

Thanks,

[BasicTek · Accepted solution]

I'm surprised this wasn't published before but try the instructions below

"Open the installation file(.exe file) and select WIN32 folder.

Click on m29 .cab file,

Select auditing_rpt_en.biar. file and import it using Import Wizard.

Select auditing_db_mySql.biar.file of the uinverse and import using Import Wizard.

Default: 28 reports and auditing universe of SQL server database are obtained.

Note: For Business Objects XI R3.0 the path for auditing cab file is <Installation Directory>:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples

and then follow the above steps 3 and 4"

Regards,

Tim

[kalpesh_pandey · Accepted solution]

Thanks for the reply Tim. I could import Reports and Universe but I am having problem in making reports working. When I look into the DB information of the report then it says its connected to Universe Query server with user as "sa" and no password. I am on SQL server 2005. I could get to Activity Universe. I did define a new system DSN and change the universe connection from parameter to this newly created connection. I could browse data in universe.

Are these crystal reports are built on Universe or I have to take these out from Object package and make each of one working?

Thanks

[BasicTek · Accepted solution]

In that case you may need to open a case with the admin or webi team (depending on where the problem is). I don't actually have any experience using the audit reports just found the note

-Tim

[kalpesh_pandey · Accepted solution]

Thanks, I am the Admin. I have to make the Reports working. One was is to open each report and change the universe connection which is very lengthy Process.

Thanks,