SAP - BI
Top 40 SAP BW / BI Interview Questions & Answers
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
In this tutorial you will learn about
Characteristics Settings – Display Name
Characteristics Settings – Display Properties
Key Figure Settings – Display Name
Key Figure Settings – Display Properties
Key Figures – Calculated Key Figure
Key Figures – Restricted Key Figure
By default, when a characteristic is added to the query, it displays the description specified in SAP BW. It is possible to replace this with customized text as follows.
The display option is used to define what data is viewed by user during data selection (in filters) and after report execution.
By default, when a Key Figure is added to the query, it displays the description specified in SAP BW. It is possible to replace this with customized text as follows.
BW does not allow cumulating amount in different units e.g. one rupee to one dollar or one kilogram to one yard. When data exists in multiple currencies / unit, all records must be converted to single currency / unit using Currency Translation / Unit Conversion. The translation can be dynamic (by using selection screen variable) or static (with target currency / unit hardcoded in adjacent screens). Advantage of doing this in SAP BW is that it directly imports the conversion factors available in SAP ERP to SAP BW.
Query Designer gives the flexibility of calculating aggregates as average, summation, minimum,
etc. Similar calculations can also be performed on row-level data.
BW, allows use of formulae, on data coming from InfoProvider, to provide calculated values to user.
e.g. Subtracting Cost from Revenue to calculate Profit
Step 1)
Step 2)
Click on the edit button of properties box to create / edit a local formula
Step 3)
Some of the common operators used in BW include:
If same calculation is required for multiple reports, it can be mapped to the InfoProvider instead of creating it individually in each query. Such key figure is called “Calculated Key Figure” or CKF.
Once defined, it can be dragged into a query like any other key figure. The biggest advantage of this approach is that it facilitates global definitions of common calculated KPIs.
Steps to create a Calculated Key Figure:
Restricted Key Figures (RKF) can be used to selectively apply filters only to a specific KPI in the report, but not to the entire report e.g. split sales into columns like YTD (Year To Date) Sales, PYTD (Previous Year To Date) Sales, etc.
Step 1)
Step 2)
Click on the edit button of properties box to create / edit a RKF
Step 3)
In the subsequent screen, at least one key figure and one characteristic must be entered to make a meaningful RKF.
Like CKF, RKFs are also global to the InfoProvider and can be reused in multiple queries using the same InfoProvider.
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
We will learn the load with the help of a scenario - Load Master data to InfoObject ZMAT (Material...
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...
Infoset is a special kind of Infoprovider which does not store data physically. In other words,...