SDN Articles - BW Administration

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

SDN Blogs Index - BW Part1

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

SDN Blogs Index - BW Part2

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

Hey Kids, it's time to learn BW!

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

Remodeling in SAP BI 7.0

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

SDN Blogs Index - BW Part3

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

SAP BW on HANA

SAP BW on HANA

Informative Blogs:

Info cubes and Data Store Objects ... and HANA

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

SAP In-memory - what is in the bag?

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

Podcast: Straight Talk about HANA with SAP

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

HANA and BW 7.30 - Part 1

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

HANA and BW 7.30 - Part 2

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

Important Questions (with Answers) about SAP's in-memory High-performance Analytic Appliance - HANA

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

SDN Articles - BI Related ABAP

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 Articles - BI Extraction

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

SDN Articles - BI Modelling

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 BIInsert 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 Loading

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) 

SDN Articles - BI Reporting

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 ModificationWeb Application Designer – Tips and Tricks to use Commands