Show TOC

Creating InfoSourcesLocate this document in the navigation structure

You create an InfoSource to join two transformations.

Prerequisites

You are using a SAP HANA database. If you are not using a SAP HANA database, create your InfoSources in the Data Warehousing Workbench.

You have BW back end version 7.5 SPS04 or higher installed.

Context

When you create InfoSources, you assign them to an InfoArea in the BW Modeling Tools.

Note InfoSources created in the Data Warehousing Workbench are assigned to application components. These InfoSources are displayed in the BW Modelling Tools under the NODESNOTCONNECTED node and can be assigned to other InfoAreas either by drag & drop or using the Move… function in the context menu. In Data Warehousing Workbench, the InfoSources are still displayed under application components in order to ensure compatibility.

Procedure

  1. You are in the BW Modeling tools. Open the context menu for your BW project here and choose Start of the navigation path New Next navigation step  InfoSource End of the navigation path. You will be guided through the process by a wizard. More information: Creating InfoSources Using the Wizard
  2. The General tab opens.
  3. If you set the Aggregation flag, the incoming data will be aggregated with regard to the key.
  4. If you set the like DataStore object (classic) flag, InfoObject 0RECORDMODE will be added to the InfoSource. The aggregation behaviour is the same as for a DataStore object (classic).
  5. On the Details tab, select the InfoObjects that you want to be included in the InfoSource and/or create the fields.
  6. Under Manage Keys, you can define keys for the InfoSource.
  7. Activate the InfoSource.