Communication Structure & Transfer Structure in SAP BW

è Communication Structure

The communication structure is localized in the SAP BW and displays the structure of the InfoSource. 

 

è

èIt contains all of the InfoObjects belonging to the InfoSource of the BW system. 

 

Transfer Structure

 

èTransfer Structure is a selection of DataSource fields from a source system. 

 

è

èThe transfer structure provides the BW with all the source system      information available for a business process. 

 

è

èA transfer structure always refers to a DataSource in a source system and an InfoSource in a BW

 

Creating Infopackage in SAP BW

èStep1: Right click on Source system below the selected InfoSource and choose ‘Create Infopackage’. 

 

è

èStep2: Enter Infopackage Description. 

 

è

èStep3: Enter appropriate restrictions in ‘Data Selection’ tab. 

 

Step4: For Flat file data load, enter the path for flat file in ‘External Data’ tab.

 

Step5: Select appropriate processing type in ‘Processing’ tab.

 

Step6: Select Data targets to be loaded in ‘Data Target’ tab. 

 

Step7: Select update type in ‘Update’ tab. 

 

 

Step8: Start Infopackage load in ‘Schedule’ tab. 

 

Creating Update Rule in SAP BW

è 

Step1: Right click on Data Target and then select “Create update rule”. 

è

èStep2: Specify the Update type, update method and unit for key figure calculation. 

è

èStep3: Specify the Update method for the characteristics 

è

èStep4: Specify the Update method for time characteristics. 

è

èStep5: Check and activate the update rule 

For InfoCube we have two update type

l            Addition

l            No Update

There exists three update method for Key figures

l            Source key Fig

l            Formula

l            Routine 

–

Assigning DataSource to InfoSource in SAP BW

è 

Step1: Right click the InfoSource and select ‘Assign DataSource’. 

è

èStep2: Select the Source System of the DataSource. 

è

èStep3: Select the DataSource existing in this source system and confirm assignment. 

Creating InfoSource in SAP BW

èStep1: In InfoSource menu (RSA1 transaction), right click on an Application component and select ‘Create InfSource’. 

è

èStep2: Choose the InfoSource type (Flexible or Direct Update) and provide technical name and description to InfoSource. 

è

èStep3: Enter the InfoObjects to be included in Communication structure. 

è

èStep 4: Save and Activate the InfoSource. 

Creating Flat File Source System in SAP BI/BW

èStep1: In RSA1 transaction, select ‘Source System’. 

è

èStep2: Right click on Source System in right panel and select ‘Create’. 

è

èStep3: Select ‘File System’. 

è

èStep4: Provide a Logical System Name and Source System name. 

Creating InfoSet in SAP BI/BW

è 

Step1: Enter Transaction RSA1. Right Click on InfoArea and select ‘Create InfoSet’. Provide technical name and description for the InfoSet. 

è

èStep2: Choose ODS or InfoObject on which  you want to build InfoSet. 

è

èStep3: Select the characteristics/key figures required in InfoSet design and join the common characteristics via Inner or Left Outer Join. 

è

èStep 4: Save and Activate InfoSet. 

Creating MultiProvider in SAP BI/BW

è 

Step1: Enter Transaction RSA1. Right Click on Infoarea and select ‘Create MultiProvider’. Provide technical name and description for the MultiProvider. 

èStep2: Select Data Targets (InfoCube, ODS and InfoObject or Infosets) on which MultiProvider should be based. 

èStep3: Select the Characteristics which should be part of the MultiProvider design. 

èStep4: Select Time Characteristics and Key figures. 

èStep5: Create dimensions and assign the characteristics to the dimensions. 

èStep6: Identify the characteristics, time characteristics and key figures in ‘Identification’ tab. 

èStep7: Save and Activate the MultiProvider. 

Creating ODS in SAP BW

èStep1: Enter Transaction RSA1. Right click on the InfoArea and choose “Create ODS”. Provide Technical name and description for the ODS. 

è

èStep2: Choose infoobjects in Key field and Data fields of ODS. 

è

èStep3: Adjust ODS settings appropriately. 

è

èStep4: Save and Activate the ODS 

Creating InfoCube in SAP BI/BW

è 

Step1: Enter Transaction RSA1. Right Click on the InfoArea and choose “Create” InfoCube and provide technical name and description for the InfoCube. 

è

èStep2: Select the Characteristics which should be part of the InfoCube design. 

è

èStep3: Select Time Characteristics and Key Figures. 

è

èStep4: Create dimensions and assign the characteristics to the dimensions 

è

èStep5: Save and Activate the InfoCube. 

Creating InfoObject - Key Figure in SAP BI/BW

èStep1: Select the Key figure catalog and right click and select create InfoObject 

è

èStep2: Give the technical name and description for key figure. Mention the template key figure to be used if any 

è

èStep3: In ‘Type/Unit’ tab you specify the key figure properties like data type quantity or amount etc. and relevant unit 

è

èStep4: In ‘Aggregation’ tab you specify the aggregation method for the key figure (summation, average etc) 

è

èStep5: In ‘Additional Properties’ tab you specify the display properties. These properties are applicable to display of data in reports.