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: Nikonos Dakree
Country: Netherlands
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 19 November 2011
Pages: 193
PDF File Size: 13.51 Mb
ePub File Size: 19.26 Mb
ISBN: 171-6-54613-614-2
Downloads: 95701
Price: Free* [*Free Regsitration Required]
Uploader: Fenrilabar

SAP BW Data Flow

This is usefull for many people who are reading it. Study The impact of Demonetization across sectors Most important skills required to get hired How startups are innovating with interview formats Does chemistry workout in job interviews?

A non-persistent structure consisting of InfoObjects for joining two transformations. This is a very useful post, thank you!

You can avoid this if the DataSource is the same, it just appears in different source systems. The database design in Figure reflects this idea,and the following procedure shows how to implement it.

Click to pass the message. 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 uploaded data is transformed using transfer rules. For example, you need one transformation to ensure the format and the assignment to InfoObjects and an additional transformation to run the actual business rules.


use of infosource in SAP BI

Enter a name and a description,and then click to continue. You can infoeource the virtual provider by copying objects. Checking Loaded Characteristic Data. 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?

The DataSource is connected directly to the target by means of infosouce transformation. Limited period offer Hurry-up Enroll Now at Udemy. You can connect to non-SAP systems like hierarchical databases.

Use You use InfoSources if you want to run two or more sequential transformations in the data flow, without storing the data again. You have created hi communication structure.

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. Now we can clearly see that an InfoSource is simply a communication structure. See also Recommendations for Using InfoSources.


SAP BW – Data Flow

If this involves complex inter-dependent rules, it may be useful to have more than one InfoSource. This transformation converts the source field in to the format of the target.

Infsoource can connect sources and targets that are independent of this transformation. The data can be local or remote. The second option,allows us to specify a constant. The cell icon changes from to.

Checking Data Quality Summary. These VirtualProviders are based on the data source or an InfoProvider and they take characteristics and key figures of the source. In the Administrator Workbench: The transfer structure is used to transfer data to the BW system. Report Attrition rate dips in corporate India: Work Instructions Step 1. You have created transfer rules. Structure In contrast to 3.