Audit configuration for BI 4.1 with Oracle database

[former_member182521]

As we already know the Audit universe and reports needs to be deployed manually in BI platform as it is no longer out of box functionality in BI 4.x. For BI 4.0 Auditor configuration, I have already written a blog here http://scn.sap.com/community/bi-platform/blog/2013/01/07/sap-businessobjects-40-auditor-configuratio...

The difference between earlier blog and this blog is the deployment method. In BI 4.0 the Auditor will be configured by extracting from the file system (.unx universe & Crystal reports) but where as in BI 4.1 SPx we do have the LCMBIAR file which holds the required universe and reports. Please continue reading the blog for step by step procedure to configure auditor.

You can download all the required universe and reports from the document here http://scn.sap.com/docs/DOC-53904

and make sure you enabled Auditor in CMC.  Refer here BusinessObjects Auditing - Considerations & Enabling

You need to select the appropriate .unx file according to your database middleware. Since I am going to deploy it in Oracle database I validated the supported Oracle client installation and the corresponding TNSNAMES.ora file with the Audit database service entry.

In order to import the LCMBIAR content, we are going to use command line batch file (LCM_CLI.bat) with .LCMBIAR file and a property file with import parameters.

Sample properties file

------------------------------------------------------------------------------------

Auditing.properties

------------------------------------------------------------------------------------

action=promote

importLocation=<biar_folder_path>\OracleAuditing.lcmbiar

LCM_CMS=<hostname>:<port>

LCM_username=Administrator

LCM_password=<password>

Destination_CMS=<hostname>:<port>

Destination_userName=Administrator

Destination_password=<password>

includeSecurity=false

exportDependencies=false

consolelog=false

------------------------------------------------------------------------------------

Run the LCM_CLI.bat file with the property file as a parameter something like below

The import status

Once the BIAR file is imported successfully, we need to modify the universe connection in such a way that it points to the right audit schema.

Furthermore, Create a Project in Information Design Tool and import the universe.

You should have Adobe flash player 11 or higher to launch the crystal reports from BI Launchpad.

Here is the deployed report for you.

Here are some of the blogs related to Auditing

BusinessObjects Administration - Audit reporting vs Metadata reporting

BusinessObjects Auditing - What is changed in BO 4.0?

BusinessObjects Auditing - Considerations & Enabling

BusinessObjects Administration - Extending capabilities of BI 4.x Audit reporting

Hope this could help people who are looking for BI 4.1 audit configuration. Thanks for reading!