I would like to know the information about universes and the corresponding reports, report access/ refresh dates by the users. I am not sure whether Auditor is installed/ configured in the system.
We are using SQL server 2005 for BO repository. And also I didn’t find DSN for Audit database.
Can anyone please help me:
How to find out whether is installed and configured.
XI 3.1 is already installed and running. Is Auditor a seperate tool to be installed or can it be configured using CMC.
The Auditor tables are created when you define the connection during the installation. Thereafter you activate audit events to be logged via the respective Auditing option on each server in the CMC.
If you go to the CCM and click on your servers - you should be able to see via the Auditing tabs if you have any auditing enabled.
The Auditor connection is ODBC so just check on your server if such a connection has been defined or go to the CCM tool on the server, right click Properties on the SIA and look at the Configuration Tab.
If no auditing connection is listed, stop the SIA - this will un-grey the icon on the top toolbar for the Auditing Connection - use this to define your connection (requires a pre-created ODBC conection).
Restart the SIA / System.
Go to CCM - click on each server and if it has an Auditing Tab, use this to select what you want audited.
Then - on the server - go to:
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples
There should be a BIAR package - import the reports.
The Activity Universe needs to have an Activity connection defined - same details as the Audit connection. Export to CMS.
Note:
We had no SESSION details available until I edited ALL the connections and removed joins related to TYPE = 10.
Not sure if this is wise, but it worked for me.
Hi,
Thank you and I am in confusion from where to start.
COuld you please let me know the sequence of sterps for setting up auditing and activity universe.
If you set up auditing when you installed BusinessObjects Enterprise, your auditing database is already configured and has established a connection with the Centeral Management Server (CMS).
If you did not set up auditing when you installed, you must configure all your SIA to connect to an auditing database.
1/ Open CCM (Central Configuration Manager) 2/Stop SIA (Server Intelligence Agent) 3/Click Specify Auditing Data Source (Icon on the Top row of the CCM)
You will be prompted to select a database driver. 4/ Specify the connection method
Selected SQL Server ODBC, the Windows “Select Data Source” dialog box appears. Select the ODBC data source that you want to use as the auditing database and click OK (or click New to configure a new Data Source Name). Use only System DSN. 5/ When prompted, provide your Database credentials (Use different logon credentials. Do not use logon credentials used CMS System Database) and click OK. 6/Start the Server Intelligence Agent. When the CMS starts it will populate the database with the required auditing tables. Note: You can also configure the auditing database using the Properties option for the “Server Intelligence Agent”. Stop the agent, select Properties, and then go to the Configuration tab. Select Write server auditing information to specified data source and click Specify.
7/Start the Designer application and through file open navigate through below path and open the Activity Universe.
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples\universe\sqlServer 8/ Create and Provide the Activity Universe connection with relevant data source (Use the same credentials as used while creating Auditing data source (step 7)).
9/ Check the connectivity and export the universe to repository.
Sample Audit Webi Reports:
10/ Locate the Audit Biar file under
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples\auditing_rpt_en.biar
11/Import the reports to Repository using Import Wizard (above BIAR as Source)
There is a table in the Universe named WA_SESSION - this is not connected to any other tables in the Universe. This Table is showing as can’t be found in the database either. The reports are based out of this table. And they give the error. How do we fix that ?
Upon Investigation further I found there are a few issues:
CONVERT(DETAIL.Detail_Text, CHAR) as SESSION_ID - does not do the same thing as expected in Oracle (Don’t know what they had in mind when they developed the SQL.
Also: TIME_TO_SEC(TIMEDIFF(MAX(EVENT.Start_Timestamp) , MIN(EVENT.Start_Timestamp))) as SESN_DURATION_SEC – not supported in Oracle.
These references are mentioned over and over in the reports. I changed the SQL in the derived table and cleaned it up. Then I see the references in the reports too.
Anyone has any experience on how to work around it – basically a quick fix.
Hi Jdrc,
There are 5 database specific Activity universes in the samples area.
If your backend is Oracle then you need to use the Activity universe placed under
Export the new Activity universe(oracle based) to Repo and refresh the reports. Note: I had problem with the Activity universe in Oracle folder as some sample reorts were giving error.
To resolve this, In a Test environment , i have installed BO with Audting enabled while installation. Then i have copied the Activity universe generated against Oracle from test environment to Dev.
This resolved everything. All sample reports are running fine.
Exfdellent Soln: Worked perfectly, just that I didn’t read the last part of the email and sat there repointing each report (31 total) to the new Universe. It always brings in a default Universe with the import of the BIAR File even thought I unchecked it.
All said and done. It works Like a charm right now, except some syntax errors in some of the reports with heavy formatting. Need to take a close look and figure out each error and resolve them.
for point 5.
5/ When prompted, provide your Database credentials (Use different logon credentials. Do not use logon credentials used CMS System Database) and click OK.
is there any specific reason for the the above text in BOLD
Hi Vills,
Its not mandatory , just a recommndation.
The audit database can exist as part of the system database user (CMS database), it is recommended that it be kept separate database user, to minimize the impact on system performance due to the constantly growing size of the database.
May I ask where I could find the file auditing_db_oracle.biar?
My auditing DB is oracle. I copied the auditing universe from
BusinessObjects Enterprise 12.0\Samples\universe\oracle. It returns error on object integrity (incompatible objects)
So I want to get the universe from biar file and make sure the source is clean first
(BOB member since 2002-06-18)
(BOB member since 2002-09-18)
(BOB member since 2006-09-28)
(BOB member since 2007-10-24)
(BOB member since 2009-12-09)
(BOB member since 2008-12-18)