SDN Articles - BW Administration

List Of Articles:

The documents in this section answers most of the questions related to Administration in SAP BI/BW.

i) Aggregates:

The following documents give overview of when to create and how to create aggregates and also how the performance improvement will happen due to aggregates.

Illustrated Step-By-Step Guide to Performance Optimization using Aggregates in SAP BI

Backend Performance Improvement Measures in BI

ii) Authorizations: 

This section tells about how analysis authorizations works, how to create them and how analysis authorizations works at report level.

Analysis Authorization Using Variable Exits

BI 7.0 Reporting Authorization based on Characteristic Value Level

SAP BI Analysis Authorization (Customer Exit Variables)

iii) Attribute Change Run (ACR):

What is Attribute Change Run, Advantages, back end operations of Attribute Change Run and how to run the Attribute Change Run. 

Attribute Change Run (ACR) Performance Optimization and Forceful Completion

SAP BW Hierarchy Attribute Change run Management

iv) DSO Administration:

This section explains about the different parameters in DSO Administration, how to check the DSO Activation job log and also gives information on step by step procedure of selective deletion in DSO.

Database Statistics During ODS Activation

DSO Job Log and Activation Parameters

Step By Step: the Process of Selective Deletion from a DSO

v) Info Cube Administration:

This section provides information about different operations that we perform on infocube: 

i) Compression ii) Roll Up, how to do LISTCUBE and also explains about indexes in Info Cube.

All about Compression

Downloading InfoProvider Metadata to Excel

Dynamic Selective Deletion from Infocubes

SAP BI – Compression Status for Infocubes

SAP BW – Infoprovider Data Display (LISTCUBE) - Improvised

Understanding the Bit-Map

vi) Miscellaneous:

This section gives overview of the daily activities that we perform in normal BI systems:

a) Lock Entries
b) Decommission of specific objects and how to find inactive objects in BI system
c) How to perform where used list on different objects
d) PSA and Change log deletions
e) How to manage jobs in SAP BI

About Lock Entries and Lock Table Overflow

Automated Approach to Find the Where Used List of an Event in SAP BW

SAP BI Performance Tuning Activities

Decommissioning of BW Objects

How to Automate a File Movement to and from SAP BW using a Program

How to Find the Where Used List of Query Restrictions

How to Fix Inconsistencies in SAP BEX Tables

How to Repair Master/Transaction Data Load Error Due to tRFC Stuck

How to Update the Currencies and Unit of Measurements from ECC Source System to BI System by Automatically and Manually

Inactive Objects Checker in BI 7

Managing Jobs

Performance Optimization of Long Running Queries Using OLAP Cache

SAP BW - PSA/Change Log Deletion Governance

Step by Step Approach to Find the List of Inactive Objects in SAP BW

Step by Step Approach to Handle Large Files in SAP BW

Step by Step Procedure to Copy BW Workbook from One user's Favorites to Other

Validity Table in SAP BW/BI

vii) Process Chains:

This is the most important part in SAP BI Support Projects. This gives information of:

a) Process chains creation

b) Different Process types available
c) Alerts creation in Process chain
d) Decision steps in Process chain
e) Process chains monitoring and frequent issues we face and lot more

APD Inclusion in Process Chains - A Step-By-Step Guide

Automatic Mail Distribution for Failed Process Chain

Automatic Notification for Process Chain Status

Creating ABAP Process type to use in Multiple Process chains that Reports Success (or) Failure

Creating Email Alerts for Process Chains Applies

Different types of Alerts for Process Chains

Enhanced Decision Process Type for BW Process Chains

Errors while Sending Packages from OLTP to BI (One of Error at the Time of Data Loads through Process Chains)

Event Based Extract Generation using a Process Chain in SAP BW

Executing APD in Process Chain

How to Trigger Process Chain from Enterprise Portal

Process Chain Log Deletion

Process Chain Monitoring: RSPCM Overview and Steps to add Notification Mail

Process Chain Tips

Raising an Event Through a Process Chain to Trigger a Dependent Chain on a Specific Day

Step by Step Approach to Delete and Recreate Secondary Indices in Process Chains

Step by Step Guide to Creating a Process Type to Close an Open Request in a Cube in BI 7.0

Steps to Check in Process Chain if Flat File is Available/ Arrived in BW

Trigger the Process Chain by ABAP Program and how to Schedule ABAP Program as Background Job 

Triggering the Process Chains at Last Day of Every Month using Events

Using Decision Step in Process Chain

Using Selective Deletion in Process Chains

viii) Transports:

This section provides knowledge on the transport management in SAP BI, which includes:

a) Transport Creation and adding objects to it

b) Moving transports from one system to other

c) Regular issues those we face

d) Best Practices

Analyzing and Fix the Failed Transports in SAP BW

Collecting Multiple Objects in a Transport through Transport Connection – A Simple way

Detailed View on Transports and the Common Issues in BW 7.0

Display Objects in Transport

How to Handle Inactive Transformations-Transport of Deletions

How to Integrate the Transport Objects between Non-Connected SAP Systems

SAP BW Change Request Management

SAP BW Errors and Fixes for Transports

SAP Transport Procedures and Best Practices

Transporting SAP BW Objects

Transports in SAP BW: Issues and Resolution