What is Planning efficiency report in BW/BI?

The plan efficiency reports are needed plant wise, material wise to measure the efficiency of the planning. These are global reports whilst the information need to be collected at factory level. These reports will help a company to Continue reading →

How to give conditions in a BEx query designer

The query designer formulas sometimes involve if then else kind of conditions or case statement type of logic. These type of logic can be easily given in the query designer, however the procedure is little tricky as you cannot Continue reading →

Process chain error due to # character in the file

While loading flat files on application server to BW targets via a process chain, the load to PSA may fail due to special characters in the file.

Thus the info package step itself will fail with Continue reading →

When to use Navigational Attribute in SAP BW

Navigational attributes are discussed a lot of times in BW. They have an advantage as these attributes can be used for navigation in a query. However there are lot many more advantages of navigational attributes. I will discuss today one such scenario where navigational attributes has saved a week’s time. Continue reading →

When to use ‘Summation’ in a Standard DSO

While loading data to a standard DSO, a key figure can be updated as ‘Overwrite’ or ‘Summation’.

With an overwrite option, the previous value of the key figure which is already there in the active table of the DSO will be overwritten with the new value.

Whereas with the ‘Summation’ option, the values will be Continue reading →

How to update exchange rates via process chain in BW

The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain.

Include the step ‘Execute ABAP Program’ in the process chain.

Give the program name as Continue reading →

Currency Conversion from Local Currency to USD in BW

While loading the data from source to SAP BW system, the amount can be in local currency. If the user wants to see those amounts in USD in the BI reports, you can do the currency conversion either in the Continue reading →

ABAP routine for calculating AR buckets using master data look up

In Account receivables, there is a due date on which the outstanding amount has to be paid by the customer.

If the due date is passed and the customer has still not paid, the amount becomes overdue and bucket calculation starts Continue reading →

DTP Performance Improvement: Semantic Groups

Semantic groups can be set in DTP in the extraction tab. These are the fields from the source which are available for selection as semantic keys.


The BW system while doing the loads will Continue reading →

Use of TVARVC table in BW customer exit variable

The TVARVC table serves very handy when we have to do a dynamic selection in BEx queries based on some condition which can change in future.

Usually we write customer exit variable in the query which is filled when the query is being executed.

This customer exit variable can take up any value depending upon the user requirement like Continue reading →