By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Business Objects Auditing in XIR3
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > Business Objects Auditing in XIR3
Business IntelligenceData Warehousing

Business Objects Auditing in XIR3

Editor SDC
Last updated: 2009/04/07 at 9:28 AM
Editor SDC
6 Min Read
SHARE

BusinessObjects Enterprise Auditor provides you with a way to monitor and record key facts about your BusinessObjects Enterprise deployment.

More Read

SAP Executive Q&A – #sapteched09

bip1

The information provided by the auditor answers the following queries

  • Who is using your Business Objects Enterprise system?
  • Which objects they are accessing?
  • Which groups within the company use our BusinessObjects Enterprise system the most?
  • How many concurrent user licenses are we using at any given time?

Auditor also allows you to better administer individual user accounts and reports by giving you more insight into what actions users are taking and which reports they are accessing.

Configuring Auditor in Windows

Once you configured the CMS Repository then the next step is to configure the Auditing database.

The audit database can be configured in the same CMS Repository. The Repository will have the following tables gets created in the Database.

  • CMS_Aliases6
  • CMS_IDNumbers6
  • CMS_InfoObjects6
  • CMS_Locks6
  • CMS_Relations6
  • CMS_VersionInfo

Auditing Tables

  • Audit_Event
  • Audit_Detail
  • Server_Process
  • Detail_Type table
  • Event_Type
  • Application_Type

Configure Auditing in UNIX Platform

  1. Run the script CCM.SH to stop the CMS
  2. Run CMSDBSETUP.SH
  3. Choose the “SELECTAUDITOPTION”…

BusinessObjects Enterprise Auditor provides you with a way to monitor and record key facts about your BusinessObjects Enterprise deployment.

The information provided by the auditor answers the following queries

  • Who is using your Business Objects Enterprise system?
  • Which objects they are accessing?
  • Which groups within the company use our BusinessObjects Enterprise system the most?
  • How many concurrent user licenses are we using at any given time?

Auditor also allows you to better administer individual user accounts and reports by giving you more insight into what actions users are taking and which reports they are accessing.

Configuring Auditor in Windows

Once you configured the CMS Repository then the next step is to configure the Auditing database.

The audit database can be configured in the same CMS Repository. The Repository will have the following tables gets created in the Database.

  • CMS_Aliases6
  • CMS_IDNumbers6
  • CMS_InfoObjects6
  • CMS_Locks6
  • CMS_Relations6
  • CMS_VersionInfo

Auditing Tables

  • Audit_Event
  • Audit_Detail
  • Server_Process
  • Detail_Type table
  • Event_Type
  • Application_Type

Configure Auditing in UNIX Platform

  1. Run the script CCM.SH to stop the CMS
  2. Run CMSDBSETUP.SH
  3. Choose the “SELECTAUDITOPTION” and then supply the requested information about the database server (Ex: Oracle, SQLServer or MYSQL) where you want to configure the Audit DB.
  4. Run SERVERCONFIG.SH
  5. Choose the “MODIFY A SERVER” Option
  6. Select the CMS and Enable Auditing. Enter the port number of the CMS when prompted (You can use the default port 6400)
  7. Use CCM.SH to start the CMS, when the CMS Starts then it will create the auditing database in the given DB Server.
  8. In a CMS cluster, the cluster will nominate one CMS to act as system auditor. If the machine that is running this CMS fails, another CMS from the cluster will take over and begin acting as auditor.

Auditing Database Schema

BusinessObjects Enterprise Auditor provides you with a way to monitor and record key facts about your BusinessObjects Enterprise deployment.

bip1

Auditing Tables

The Audit database contains Six tables:-

  • Audit_Event
  • Audit_Detail
  • Server_Process
  • Detail_Type table
  • Event_Type
  • Application_Type

Audit_Event:-

The Audit_Event table stores one record per action that is audited and

Contains general information about each audit event

Audit_Detail:-

The Audit_Detail table records more details about each audit action recorded in the Audit_Event table. For example, when a user logon fails, the reasons for that failure are recorded as audit details. There may be more than one record in this table for each audit action

recorded in the Audit_Event table.

Server_Process:-

The Server_Process table contains information about the servers running within your BusinessObjects Enterprise system which can generate audit events.

Event_Type:-

The Event_Type table contains a static list of the kinds of events that can be audited in your BusinessObjects Enterprise system. This table provides information roughly equivalent to that provided by AuditIDs and AuditStrings in Crystal Enterprise

Application_Type:-

The Application_Type table contains a static list of the applications that can produce audit events. In BusinessObjects Enterprise XI, the applications that can be audited are servers.

Detail_Type table:-

The Detail_Type table contains a static list of the standard details that can be recorded about audited events. For example, a user logon can fail for a number of different reasons. These reasons are listed as entries in the

Once the tables are created, we need to enable the auditing features through Central Management Console.

Logon to CMC->Go to Server->Click CMS

pic11

Select the Audit events for the CMS Server.

pic21

Build the sample universe based on the auditing database

pic31

Sample reports created to track the users.

pic32

TAGGED: business objects
Editor SDC April 7, 2009
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

smart home data
7 Mind-Blowing Ways Smart Homes Use Data to Save Your Money
Big Data
ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics
data breaches
How Hospital Security Breaches Devastate Local Communities
Policy and Governance

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

SAP Executive Q&A – #sapteched09

5 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?