SAP BI LOVERS: SDN BLOGS

Useful links for SAP BW

SDN Articles - Integrated Planning

List Of Articles:

This video demonstrates step-by-step how to create simple Integrated Planning application. The video designated especially for IP beginners.

Integrated Planning For Beginners - Part 1

Beginner’s Guide: Create a Custom ‘Copy’ Planning Function Type

Business Intelligence Integrated Planning in SAP NetWeaver 7.0

Copying data from Actual to Planned cube in a Multi Provider using Copy function in BI Integrated Planning

Fox Formula in SAP BI-Integrated Planning

Planning Functions and Characteristic Relationship in Integrated Planning

SDN Articles - BI Modelling

List Of Articles:

1) Data Source

Better View of Data Source Features in BW 7.0

Data Source Replication and Activation of Transfer Structures

Explore Data Sources in BW 7.0 - Part I

Exploring Data Sources – Part 2

2) DSO (Data Store Object)

Step by Step Procedure for DSO Creation

Understanding DSO (DataStore Object) Part 1: Standard DSO

Understanding DSO (DataStore Object) Part 1: Standard DSO

Understanding DSO (DataStore Object) Part 3: Direct Update DSO

3) Info Cube

InfoProvider Redesign Functions- Part 1: Repartitioning

InfoProvider Redesign Functions- Part 2: Remodeling

Logical Data Partitioning of the Info-Cubes

Reading Enhanced DataSource Fields for the Remote Cube

SAP BI - Virtual Infocube based on Function Module (Transport History)

Step-By-Step Guide to Virtual InfoCube Implementation

Virtual InfoCube - Implementation in BW 7.0

SAP BI Positioning the InfoCube in BI

Info Cube creation Step by Step in SAP BI

4) Info Objects

Compounding in Infoobject and Analyzing the Infoobject in a Query

Creating New Unit of Measure in SAP BW

Creation of Key Figures with Higher Decimal Place Precision

Different Types of Characteristic Info Object Tables and its Structures in SAP BI 7.0

How to Enable Authorization on Navigational Attribute

5) Info Set

Better View of InfoSets in SAP BW

Copying Queries Between InfoSets

Interpreting Query Results using InfoSets and the Concept of Temporal Join with Practical Scenarios

Steps to Create Infoset using InfoObject and DSO

6) Multi Provider

Consistency Issues in MultiProviders - BI 7.0

Multi Provider Creation Based on Sales and Planning Info Cubes

Step by Step procedure for multi provider creation

7) Open Hub Destination (OHD) and APD

Analysis Process Designer - Step by Step Process to Extract Data to a File and Rearranging the Columns Using Transformations

Analysis Process Designer (APD) Illustrated Step-by-Step Implementation Part 1 (using Filter Transformation)

Analysis Process Designer (APD) Illustrated step-by-step implementation Part 2 (using Routine Transformation)

Analysis Process Designer (APD) – Step by Step – Business Intelligence

Analysis Process Designer: Step by Step Process for Formatting the Query Extract

APD to Update Marketing Attributes from SAP BI to SAP CRM

APDs and Open hubs Sending SAP BW Data to 3rd Party

InfoSpokes and OpenHubs in SAP BI Insert Custom Header and Remove Trailing Commas from APD Generated (or any)-CSV file

Join and Union options in APD

Open Hub Destination - Basics

Open Hub Destination - Make use of Navigational Attributes

Open Hub Destination-Use Same Logical Path for Multiple Directories

SAP BW Infospoke – Dynamic Update Selection Screen Values

8) RDA (Realtime Data Acquistition)

How to do Real-Time Data Acquisition trough Web Service (Push Method)

Real Time Data Acquisition (RDA) – Overview and Step-by-Step Guide (SAPI and Web Services)

RDA – Step by Step

Real Time Data Acquisition (RDA) Steps - Business Intelligence

9) Miscellaneous

0RECORDMODE and Delta Type Concepts in Delta Management

Record Mode Concept in Delta Management

Aggregation of Key Figures

ALE Settings for Communication between a BW System and an SAP System

Basics of Non – Cumulative Key Figures

Direct Access to Source System Data using VirtualProviders

SAP BW - Virtual Characteristic (Multiprovider & Infoset) - RSR_OLAP_BADI

SDN Articles - BI Extraction

List Of Articles:

1) DB Connect

DB Connect with Delta Mechanism

DB Connect in SAP BI

2) Extraction from R3

Checking the Data using Extractor Checker (RSA3) in ECC Delta and Repeat Delta etc...

Data Flow from LBWQ/SMQ1 to RSA7 in ECC (Records Comparison).

Data Flow from LBWQ/SMQ1 to RSA7 in ECC and Delta Extraction in BI

DELTA QUEUE DEMYSTIFICATION

Dynamic Call Specific R/3 Datasource Using Same Exit

Extractor in R/3 and Delta Queue

TRANSACTION LBWR

2.a) COPA Extraction

How to do COPA Extraction

COPA Extraction Step by Step

2.b) Generic Extraction

Extractor for Multi Value Class Characteristic Values using Function Module

Functional Module Based Delta Enabled Generic Datasource

Functional Module Based Generic Datasource Part I

Generic DataSource on CDHDR and CDPOS Tables

How to Create a Generic Data Source Based on a Custom View and Further Enhance the Data Source for BW Extraction

How to Create View on Different Tables and Load Data through Generic Datasource based on that View

Step by Step Guide to Extract Batch Master Data via Generic and Classification Datasource to BW

Safety Intervals in Generic Delta – How to Guide

How to Implement BAdI for Enhancing the Datasource in ECC

SAP BW - Generic Datasource Function Module (Multiple Delta Fields)

Step by Step Procedure to Extract Data from R3 to BI 7.0 using Generic DataSource

Step by Step Procedure to Extract Data from R/3 to BI 7.0 using Query

Steps to Activate ALE Delta for Custom Master Datasource Created on ZTable

Using Timestamps in Generic Delta Extraction by Function Module

2.c) LO Extraction

A Treatise on Logistics Data Extraction for Business Information Reporting

Data Flow During Different Update Mode in LO Cockpit

Enhancing LO DataSource – Step by Step

LO Extraction – Part 1: SD Application Short Overview

LO Extraction – Part 2 Database Update Logic

LO Extraction: Part 3 Extractor Logic

LO Extraction – Part 4 Update Methods

LO Extraction Part 5 - Sales and Distribution (SD) Datasource Overview

LO Extraction - Part 6 Implementation Methodology

LO Extraction – Part 7 Enhancing LO Data Source

LO Extraction – Part 8 Post Implementation and Support Issues

3) Flat File Loading

Data Upload from Flat File to Business Intelligence 7.0 System

Flat File Upload – Considerations - Preliminary Program

Flat File Load Mechanism in SAP

Making Flat File Data Sources Delta Capable by Using Routine in Infopackage Selection

Step by Step Guide - How to Copy Flat File from Other Application Server to BI and Load through Info Package

Step by Step Procedure for Loading of Data From the Flat File to the Master Data/Text Tables

Step by Step Procedures to Load Master Data (Attribute and Text) from FlatFile in BI 7.0

Flat File Upload – Considerations - Preliminary Program

4) UD Connect

How to Configure UD Connect on the J2EE Server for External Databases (NW2004)

How to Transfer Data from SYBASE to BI Using UD Connect

5) XML Services

XML Data Extraction

SDN Articles - BI Loading

List Of Articles:

1) Data Transfer Process (DTP) :

Copy Existing DTP to a New One(SAP BI 7.0)

Explore to the Extraction Tab of Data Transfer Process in SAP BI 7.0

Explore to the Update Tab of Data Transfer Process in SAP BI 7.0

Explore to the Execute Tab of Data Transfer Process in SAP BI 7.0

How to Write a Routine in DTP Selection

Integration Approach of SAP BW 3.x and 7.0 with Data Transfer Process

Maintaining Data Quality in BW using Error Stack

Making Error DTP Work for DSO‘s

SAP BW - Handling Error Stack in DTP

Using Error Stack and Error DTPs in SAP BI 7.0

Why DTP Not IP in SAP BI 7 0

Working with SAP BI 7.0 Data Transfer Process (DTP)

2) Info Package:
Data Selection Types In InfoPackage

How to Write a Routine for 0CALDAY in InfoPackage Selection

How to Write a Routine for 0FISCPER in InfoPackage Selection

Implementing Dynamic Filters in Infopackage - Two Scenarios

3) Transfomrations:

Currency Conversion in BI 7.0

How To Using Expert Routine in Transformation

How to Write Start Routine in Update Rules, Transformations and How to Debug the Routines

Routines in Transformations in SAP BI 7.0

SAP BI Transformation – Rule Type

SAP BW Transformation - Displaying Custom Messages in Data load Monitor

Step by Step Approach for End Routine with Look Up

Transfer Rule or Transformation Migration within the Same BI System

Transformation Rules for SAP BI

4) Miscellaneous

Architecture for Extracting the Custom Hierarchies from Sap R/3 System into BW System

Data Loading Strategy for Global Data Warehousing Implementation

Extracting SAP ECC Compounding Hierarchies into SAP BI using Custom Datasource

Flat File Interface from SAP BW to External System

How Second Level Delta Machenisam in 3.x and 7.x

How to Automate Loading Hierarchies from R3 _ECC

How to Load Hierarchy from Flat File

Loading Hierarchies Using a Process Chain

Program to Activate Transformation and DTP

Restricting Invalid Characters from Loading into SAP BI 7.0

Special Characters in BI

Technical Aspect of Hierarchy in BW

SDN Articles - BI Reporting

This page will provide the collection very good articles related BI Reporting from SDN.

List Of Articles:

1) Query Designer:

a) Customer Exists:

How to Provide Proxy Authorization using Customer Exit variable

SAP BI Analysis Authorization (Customer Exit Variables)

Using Customer Exit Variables in BW Reports Part - 1

How to Use Customer Exit Variables in BW/BI Reports: Part 2

Using Customer Exit Variables in BW/BI Reports Part - 3

Using Customer Exit Variables in BW Reports Part - 4

Using Customer Exit Variables in BW Reports Part - 5

Using Customer Exit Variables in BW Reports Part - 6

Using Customer Exit Variables in BW Reports Part - 7

Using Customer Exit Variables in BW Reports Part - 8

Using Customer Exit Variables in BW Reports Part - 9

Using Customer Exit Variables in BW Reports Part - 10

Using Customer Exit Variables in BW Reports Part - 11

Using Customer Exit Variables in BW Reports Part - 12

Using Customer Exit Variables in BW Reports Part - 13

Using Customer Exit Variables in BW Reports Part - 14

Using Customer Exit Variables in BW Reports Part - 15

Using Customer Exit Variables in BW Reports Part - 16

Using Customer Exit Variables in BW Reports Part - 17

Using Customer Exit Variables in BW Reports Part - 18

b) RRI (Report to Report Interface) :

Enhance Report-Report Interface - Create Custom Report Type as Receiver

Fetching Data Directly from ECC System in BEX Query using RRI

Report to Report Interface in SAP BI 7.0

RRI - Parameters Not Transferred to R3 Transaction

SAP BW -- Pass Selection Screen Values using Customer Exit Variables in RRI

c) Series of articles about Query Designer :

Understanding BEx Query Designer- Part-1 Screen Appearance

Understanding BEx Query Designer: Part-2 Structures, Selections and Formulas

Understanding BEx Query Designer: Part-3 Calculated Key Figures and restricted Key Figures

Understanding BEx Query Designer: Part-4 Conditions & Exceptions

Understanding BEx Query Designer: Part-5 Query Element Properties

Understanding BEx Query Designer: Part-6 Simple Query Design

d) Text Variable :

How to Use Text Variables in BW Reports Part - 1

How to Use Text Variables in BW Reports Part - 2

How to use Text Variables in BW Reports Part - 3

e) Miscellaneous

BW Text Variables of Type Replacement Path

Calculating the Difference between Created Date and Changed Date in BW-BI Reports

Change the Query Cache Mode

Creating Bucket Scenarios using Exception Aggregation (SAP Netweaver 7.0 BI)

Customer Exit Variables in SAP BW_BI Reports – First day of the Current_ Previous Month

How can a Reference Query Be used?

How to Create Variable for a Given Key Figure

How to Get the List of Queries Having a Particular Variable, Infoobject

How to Make Conditions and Exceptions Work Based on User Defined Values at the Time of Report Execution

How to use Boolean Operations in the Formula as Subsidiary for “IF” Condition

How to Use Cell Definition to Calculate Incentive of Salesmen

Inconsistencies on Reusable Query Elements (Objects) – BI 7.0

Master Text data label display in BEx Query

Populating Virtual Characteristic and Highlighting the Values

Replacement Path Explained with an Illustrated Example

SAP BW - Copy Query Between Mismatch Info Providers and Queries

SAP BW - Dynamic Call Customer Exit Variables Using Same Exit

SAP BW - Virtual Characteristic Ext (RSR00002)

Step by Step Guide on How to Use Cell Definition in BEx Query

Step by Step guide to Fiscal Week and Fiscal Quarter

Step by Step Procedure to Create Broadcasters, to Schedule and to Enhance of SAP- BI Queries from Query Designer

Step By Step Process for Virtual Key Figures and Characteristics through BAdi

The Definitive and Complete Method for using Virtual Characteristics and Key Figures in NetWeaver BI

Variable Exit in Sap BI 7.0 - How to Start

2) BEx Analyzer (Report Analyzer) :

How to Use Cell Restrictions in BEx (BI) Reports

Step by Step Procedure of Creating Workbook using Bex Analyzer

Understanding OLAP Processor and RSRT

View the Reports Based on Two Fiscal Definition

3) Web Application Desginer (WAD) :

Customizing SAP Delivered BEx Standard Template

Formatting BEx Workbook Template

How To Build a Fast and Flexible Comment Solution for BEx Web Applications

How to Read Variable Values in WAD 7.0 Using JavaScript

Using Radio Button in Web Template

WAD Web Item and Parameter Modification Web Application Designer – Tips and Tricks to use Commands

SDN Articles - BI Related ABAP

List Of Articles:

i) Data Source Enhancements:

Enhancing / Modifying Multiple Data Sources in Parallel

How to Implement BAdI for Enhancing the Datasource in ECC

How To Use ABAP Classes Instead of “CMOD” for BW Datasource Enhancements

SAP BW Data Source Enhancement

Step by Step Guide to DataSource Enhancement – BAdI Approach

Step by Step Guide to Enhance a Datasource

Step By Step Procedure to Enhance Standard BI/BW Extractor Using BADI

iii) Routines:

Create Monitor Entries in BI Using Start Routine

Customizing Built In Formulas

Implementation and Usage of Expert Routine in SAP BI 7.0

Implementation and Usage of Transformation End Routine in SAP BI 7.0

Integrating Custom Formulas into Formula Builder in SAP BI 7.0

Routines in SAP BI 7.0 Transformations

Using Return Table in Update Rules

Using Rule Group in SAP-BI. Part - 1

Rule Groups in Transformation

How to Write Inverse Routine with Expert Routine

iii) Miscellaneous:

ABAP Code - Email Recipients (Specific Format) – SAP BW Process Chain

ABAP Code - Read SAP BW Infoprovider (Infocube, DSO, Multiprovider) Data using ABAP Code

ABAP Code – To fetch SAP BI Query Data

SAP BI - Virtual Infocube based on Function Module (Transport History)

Replacement for Return Table in BI 7

Role and Scope of ABAP in SAP BI

SAP BW: ABAP Code to Schedule APD in Background

Usage of ABAP in BI

Using OOPS ABAP (Class Concept) in Transformations in SAP BI

SDN Blogs Index - BW Part1

List Of BW Blogs:

How most BW performance support messages are solved

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27033

All embracing inventory Management in BW with special emphasis on Non cumulative and Markers

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26630

How to Fetch Your Info package Details From R/3 System

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26901

3 Easy Steps to Upload an Image into Process Chain Maintenance Screen

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26069

How to save your Listcube selction screen and the output

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26903

Creating Multiple Records using Expert Routine

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26868

BEx Workbooks Size Reduction for Performance Boost up

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26885

Get list of workbooks in roles and queries included in workbooks

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26553

Query searching based on Object name

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26591

Process Chain Monitoring - Approach and Correction

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26274

SAP BI Statistics Installation

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26437

How To Collect a Variant and ABAP Program in a Transport

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26516

Demystifying aggregates in SAP BI 7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26054

Inversion Routines - Making use of Set Objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26414

Getting Number of Partitions for all active Infocubes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26411

Maintain Currency Translation Ratios in OBBS

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26245

Different Options for Debugging BEx Query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26356

Reporting on SAP BW Performance

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26234

RSZELTPROP: The Query Element Parameters Table

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26225

'Force Delta' in BW Dataflows

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26033

All About SAP BW Transport Errors and fixes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26159

SAP BW System Improvement Tips

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26113

BW Technical Content – Deletion of BI Statistics

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26114

Capturing data from BEx Query output and storing in BI/BW Data Targets using Analysis Process Designer (APD)

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25452

Transport History of BW Objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26026

Some of the known reasons of the slow performing Change run

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25723

Why Data Transfer Process (DTP) over Info Package (IP) in SAP BI 7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25907

BW: Restricting the value help in the variables screen of a query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25694

Execute a BW query by excluding values from another BW query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25643

Dissection of a long running Hierarchy Attribute Change run job

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25616

Parameters of table RSFRONTENDINIT - BW's frontend requirements

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25652

Display of totals with Non-cumulative Key figures

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25632

Data Loads from Data Stage to BW

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25622

Periodic Maintenance of RSDDSTATLOGGING Table

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25611

Collection of Dependent Objects in a Transport Request

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25505

Migration of Update Rules, 3.x InfoSources, and Transfer Rules

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25567

BW Transport - Order of Object list

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25550

The concept of Business Intelligence for ALL (part 3 of 3)

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25645

Bizzare Bex Report: Concatenating multiple rows in a single cell

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25440

Avoiding ECC Downtime for LO data source Full Reloads

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25607

How to find the usage of aggregates in Reports

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25407

How to Convert a Standard Info Cube in to a Real-Time Info Cube with Data

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25408

Remodeling on DSO

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25362

Exceptional Broadcasting using Bex in BI7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25374

You don't have to be an expert to write Expert Routine

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25313

SDN Blogs Index - BW Part2

List Of Blogs:

Dependency information of Function Modules in BW transformations and DTPs

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25255

List BEx Analyzer 7.X variables and generate the associated PROCESS_VARIABLES commands

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25185

SAP BW: monitor inactive objects (Multiprovider, Cubes, Update Rules etc.) after the import of transport requests

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25059

General Guidelines for ABAP coding in BW

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24981

Deletion of WDSO (Write-optimized DataStore object) Load requests and active table data without deleting it from target

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24891

How to use ABAP routine in Infopackage, where Fiscal month range is based on current month

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23635

Validate Bex variable values

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23685

Bex variables – where used list

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23395

Filling an Infocube with sample data without loading it!

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23413

How to find the BW 7.0/7.01 Planning URL

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23316

What is the future of Infocubes?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23298

Copy Queries(RSZC) across infoproviders which are slightly different

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23208

DSO activation job log and settings explained

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22933

Performance Improvements for DataStore Objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23048

What actually happens when you schedule a report to run "right-now"?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23005

Overview of BW tables per object type

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22790

Removing Invalid Characters using field routine

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22741

An Introduction to Modern BI

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22568

DSO Transport and Activation performance issue - adding new fields

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19300

Loss Data into infocube after executing report RSDG_CUBE_ACTIVATE

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21973

Counters in Infoproviders - Boon or Bane ?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22174

How to generate a selective deletion program for info provider

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21078

How to get selection criteria in Transformations routines?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21931

How long BEx report in Excel can be?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21530

New SAP Note - 1516916 - RSAU_UPDR_REACTIVATE_ALL doesn't activate inactive upd. Rule

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21498

Summary of BI/BW 7.0 performance improvements

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21339

Optimize the Use of SAP BW Reports

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21323

List of Characteristics and Keyfigures Used in Levels

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21330

SDN Blogs Index - BW Part3

List Of Blogs:

How to get selection criteria in Transformations routines?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21931

Overview of BW 3.x to 7.x migration possibilities per BW objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21950

BW 7.30: Transport support in BW landscapes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20890

How to generate a selective deletion program for info provider

www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21078

Counters in Infoproviders - Boon or Bane ?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22174

Triggering Email to different users using same email setting each with different Query Variants

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21393

Two Frequent Business Warehouse Issues - 1/2: RSTRAN803

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21593

How long BEx report in Excel can be?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21530

New SAP Note - 1516916 - RSAU_UPDR_REACTIVATE_ALL doesn't activate inactive upd. Rule

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21498

Summary of BI/BW 7.0 performance improvements

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21339

SDN Articles - BW Administration

List Of Articles:

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

i) Aggregates:

The below documents will give overview about when to create aggregates and how to create 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 the Analysis Authorizations works and how to create them. How the 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 of it. Back end operations of Attribute Change Run. 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. This also gives information about 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 we perform on info cube like

i) Compression ii) Roll Up and how to do LISTCUBE. This 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 about the daily activities we do in normal BI systems like

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 about the below things

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