The SAP BW InfoSource is a concept which used to be mandatory in a 3.x dataflow. It is a view that had to be created between the DataSource and InfoProvider. In the BW Processing Transfer Rules, individual DataSource fields are assigned to the corresponding InfoObject of the InfoSource. Here you. SAP BW Data Flow – Learn SAP BW in simple and easy steps starting from Overview of BI Objects − InfoSource, DataStore objects, InfoCube, InfoObjects, and.

Author: Yozshunris Dom
Country: Niger
Language: English (Spanish)
Genre: Technology
Published (Last): 7 August 2004
Pages: 18
PDF File Size: 17.73 Mb
ePub File Size: 20.38 Mb
ISBN: 817-3-17158-577-1
Downloads: 79120
Price: Free* [*Free Regsitration Required]
Uploader: Kikora

In this section,we will write a transfer rule in the ABAP language. Table lists the material per unit sales price and quantity sold. It does not provide any sales revenue data,however.

To improve future query performance,it is recommended that we calculate the sales revenue and save this result in the fact table,rather than calculate the sales revenue during a query run.

The database design in Figure reflects this idea,and the following procedure shows how to implement it.

SAP BW InfoSource | element61

Work Instructions Step 1. In the Administrator Workbench: Select the option Transaction data,and then click to continue. Enter a name and a description,and then click to continue. The InfoSource is displayed but is not active yet. Double-click the InfoSource to create a communication structure.


BW created a communication structure for us automatically based on the characteristic attribute information. A communication structure is needed here so that the data passed by an InfoPackage can feed multiple InfoCubes.

See the note for Screen. Enter InfoObjects as shown,and then click to save and activate the communication structure. You have created the communication structure.

A status message Communication Struct. Now we can clearly see that an InfoSource is simply infoosurce communication structure. Next,let’s create the transfer rules. Modelling window,right-click the InfoSource—demo: Click to pass the message.

BW proposes a transfer structure based on the information of the communication structure. You can use these four fields as selection conditions when loading data using an InfoPackage.

Under the Transfer rules tab,the simple one-to-one mappings appear in the left table,called Communication str. The first option, InfoObject,is the default—the simple one-to-one mapping. The second option,allows us to specify a constant.

SAP BW Data Flow

Enter a name for the Transfer routine,select the option All fields,and then click to continue. The statement should appear as shown on line Click to check the ABAP routine. If it is valid,click to save it. Click to return to the main screen. The cell icon changes from to. Click to activate all transfer rules.

You have created transfer rules. Sap Bw Interview Questions. Sap Bw Practice Tests. Jobs in Meghalaya Jobs in Shillong. Making a great Resume: How to design your resume? Have you ever lie on your resume?


Read This Tips for gi resume in slowdown What do employers look for in a resume? Interview Tips 5 ways to be authentic in an interview Tips to help you face your job interview Top 10 commonly asked BPO Interview questions 5 things you should never talk in any job interview Best job interview tips for job seekers 7 Tips to recruit the right candidates in 5 Important interview questions techies fumble most What are avoidable questions in an Interview?

Top 10 facts why you need a cover letter? Report Attrition rate dips in corporate India: Survey Most Productive year for Staffing: Study The impact of Demonetization across sectors Most important skills required to get hired How startups are innovating un interview formats Does chemistry workout in job interviews?

use of infosource in SAP BI 7.0

Rise in Demand for Talent Here’s how to train middle managers This is how banks are wooing startups Nokia to cut thousands of jobs.

Checking Loaded Characteristic Data. Ingosource Data Quality Summary.