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 →

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.

capture

The BW system while doing the loads will Continue reading →

DTP Error due to date in DD.MM.YYYY format

Many times while doing flat file load, the date in the csv file is given in the format DD.MM.YYYY. When this data is loaded to PSA, it will load without any error. But if we try to load this to further targets via DTP, it will throw invalid date error.

To solve this problem, editing date in the csv file prior to loading is not a practical solution as the file can be huge with many distinct values or there are large number of such files.

Here you need to use a Continue reading →

Dynamic time selection in DTP

In BW modeling in DTP, many times you have to give a filter where you need to select current calendar month or current fiscal month dynamically while loading the data.

Case 1: Filter based on current calendar month

Here you assume that there is a source field having month value. Now you want to load only those records where Continue reading →