SAP - BI
How To Create InfoObjects With Key Figures in SAP BI/BW
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
A standard DSO has three transparent tables on the database.
Process of Data transfer to DSO
Note: the data in Change log table is redundantly stored and can be deleted after the records have been activated.
Creation Of Standard DSO:
Step 1)
Step 2)
Step 3)
Settings in DSO:
Including Key Fields and Data Fields in the DSO:
DSO contains 2 kinds of fields
Key field is used to make the records unique. Other fields can be included as data fields in the DSO,
Step 1)
Right Click on “Key fields” and choose the option “InfoObject Direct Input”.
Step 2)
The following pop-up opens. Here you can input the technical names of the InfoObjects you have to include and press enter.
Below shown is the Keyfields added in the DSO.
Step 3)
Navigational Attribute would be viewed in the DSO by default, but the check box to ON/OFF Navigational has to be chosen if it is to be used in reporting.
Step 4)
The DSO structure design is complete. Activate the DSO by clicking on the Activate button.
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
Infoset is a special kind of Infoprovider which does not store data physically. In other words,...
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
In this tutorial you will learn about Characteristics Settings – Display Name Characteristics...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...