SAP - BI
How to Load Transaction Data from Flat File in SAP BI/BW
We will learn how to load transactional data from a Flat File with the help of a scenario....
Step 1)
Step 2)
Step 3)
On completion of the above step, it takes you to the “Edit Screen” of the Infoobject. The Infoobject “Edit Screen” has 6 Tab pages listed below.
Let us see each of the tab pages individually.
In this Tab Page, enter the following
All other settings in this tab and other tabs are optional.
In the screen shot shown below, the Characteristic has master data table(With master data check box is checked) but does not have Text table(With Texts is unchecked).
A hierarchy indicates a parent-child relationship which consists of several nodes and leaves.
On the Hierarchy tab page, you determine whether or not the characteristic can have hierarchies and, if so, what properties these hierarchies are allowed to have.
If the “With” hierarchies checkbox is checked, hierarchies can be created for this characteristic. In the below screen shot, the check box is unchecked, hence no hierarchy is created for this info object.
Hierarchy can be created manually or loaded from the SAP system or other non sap source systems. Hierarchy can be used to drill down or extract specific information about the business item.
Example: A real time scenario when Hierarchy can be used is as follows,
Assume in the case of a bank, the relationship between the main bank and the various branches under a bank can be maintained in the form of hierarchy. Where you can extract the information of customer details at any branch about its account, loan, due dates for loan payment and so on.
Attributes are nothing but the fields or properties of master data, there are different types of attributes like display attributes, navigational attributes, executive attributes, compound attributes and so on.
On this tab page, you determine whether or not the characteristic is to be compounded to other InfoObjects. You often need to compound characteristic values to enable characteristic values to be uniquely assigned. Some Info-objects cannot be defined without compounding, also in order to map the data-model you have to compound Info-Objects sometime. If the info-object is defined as an attributes, it cannot be included as compounding object.
Say, for example, cost center 1000 stands for sales and distribution in controlling area 10, and it also stands for sales in controlling area 20. In this case, you would define a cost center to controlling area characteristic Compounding.
Now save and Activate the Infoobject.
We will learn how to load transactional data from a Flat File with the help of a scenario....
BI Content: BI Content provides selected roles within a company with the information that they...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
What is Schema ? In database management system (DBMS), the schema represents relational database. It...
Step 1) Creating a Generic Data Source for Text InfoObject Right click on the BI Source System ->...