вторник, 16 июля 2013 г.

SAP BO 4 Audit universe and reports

By default SAP BO 4 hasn't audit reports and universe, but kind people allow us to download it from SAP.

Sample Auditing Universe and Reports for SAP BusinessObjects 4.0. In SAP BusinessObjects 4.0 auditing database schema was changed, improved. The attached sample auditing universe and reports may help you started in the process of developing custom auditing reports for SAP Business Objects 4.0. The reports and the universe are not supported by SAP. They are provided as-is, and for the purposes of being used as a starting point in the process of developing your custom auditing universe and reports.


SAP BO 4 Adaptive Processing Server sizing


By default, the installation routine deploys an 'out-of-the-box' configuration, where the APS hosts ~20 services simultaneously.
All services run on a single java APS instance, with a maximum java heap size allocation of 1Gb RAM.


  • Adaptive Connectivity Service
  • BEx Web Applications Service
  • Client Auditing Proxy Service
  • Custom Data Access Service
  • Data Federation Service
  • Document Recovery Service
  • DSL Bridge Service
  • Excel Data Access Service
  • Lifecycle Management ClearCase Service
  • Lifecycle Management Service
  • Monitoring Service
  • Multi Dimensional Analysis Service (MDAS)
  • Platform Search Service
  • Publishing Post Processing Service
  • Publishing Service
  • Rebean Service
  • Security Token Service
  • Translation Service
  • Visual Difference Service
  • Visualization Service
  • Web Intelligence Monitoring Service


For best performance and scalability, SAP recommends that you host important services in multiple dedicated APS containers, and then adjust the sizing parameters to answer the different memory/processor requirements. This is considered a Consulting activity.

At a minimum, it is advisable to create an Adaptive Processing Server relating to each of the main six processing categories:


  • Core Services,
  • Analysis Services,
  • Connectivity Services,
  • Data Federation Services,
  • Lifecycle Management Services,
  • Web Intelligence Services.


However, the SAP BusinessObjects Enterprise Administrator’s Guide and Sizing Companion Guide also recommend to separate the following APS services:


  • MDAS service (for Analysis OLAP),
  • DSL Bridge service (for .UNX),
  • Visualization service (for CVOM charting),
  • Monitoring service (CMC application), 
  • Auditing service.


As a starting point for large enterprise deployments, these guidelines should be taken further. Below is a more complete example of how each APS container could be configured.

By default, the -Xmx Java Heap Size (in each Server's start-up command line properties) is set to 1g (1GB of RAM).
These Java Heap values are flexible, and should be increased/decreased on an ad-hoc basis, depending on requirements (guideline indications are given below).
In the case of DSl_Bridge and MDAS the recommended heap size is 4 GB minimum; with 6-8 GB or better preferred. These settings depend on the size and number of concurrent queries at a time.
Data Access DSL  (-Xmx4g -> 8g)


  • DSL Bridge Service
  • WebI Monitoring Service
  • Security Token Service
  • TraceLog Service

MDAS OLAP Analysis  (-Xmx4g -> 8g)


  • Multi Dimensional Analysis Service
  • TraceLog Service

BEx WAD  (-Xmx2g -> 8g)


  • BEx Web Applications Service

Data Access Other (-Xmx2g -> 4g)


  • Adaptive Connectivity Service
  • Custom Data Access Service
  • Excel Data Access Service
  • Rebean Service
  • TraceLog Service

Life Cycle Manager  (-Xmx2g -> 8g)


  • Lifecycle Management ClearCase Service
  • Lifecycle Management Service
  • Visual Difference Service
  • TraceLog Service

Auditing  (-Xmx1g -> 4g)


  • Client Auditing Proxy Service
  • TraceLog Service

Publishing  (-Xmx1g -> 4g)


  • Publishing Post Processing Service
  • Publishing Service
  • TraceLog Service

Multi Source Federation (-Xmx2g -> 8g)


  • Data Federation Service
  • TraceLog Service

Monitoring (-Xmx2g -> 8g)


  • Monitoring Service
  • Document Recovery
  • TraceLog Service

Platform Search  (-Xmx2g -> 8g)


  • Platform Search Service
  • TraceLog Service

Translation (-Xmx2g -> 4g)


  • Translation Service

CVOM Charting (-Xmx2g -> 8g)

Visualization Service
This approach will result in improved response times and larger throughput, but at the expense of higher overall memory utilization on the platform due to the increased number of Java Virtual Machines (1 per APS).

Benefits will include:

Performance, Stability and Scalability
Isolated workflows for easier troubleshooting (i.e. focused TraceLog and Monitoring)
Ability to turn-off specific features without requiring downtime

SAP BO 4 How to check Support Pack or Patch level of SAP BusinessObjects BI Platform 4.x in UNIX/Linux environments?


Solution 1:

Run command cd <BOE_INSTALL_DIR>/ i.e. cd /apps/sap/bi4
Run command modifyOrRemoveProducts.sh and see the Support Pack level

Solution 2:

Run command cd <BOE_INSTALL_DIR>/InstallData i.e. cd /apps/sap/bi4/InstallData
Run command more inventory.txt and see the full version including Support Pack and Patch level

SAP BO 4 Audit database doesn't work

After installing SAP BO4 on rh, i found that audit db doesn't work.
I found solution:


1. As root execute the following steps:
cd <db2_install_directory>/sqllib/security
chown root:root db2ckpw
chown root:root db2chpw
chmod u+s db2ckpw
chmod u+s db2chpw

2. cd <db2_install_directory>/sqllib/security64
chown root:root db2ckpw
chown root:root db2chpw
chmod u+s db2ckpw
chmod u+s db2chpw

3. Ensure each of these files has execute rights
4. Restart the db2 database (db2shutdown.sh, db2startup.sh)
5. After verifying the connectivity, you can execute the following commands:

su - <bi4user>
./sqllib/db2profile
db2 connect to AUDBOE14
db2 create bufferpool USERBP_8K SIZE 150000 pagesize 8K
db2 create user temporary tablespace USERTEMP_8k pagesize 8k managed by  automatic storage extentsize 32 overhead 10.5 prefetchsize 32  transferrate 0.14 bufferpool USERBP_8K
db2 create large tablespace  USERSPACE_8k pagesize 8k managed by database using \(FILE  \'/usr/sap/SBT/SBT/NODE0000/AUDBOE14/T0000003/userspace_8k.LRG\'  115200\) extentsize 32 overhead 12.67 prefetchsize 32 transferrate 0.18  bufferpool USERBP_8K
db2 disconnect

6. configure Auditing from CMC.

SAP BO 4 Error: cancelling statement due to user request (IES 10901) (WIS 10901)

I refreshed report and got error:



The reason of this error is  query limits. When you are creating reports you have to check universe parameters -> Controls where you should set limits. 

In my case i have to change limit execute time because refresh time of my report is more then 10 minutes.