Steps to Debug Routines in BI Transformations

This article explains the Debugging process for routines in Transformations. It helps us to trace the errors crept in Routines in the debug mode, so that it can be handled effectively.

Link to Article

PDF Download link.

Do read it...

Changing the Source System Assignments in SAP BW

CHANGING THE SOURCE SYSTEM ASSIGNMENTS IN SAP BW OBJECTS WITHOUT AFFECTING THE DATA MODELING

Nitesh Verma (Capgemini)    Article     (PDF 434 KB)     05 April 2010

This document gives you the idea about how to change the source system assignment details in the mapping of all the datasources, transfer rules etc. without affecting any rules.


Link to article.


PDF Download Link

~~~*~~~

Avoiding Hard Coding in Routines and Make Routines Flexible

The idea behind this article was to introduce an approach for all development projects if there is any hard coding required as a part of development, those entries can be maintained in this table and we can have a central place for all such entries. So that in future if those hard coded entries require any change, this can be done just by changing the table entry.

Link to Article

Download PDF

Note: Other possible way is to Maintain in TVARV table and writing simple select statement on them in the routine. (RJS)

~~~*~~~

Exception Aggregation in Business Explorer

Here in this paper we explore the concept of exception aggregation in business explorer in detail. We analyze various available options in exception aggregation tab and how they work.

As the name signifies is used to aggregate (sum up) the result of a key figure in a different manner than standard OLAP functionality. It aggregates the key keyfigures depending upon some characteristic value. In other words Exception Aggregation counts the occurrences of a key figure value relative to one or more other characteristics.

Link to Article

Download PDF

~~~*~~~

Using Customer Exit Variables in SAP BI.

This Document gives you a clear understanding on How to use Customer exit Charecteristic value,Text variables in BEx Query Designer.

Link to Article


PDF Download

Dynamic Authorization Concept and Role Assignment

Merlin Alwyn and Sandhya Mohan (Infosys)    Article     (PDF 311 KB)     10 March 2010


The Dynamic authorization concept is used to maintain Single roles and profiles for different end users. The key parameters for dynamic authorization can be any of the following: DSO, Master data table or a customized table. This document describes the procedure and set up for Dynamic Authorization and Role Assignment in a step-by-step manner.

Link to the Article.

PDF Download

CREATING FORMATTED REPORTS USING BEX REPORT DESIGNER

Gopalakrishnan Venkatachalam (Global Softech Inc)    Article     (PDF 565 KB)     05 March 2010

This paper outlines the steps to create a formatted report using Report Designer. This report can be displayed on the web or can be converted into a PDF document to print or distribute.

Link to the article.

Download pdf Link

Something about BPC

Why should user use Business Rule (Table Based Logic) instead of Script Logic in the SAP BPC?

via SAP Developer Network SAP Weblogs by James Lim on 3/8/10

This blog article will explan why we should use Business Rule(Table based logic) instead of script logic of BPC.

Link to the Article.