Jun 30, 2010

Display Result Row in One Line While Reporting

We often see users wanted to see results in one row while reporting on different Part providers which do not have common chars. This document will go through the steps to make it possible.


Jun 29, 2010

Analyze Query Performance through BI Accelerator.pdf

This paper demonstrates how to load Multiple Hierarchies using one Info Package. This can be done with the help of ABAP using BAPIs.



Jun 22, 2010

Implementing Virtual Infocube Based on Direct Access in SAP BI 7.0

This Article will explain about the basic steps to load the data in a virtual infoprovider using Generic Datasource.


Virtual Characteristics and Key Figures Revisited the Missing Part Debugger

This article main focus will be to explain the missing part of implementing VCKF i.e. How and why to use debugger while implementing Virtual Characteristics and Keyfigures.

May 10, 2010

SAP NetWeaver Business Warehouse on Docupedia

Do you want to know where to find SAP NetWeaver BW documentation on docupedia? Docupedia allows you to edit documentation pages, add comments and to request content. The BW 7.0 Enhancement Package 1 documentation is now located in a dedicated space.

Bex Tip

How to Display Result Row in One Line While Reporting On Multiprovider
via SAP Business Intelligence Articles
on 5/9/10

We often see users wanted to see results in one row while reporting on different Part providers which do not have common chars. This document will go through the steps to make it possible.

Link to Article

Download PDF

Apr 29, 2010

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...

Apr 16, 2010

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


~~~*~~~

Apr 13, 2010

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.



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

~~~*~~~

Apr 12, 2010

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.

~~~*~~~