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: Tygojinn Vigal
Country: Papua New Guinea
Language: English (Spanish)
Genre: Automotive
Published (Last): 23 December 2009
Pages: 323
PDF File Size: 16.56 Mb
ePub File Size: 2.95 Mb
ISBN: 279-5-49659-171-7
Downloads: 49185
Price: Free* [*Free Regsitration Required]
Uploader: Kadal

Double-click the InfoSource to create a communication structure. The statement should appear as shown on line Same extractors are used to select data in sao source system as you use to replicate data ih the BI system. If you compare this with other Virtual Providers, this is more generic and offer more flexibility, however you need to put a lot of efforts in implementing this.

Structure In contrast to 3. SinduBindu com 28 January at Limited period offer Hurry-up Enroll Now at Udemy.

SAP BW Data Flow

This transformation converts the source field in to the format of the target. Enter a name and a description,and then click to continue. The first option, InfoObject,is the default—the simple one-to-one mapping. However, it may be necessary to use one or more InfoSources for semantic or complexity reasons. Enter InfoObjects as shown,and then click to save and activate the communication structure. If you do not have transformations that run sequentially, you can model the data flow without InfoSources.


You can define the virtual provider by copying objects. Thank you for sharing such a great information about sap ,very useful to us. In the transformation process, fields are determined for InfoObjects and their values.

Thanks for Information IT online training. 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. This is a very useful post, thank you!

Alex 1 October at Thanks for the great information, was looking for this information from long. Read This Tips inofsource writing resume in slowdown What do employers look for in a resume?

SAP BW – Data Flow

I love your article and you also get sap mm online training sap fscm online training in Hyderabad. If you are dealing with an InfoSource with flexible updating, then the data is updated from the communication structure into the InfoCube into other data targets with the aid of the Update Rules. Your article is very informative, thanks for posting it Work Instructions Step 1.

If you select this indicator, only one source system can be used in the assignment dialog. When you want to load the related data inflsource different datasources to the data targetsInfosource comes into picture. An extensive library of transformation functions that contain business logic can be used here to perform data cleansing and to make the data analyzable.

These keys are used to aggregate the data records during the transformation. Did you acquired lots of links and I see lots of trackbacks??

The DataSource is connected to the target by means of an InfoSource. If this involves complex inter-dependent rules, it may be useful to have more than one InfoSource.


In this case, the data is written straight to the target from the source using a transformation. Report Attrition rate dips in corporate India: A Transformation should consist of at least one transformation ij.

An InfoSource combines quantity of information that logically belongs together, summarized into a single unit. In the Administrator Workbench: Making a great Resume: Modelling window,right-click the InfoSource—demo: Click to activate all transfer rules. Jobs in Meghalaya Jobs in Shillong.

The InfoSource is displayed but is not active yet. The required business rules are executed in the central transformation so that you only have to modify the one transformation in order to change the business rules.

See also Recommendations for Using InfoSources. The required business rules are applied in the subsequent transformation between the InfoSource and the target.

InfoSources with direct updating permit master data to be written directly without update rules into the master data tables. Checking Loaded Characteristic Data. Thanks for sharing this amazing post with us. A status message Communication Struct. Appium training in chennai. Use You use InfoSources if you want to run two or more sequential transformations in the data flow, without storing the data again. In contrast to 3. The following figure shows how InfoSources are integrated into the data flow: